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.
"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."
"Everything that's in M Query and DAX is the heart of Power BI because with these tools you can make up for a lot of other missing features."
"It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on."
"The most interesting feature of Microsoft Power BI is that it's very user-friendly."
"Ability to extract data from a variety of sources and systems."
"The drag and drop facility to easily change the data correctly is the most valuable feature. I am happy to see visualizations. It's easier to talk about and make people understand what is going on."
"I find Power BI's reporting feature the most valuable. The solution has improved a lot. There are new features getting added day by day. In the past, they didn't even have the printing feature, but now they have it."
"The user experience is easy. Users get familiar with it quickly."
"The architecture is very solid."
"Comprehensive security control and more."
"It keeps BI in the hands of everyone, rather than a developer or an analyst."
"It has landing pages, and that makes life easy for exhibiting things."
"MicroStrategy's solution for mobile is very good."
"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."
"There's extensive logging capabilities, if something is wrong then we are able to find out why."
"With all the APIs it's very scalable."
"The solution could use a faster speed on certain interactions and a refresh of the dashboards."
"You need to purchase upgraded support separately."
"Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
"Needs single sign-on."
"Maybe they can enhance the UI a bit. Right now, it's very basic, I would say, compared to the MicroStrategy or Qlik."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"SQL Server Reporting Services (SSRS) is not user friendly."
"Microsoft is behind IBM when it comes to security features."
"It needs row-level security, column-level security, on attributes. I want to be able to handle full-scale security model from the semantic layer, flat out."
"I would like to see a single standalone application to control everything from the administration perspective, and also to develop new applications."
"The problem is the way that their metrics are designed. It can be difficult to understand what you're actually looking at. Then when you're comparing a document against the VI, you can't actually do that properly. So there are components, and there is a huge learning curve in the Enterprise Manager space. I think it would benefit them greatly if they were to exercise a significant amount of research and development in that space."
"I would try to make it a little more basic, user-friendly. In terms of the UX, it's a bit sluggish there."
"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."
"We would like access to more storage and access to more metadata to build the right programs that can construct all the stuff for us instead of us having to type it in all the time."
"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."
"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."
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.