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.
"PowerBI – Self-service BI."
"There is continual improvement year-over-year."
"I've seen no issues with BI's stability."
"Its connection to every database: Whatever and wherever it is."
"We like the drag and drop interactability visualization. We really like that. It's user-friendly."
"I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
"It is a powerful tool that helps our data analysis processes."
"It has provided customer purchase patterns and great visualization."
"The dashboard features and functionalities that come through the MicroStrategy Suite are the most valuable. It can be used by end users with minimum knowledge of the product. They can run a report or create a dashboard on their phones, which is kind of cool."
"MicroStrategy's best feature is that it is a user-friendly tool."
"The option to use various administrative tools, like Integrity Manager, is a valuable feature."
"Scalability is fantastic. It can go from a small operation up to a gigantic operation. "
"The single stack solution will always be more profitable, scalable, and elastic for organizational needs."
"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."
"It is always nice to have one solution in a single platform. You can do pretty much everything, instead of having to get a little bit here or a little bit there."
"The most valuable features are ad hoc reporting and the ability to create dashboards."
"It is easy enough. I don't see any real substantial improvements that are needed. It is great as it is, but its interface could be a bit modern."
"Some kind of expression wizard, where the user can build a complex expression without any knowledge of DAX, can be a good addition to the product."
"I would like to see a change in the premium capacity."
"Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. "
"There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work."
"The solution could use a faster speed on certain interactions and a refresh of the dashboards."
"There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual."
"In Microsoft Excel, you are able to have tabs. However, in Microsoft BI you do not have this flexibility."
"You can now do data blending at the document level and data blending allows you to show results from different data sets in one grid, so to speak. I want to be able to create a data set that can receive data from multiple cubes, have it in one data set, and then bring it to the document, because then I can reuse it for other documents. Now, I have to do it in a document and then it's less reusable, because if I want to share that functionality, I have to copy the document, strip a lot of things, and then work on that basic element that I've built in that document."
"I would like to see a feature where migrations are easier. When you migrate from certain environments, it could probably be a little cleaner. Sometimes it seems to be somewhat clunky when you migrate from one environment, say a development to a test or production environment."
"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."
"MicroStrategy should become more user friendly. It should behave more like Tableau."
"Data writeback, and on-the-fly predictive analysis results from R and Python could be improved."
"Another feature to consider in the future would be adding some additional offline capabilities without using desktops."
"There are a lot of offerings, and we are not fully using everything to its advantage."
"They need to improve on having more professional, well-equipped premium support."
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, SAP BusinessObjects Business Intelligence Platform, IBM Cognos, 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.