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.
"Considering that it's Microsoft, it can be integrated with the Power Platform, which is also Microsoft-based, like SharePoint, Power apps, Power Automate, and Power BI, which is the most user-friendly."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"The initial setup is easy."
"Previously we used Excel, which took a long time - two or three weeks - to bring the data into a uniform format, whereas BI can do the same job in a day."
"The solution is not that difficult to install, although this will vary with the experience of the person responsible for its installation."
"The stability is good."
"We encourage end users to use Power BI because it's quite easy for them to interact with the menus and the navigation bar. Even for ordinary users, they can create their own dashboard using Power BI."
"It's a very easy-to-use solution."
"MicroStrategy's best feature is that it is a user-friendly tool."
"The hyperintelligence is the most valuable feature."
"It's useful if you need to create dashboards that you check every day. Also, we can create a queue, but it will be updated every day with scheduled updates."
"The most valuable features of MicroStrategy are user-friendliness and integration with the different data warehouse systems."
"MicroStrategy has powerful data security features, which are crucial these days. For example, when users view data in MicroStrategy, they're only allowed to see a portion based on the permissions. When we evaluated other solutions like Power BI or Tableau, we found the security is very poor. They can't help us secure access to the data."
"The solution is a very good enterprise tool with excellent enterprise functionality for security and user access. It also works perfectly in distribution, with everyone getting their own reports. It is very complex, so you can do whatever you want. If you want to make some data limitations, you can do it. I also like the internal in-memory engine with the Symantec layer. This makes the solution pretty powerful."
"Has a great semantic layer."
"The feature I found most valuable is the drop and drag functionality available."
"The integration in Microsoft BI could improve for other solutions, such as Oracle DB and PostgresSQL. Additionally, the reporting from the databases to Microsoft BI should be in real-time and the overall performance could be better."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
"here are some limitations with the data models needed to build the report."
"Microsoft BI's visualization could be better. Though Power BI's visualization has steadily improved over the years, it's not on the level tools like Tableau and SAS or some of the more expensive products on the market."
"The DAX in Microsoft BI is quite difficult."
"Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"I would like to see the enterprise version available in a demo or as a trial version."
"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."
"Lacks decent visualization and the process for creating new objects needs to be simplified."
"Preparation, data loading and data management application is challenging with MicroStrategy. It lacks cube-based analytics as it is outdated, meaning there is no memory or fast processing analytics or MMA deployment."
"I would like to see more integration."
"MicroStrategy needs to do some more development to make the platform easier to use. It's a complicated platform that requires a lot of skill to effectively utilize. So they could work on reducing the complexity to make it more accessible for a broader community of people."
"MicroStrategy should improve migration automation. Additionally, I would like there to be better partnership support."
"The pricing could be lower because it is costly."
Microsoft BI is ranked 1st in BI (Business Intelligence) Tools with 101 reviews while MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews. Microsoft BI is rated 8.0, while MicroStrategy is rated 8.0. The top reviewer of Microsoft BI writes "User friendly, easy to set up and great for analyzing data". On the other hand, the top reviewer of MicroStrategy writes "Good reports, easy to install, and is user-friendly". Microsoft BI is most compared with Amazon QuickSight, Tableau, KNIME, Domo and SAP BusinessObjects Business Intelligence Platform, whereas MicroStrategy is most compared with Tableau, IBM Cognos, SAP BusinessObjects Business Intelligence Platform, Qlik Sense and Oracle OBIEE. See our MicroStrategy vs. Microsoft 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.