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.
"It's a great tool for visualization data, and it's free for engineers."
"The solution is easy to use and flexible."
"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."
"The solution's initial setup isn't too complicated."
"Microsoft BI's dashboards are helpful."
"We have found the solution to be stable."
"SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"We have found the product to be scalable."
"The most valuable features of MicroStrategy are user-friendliness and integration with the different data warehouse systems."
"I think what we're currently excited about is the ability to integrate R. Most of our data scientists use R for their modeling. I heard at one of the sessions, here at MicroStrategy World 2018, that you can put your R scripts directly into MicroStrategy, so any modeling effort that you've done in the past can be transferred into MicroStrategy."
"Comprehensive security control and more."
"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."
"Workstation and Desktop on the client side will speed up some development activities."
"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 mobile for MicroStrategy is the best of all the BI platforms. As a separate product for the mobile device, MicroStrategy is the entire BI platform. It is an enterprise solution, a separate unit, etc."
"The stability of the product is good."
"There are certain features that are only available in the cloud version. It would be beneficial if they could be brought down to the on-premise version without the necessity of using the enterprise SQL database, as that can be very costly. We need more cost-effective features that are available in the cloud to be accessible on-premise."
"Right now, their premium pricing is keeping us out of the premium market. The premium price per user just doesn't make sense for us, but we haven't reached the limit of 500 users to justify the premium."
"Power BI doesn't support some open-source data sources that are new, such as SnowSQL, Iceberg, or ClickHouse."
"We did have some issues building the Microsoft blog."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"The Microsoft BI interface should be simpler and more user-friendly. I find it very difficult to move between their data sources and their analytics section."
"More connections with other systems should be added, which would allow for other integrations."
"From a stability standpoint, from MicroStrategy, I would say it's fairly consistent. I would give it a "B" because there are times where we have issues that are just inexplicable. They go away and then we have no resolution. To me, that's not acceptable. There are just times where our users can't access things and we're not sure why, and that's a problem to me."
"We would really like to see MicroStrategy have some support teams based more in Europe, because for now it seems that there is one person for the whole CE region. That is not exactly what we would like to see. We do know that MicroStrategy supports most places, either in the US or India, but those are different time zones, people, and cultures."
"We have the mobile server. We have not used it. That is because the people on our team have not been trained on it yet, but that is something that we want to do."
"MicroStrategy's mobile dashboard is still not a RESTful design."
"In the developer, there are things that you able to do in a document or a report that you are not able to do in the Dossier."
"If you compare it with Power BI with the DAX language, it would be great to put that into MicroStrategy."
"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 is room for improvement on the graphs."
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.