We performed a comparison between Microsoft BI and MicroStrategy based on our users’ reviews in five categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Users gave Microsoft BI higher ratings. Compared to MicroStrategy, Microsoft BI has slightly better features, and users were happy with the ROI.
"The way data is presented is very valuable. The amount of information that we can get at a glance is also valuable. You can then drill-down and see data from many different angles in the same chart by selecting certain things. Based on the selection, everything changes automatically. If we have four parameters in a particular item, when you select a parameter, the remaining charts on that page automatically change for that particular parameter."
"They find Power BI's data pull mechanism to be sufficient and cost-effective, especially considering the stability it provides. In comparison with other solutions, Power BI stands out as a fantastic choice. Therefore, I would definitely recommend sticking with the Pro license."
"Provides data feeds for enterprise KPI reporting."
"We found the initial setup to be straightforward."
"I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice."
"With the out-of-the-box Data Platform and Business Intelligence ecosystem, you get the entire platform with a single license."
"It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation. Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution. Their technical support is very good. They are extremely responsive, helpful, and hands-on."
"Power BI, once made available, can connect to various data sources, irrespective of the application, whether it be HR or business applications. The bank has many applications, but all eventually need to generate reports for tracking, distribution, or problem-finding based on analysis. Power BI was made available as part of the productivity suite to all businesses, which can connect to their applications and provide the reports and analysis they require."
"We've made it an open BI platform, so that all our business analysts can build their own dashboards and Dossiers."
"Provides seamless integration between browser-based BI and Mobile BI."
"The feature I found most valuable is the drop and drag functionality available."
"The subscription model is excellent. About half of our reporting comes out of the subscription, and from there, the ease of use in dragging and dropping reporting objects."
"The drill-down functionality is also very good."
"We leverage it, not only for reporting but for analytics and also for geospatial reporting."
"Reports are very easy to create. It takes a very short amount of time to build a report, which is very useful."
"In the past, when we had so many legacy systems, with Cognos and others, it was took multiple steps to get what we wanted. Now, it's a seamless integration. We can connect directly, in the form of In-Memory Cubes or live-publish cubes, to the data warehouse, and blend in the data with big data. Not only relational databases, but we can also integrate other third-party files, and create a single-source software."
"Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik."
"Microsoft BI’s integration and visualization could be improved."
"The solution could improve by having more attractive graphical charts."
"There needs to be improved guidance and documentation for the initial setup of Power BI as it currently remains complex."
"SSMS & SSRS."
"They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use."
"It's not user-friendly; more tutorials, training, and better documentation would be helpful."
"Capacity could be improved."
"If you compare it with Power BI with the DAX language, it would be great to put that into MicroStrategy."
"This solution is missing enhanced features in the dashboards."
"With Cube partition (v10.1 and above) scalability has not been an issue, but the Cube publish time, and temporary space consumption while the Cube is being published, has almost doubled during implementation of Cube partition."
"There might be opportunities for reporting or data analysis, perhaps even in the realm of simulation."
"It would be good if it had greater analytics so we could build these visualizations by ourselves with scripts."
"The areas that have room for improvement in MicroStrategy are mainly related to building additional tools. Specifically, the embedding process has been a bit of a struggle."
"Getting our data to work with the tool is where we are having issues."
"They should provide more tutorials and include some project files."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while MicroStrategy is ranked 9th in BI (Business Intelligence) Tools with 155 reviews. Microsoft Power BI is rated 8.0, while MicroStrategy is rated 8.2. The top reviewer of Microsoft Power BI writes "A complete ecosystem with an builtin ETL tool, good integrations with python and R, and support of DAX and Power Query (M languages)". On the other hand, the top reviewer of MicroStrategy writes "A robust solution for powerful data analytics". Microsoft Power BI is most compared with Tableau, Amazon QuickSight, KNIME, Domo and SAS Visual Analytics, whereas MicroStrategy is most compared with Tableau, IBM Cognos, SAP BusinessObjects Business Intelligence Platform, Qlik Sense and Oracle OBIEE. See our MicroStrategy vs. Microsoft Power BI report.
See our list of best BI (Business Intelligence) Tools vendors.
We monitor all BI (Business Intelligence) Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.