Microsoft BI is a business intelligence product used for data analysis and generating reports on server-based data. It features unlimited data analysis capacity with its reporting engine, SQL Server Reporting Services alongside ETL, master data management, and data cleansing.
$14
per month per user
Vena
Score 8.3 out of 10
Mid-Size Companies (51-1,000 employees)
Vena Solutions provides a financial process automation solution to automate Corporate Performance Management, accounting and budgeting, Regulatory & Compliance, and other finance-related processes. It is scaled for medium to large-sized organizations.
N/A
Pricing
Microsoft BI (MSBI)
Vena
Editions & Modules
Power BI Pro
$14
per month per user
Power BI Premium
$24
per month per user
Professional
N/A
Complete
N/A
Offerings
Pricing Offerings
Microsoft BI (MSBI)
Vena
Free Trial
No
No
Free/Freemium Version
Yes
No
Premium Consulting/Integration Services
No
Yes
Entry-level Setup Fee
No setup fee
Optional
Additional Details
—
The Professional Plan is the most flexible way to get started quickly and can be added onto as a company grows. The plan includes: Vena Platform, Customer Success Manager, Standard Support and Customer Portal.
Complete Plan includes everything in Professional, plus: Vena Insights, Premium Support, Sandbox Environment, and Expert Managed Services.
For a limited time, new customers who use Microsoft Dynamics 365 Business Central (Online) as their primary ERP can get a free year of Vena and 40% off implementation costs.
Vena also offers special pricing for not for profit organizations. To learn more, speak to an expert.
Microsoft BI is well suited for Stream analytics, easy data integration, report creation and UI/UX designs (limited but what all available are great ones) Microsoft BI may be less appropriate for handling huge number of datasets and difficult queries. It may also be difficult for a company with heavy data.
Does a fantastic job of keeping snapshots of your work and requiring far less horsepower on your local machine. I appreciate the familiarity of the Microsoft Excel front end, especially when you have to adapt models often in a fast-paced environment. I do wish there were easier ways to expand working templates and models on demand to see all selected locations or departments, and to separate tabs for easier comparisons while modeling. Once you learn how it varies from an Excel-only environment, it proves its worth as an enterprise tool.
The race to perfect gathering of Non-Traditional datasets is on-going; with Microsoft arguably not the leader of the pack in this category.
Licensing options for PowerBI visualizations may be a factor. I.e. if you need to implement B2C PowerBI visualizations, the cost is considerably high especially for startups.
Some clients are still resistant putting their data on the cloud, which restricts lots of functionality to Power BI.
Seems like notification capability could be expanded to allow for more customization and flexibility of notifications
Out of the box account reconciliation functionality needs some adjustments: should reconcile total ending balance, not change in balance. Little more intuitive and intentional setup for users to attached supporting documentation.
Need to investigate improved processing power for Insights to ensure even complex dashboards can run quickly.
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
Vena has been a huge win for us as an organization, as it vastly improved our budgeting process by removing manual consolidation that was incredibly time consuming, and it allows us to see a multi-year view of our organizational budget across all of our funding sources. We've seen Vena's platform grow over the years and we've not yet fully adopted some of them so it feels like there's still potential to get even more value out of the platform.
The Microsoft BI tools have great usability for both developers and end users alike. For developers familiar with Visual Studio, there is little learning curve. For those not, the single Visual Studio IDE means not having to learn separate tools for each component. For end-users, the web interface for SSRS is simple to navigate with intuitive controls. For ad-hoc analysis, Excel can connect directly to SSAS and provide a pivot table like experience which is familiar to many users. For database development, there is beginning to be some confusion, as there are now three tool choices (VS, SSMS, Azure Data Studio) for developers. I would like to see Azure Data Studio become the superset of SSMS and eventually supplant it.
I would rate Vena's overall usability as an 8 out of 10. Vena offers a user-friendly interface, especially for those familiar with Excel, making it relatively easy to use. Most features are intuitive. However, some advanced functionalities may require more training or time to master, so it's not a perfect score. Overall, Vena provides a solid user experience that supports efficient financial planning.
Vena has been available and running. There are notifications well ahead of scheduled maintenance and so far, scheduled maintenance has been occurring during off hours and fortunately has not occurred during a time that is crucial for us to be actively using.
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Vena Solutions pages load quickly and only a few times does it get a bit slow, only when there are many integrations and the reports are long. But in general it is always fast and honestly I am very satisfied with the speed in the generation of statistical reports and the pages
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
They are very quick to respond when you submit a ticket and typically fix issues quickly as well. I only didn't give this a 10 because there is still an open issue with our Salesforce connection that we've been waiting on now for a few months.
Our initial in person training was a little rough b/c I felt like our trainer wanted to focus on maximizing Vena rather than understanding what we were needing for our organization. He was very responsive and added insights, but could have worked to understand our needs a little better.
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
The training was structured as a group training to learn the basics of creating a data model and mapping a template. While we had nearly 10 participants, I was the only actual implementer so we probably didn't actually need the training and could have just learned the initial skills from the implementation consultant. Two years later, when we hired a new team member, they completed several modules in Vena Academy (a self paced learning course) which allowed them to get up to speed on the basics with just a bit of supplemental guidance from me as our existing admin.
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
The Vena consultant had great knowledge of both the Vena solution and Excel and Excel functions. He was able to help suggest ways to build our templates that met our requirements using Excel functions we had not previously considered using. And we have been able to use the Excel information he provided in other ways outside of Vena. He was very patient and flexible as we learned the Vena tool and created templates
We have used the built in ConnectWise Manager reports and custom reports. The reports provide static data. PowerBI shows us live data we can drill down into and easily adjust parameters. It's much more useful than a static PDF report.
Vena Solutions stands out due to its familiar Excel-based interface, making it easy for our team to adopt without extensive training. Compared to alternatives like Anaplan and Oracle Hyperion, Vena's strong customer support and efficient automation have significantly reduced our budgeting cycle time. We chose Vena for its seamless integration with our existing systems and substantial time-saving benefits, ultimately enhancing our decision-making process.
Vena solutios is a software that provides robust tools that help different departments in their statistics and we can visualize a lot of promising and visually attractive data. Vena Solutions' level of scalability is high and sustainable over time thanks to the fabulous technical support that is ready to help us at all times
As a SaaS provider we see being able to provide self-service BI to our client users as a competitive advantage. In fact the MSSQL enabled BI is a contributing factor to many winning RFPs we have done for prospective client organisations.
However MSSQL BI requires extensive knowledge and skills to design and develop data warehouses & data models as a foundation to support business analysts and users to interrogate data effectively and efficiently. Often times we find having strong in-house MSSQL expertise is a bless.
