Cube vs. Microsoft BI (MSBI) vs. Microsoft Power BI

1) The budget process. In QBO the budgeting capability is non-existant, unless you like manually typing in every scenario and not being able to budget by class. Cube houses my budget/forecast scenarios & lets me view and analyze by my company's preferred data points; department, GL account, vendor, & sales campaign. I'm able to run monthly budget variance reports and plan for the future with ease. 2) We've begun using Cube to help analyze profitablity by sales job. We've never had such easy access to this type of info in the past, so this is a benefit I can directly attribute to Cube. 3) We're beginning now to use an integration with our payroll software to work on headcount planning and payroll analysis.

Microsoft BI has a lot of features and is a very powerful tool, especially if you have folks on your team that know how to utilize all of its capabilities. To truly unlock all that it can do, it does require people to have a deep understanding of its capabilities. That's where the software really shines. If you are looking for a simpler, more basic reporting tool, there are other programs available that do not require such a steep learning curve.

Incentivized

Has significantly improved collation of data and visualisation especially with business across Europe. Has given me the ability to see the Site availability at the click of a button to see which Site is in the "money" and seize opportunities based on Market data

Incentivized

• Push/pull information across any Google Sheet or Excel workbook.
• Budget at a much more granular level (by month by account by the department by vendor).
• Custom mapping to allow for multiple cuts of the same data.
• Bulk range selection within a workbook.

• Comparatively easy to use compared to other data analytics solutions, collaborating with other colleagues on data work is simple.
• Using Visual Studio for database, ETL, reporting, and analytics development save time and money.
• Transfer of data from one application to another via Excel and comparison of data attributes between applications
• Dashboard functionality, as well as Python support, are available, allowing you to add additional charts and graphs.

Incentivized

• Options for data source connections are immense. Not just which sources, but your options for *how* the data is brought in.
• Constant updates (this is both good and bad at times).
• User friendliness. I can get the data connections set up and draft some quick visuals, then release to the target audience and let them expand on it how they want to.

Incentivized

• Limited to 8 top line dimensions. Although you can bring in as many attributes of data as you want, but I would really like Cube to increase top line dimensions to 10.
• The ability for cross level interaction within multiples cube would be a major plus once implemented.

• MSBI designs can work on increasing data processing capabilities enough to handle the huge datasets etc.
• It would be a lot better if it is a little low on cost.
• it needs to create opportunities little more than they do regarding customization of some very unique visualization effects

• It would be easier for users could Microsoft Power BI and Excel used the same programming languages.
• Would like to see the online version of Microsoft Power BI be as powerful as the desktop version.
• Publishing a Microsoft Power BI file online and then having to save the file is somewhat redundant.
• Would like to export each page or chart as an image.

Incentivized

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.

Microsoft Power BI is an excellent and scalable tool. It has a learning curve, but once you get past that, the sky is the limit and you can build from the most simple to the most complex dashboards. I have built everything from simple reports with only a few data points to complex reports with many pages and advanced filtering.

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.

Incentivized

Automating reporting has reduced manual data processing by 50-70%, freeing up analysts for higher-value tasks. A finance team that previously spent 20+ hours per week on Excel-based reports now does it in minutes with Microsoft Power BI's automated Real-time dashboards have shortened decision cycles by 30-40%, enabling leadership to react quickly to sales trends, operational bottlenecks, and customer behavior.

Incentivized

The product has been reliable.

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.

MSBI natively has a site that allows you to vote on user enhancements and bug fixes. This allows the largest nagging issues to float to the top and the development team can prioritize accordingly. As mentioned earlier, the large community base of MSBI developers assist technical resources in handling technical questions.

Incentivized

It is a fantastic tool, you can do almost everything related with data and reports, it is a perfect substitutive of Power Point and Excel with a high evolution and flexibility, and also it is very friendly and easy to share. I think all companies should have Power BI (or other BI tool) in their software package and if they are in the MS Suite, for sure Power BI should be the one due to all the benefits of the MS ecosystem.

Incentivized

This training was more directed toward what the product was capable of rather than actual programming.

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.

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.

It was integrated with our erp easily and was accessible on cloud.

Incentivized

Cube was just a lot easier to use than Vena. We took some time to look at Vena as well and while their product was impressive, our organization was not yet there. We needed something we could implement quickly, and in today's day and age I think that is a very important quality to have. Start up and early stage companies do not have the luxury of implementation teams and massive IT resources so Cube was a huge help.

Incentivized

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.

Incentivized

Microsoft Power BI is free. If I didn't want to create a custom platform (i.e. my organization insisted on an existing platform that I *had* to use), I'd use Microsoft Power BI. For any start-up or SMB, I'd just use Claude & Grok to build it quickly, also for free. Would not pay for Tableau or Sigma anymore. Not worth it at all.

Incentivized

• It has decreased the amount of time it takes to build reports by days
• I can rest easy knowing the knowledge is accurate and there is no human error
• I have been able to create more reports than I ever dreamed of with the new time and ease of use

Incentivized

• 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.

Incentivized

• Power BI usage reduced the effort of analytical reports creation by about 80%
• Empowered all the level of employee to be more vigilant of the data and business insights, gained the profit of 8% overall.
• AI-powered predictive analytics improved forecasting accuracy by 17%, that topped the overall sales.

Incentivized