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.
"Microsoft BI's most valuable features are the user interface, which is easy to use and light."
"Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards."
"It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs."
"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."
"The scalability overall has been quite good."
"What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
"The Microsoft Power BI app is very good. It's also very flexible."
"What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
"We've made a few enhancements to our Enterprise Manager system to allow self-reporting to grow. We see that as a very useful system. It's been incredibly beneficial in diagnosing production performance issues, diagnosing what reports are running slowly, where the SQL could be optimized, opportunities or metrics where we see long-time running performance. Enterprise Manager has been absolutely vital in giving us some of the insights about our system."
"The platform can be easily monitored. You have quite a good overview of tasks which are being run."
"The drill-down functionality is also very good."
"Comprehensive security control and more."
"The data governance leads people to trust the data that they have, and they know where to get it."
"I really like the visualizations. I like how you can put large data sets in there, then the user can quickly go through the data and drill down at various levels to understand things."
"The usability for users to be able to drag and drop, then create their own reports."
"Semi-automatic support of implementing date dimensions, including delta to prior year implementation."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"From a scalability and performance perspective and based on my understanding and feedback from end users, there's room for improvement in data processing, scaling up, and leveraging the cloud. That could be an enhancement area for me to look into."
"The challenge of this product is in truncating the table data."
"Most clients have MacBooks. Therefore, they use Tableau as Power BI Desktop is not available for the MacBook right now."
"There could be an integrated AI that can automatically analyze some of your data and highlight or provide suggestions. For example, when you are looking at a data set, it can suggest putting it into a certain type of chart so that you gain different insights or a trend line. You would almost have templates that it would recommend for you."
"I think that the solution is harder to use for people who are not experts in data."
"When you go to the cloud, its licensing is not intuitive. It is a little bit complex. When you have to purchase a new license, it is difficult to understand on their website what exactly you need to pay and how you can group. It is something that is applicable to all Microsoft products. They're not always so simple and clear when it comes to licensing. Their support can also be better in terms of explaining how they resolved an issue and what steps they took to resolve it. They are able to resolve the issue, but they can be better at explaining the approach they took to resolve the issue. It could have something in the direction of machine learning. It can have some kind of integration with machine learning where you can ask for some reports with natural language."
"The performance of Microsoft BI could improve for large datasets and it would be beneficial to have more visualization features."
"I don't think that they will, but I'd like to see parallel processing, scalable parallel processing."
"We're starting to open it up to more and more people to give them the ability and start looking at these things themselves, but it's not the most intuitive system, Enterprise Manager that is, so it's tough. We're trying to bridge the gap between usability and who we let in the system, because you're not going to come in and just pick it up."
"Getting our data to work with the tool is where we are having issues."
"I did not see any additional value of providing one button for installation on the whole platform if it was going to be installed for different servers. You would have to make customization every time. There was no additional value in an installer."
"Consolidate the functional offering to be more concise in the front-end for web reports, dashboards, and self-service."
"The In-Memory Capability (cubes) needs a lot of improvement."
"The learning curve is quite steep."
"When we come to them with a problem, they might know more of a generalized solution, but not one targeted to our industry."
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 Databricks, 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.