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.
Vena is great for managing data and putting all of your information in one easy-to-locate spot. It also makes finding data faster and easier. It is also great for tracking project performance and budgeting. It is fairly user-friendly and easy to use from an admin side.
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.
Preparing forecasts under different scenarios can be challenging. Your input templates need to be set up to toggle between the various scenarios. We found that certain templates, particularly workforce were not able to easily switch between different scenarios.
Connection to Bamboo - initial testing of this resulted in the history being deleted and only showing the current employees. For us it was important to have the history in Vena.
No native connection to Tableau - while a CSV upload is a way around would be great to have this since you already have a Power BI connection.
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 is a strong fit for teams that want to keep working in Excel while adding structure, workflows, and a centralized database. Vena emphasizes its native Excel experience, along with planning templates, workflow automation, and integrations for budgeting/forecasting.
Planful is more positioned as an end-to-end financial performance platform, with a broader emphasis on planning, budgeting, forecasting, reporting, AI/ML-driven forecasting support, real-time collaboration, and enterprise-scale (including multi-entity/multi-currency environments). It also supports Microsoft 365 reporting via Spotlight. We selected Vena because it was a better fit for our current use case and team setup:
Our Operations and FP&A teams primarily use it for budgeting and forecasting, so the Excel-based workflow made adoption easier.
It was easier to implement and simpler for users to learn and operate day-to-day.
It fit well with our need to improve planning structure without forcing a major process change.
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.
Automated monthly financial statements saves us 3 hours a month.
Moving reporting away from IT has begun to save hours of IT involvement, which will only grow as we shift more reports to Vena. This frees up IT to work on more important IT initiatives.
Using budget templates saved hours of copy and paste time when gathering inputs from each department.
