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.
"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 initial setup is straightforward."
"The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive."
"The visuals are great and make everything look very professional. We can change the look and feel or manipulate the data according to our requirements. It's extremely flexible."
"PowerBI – Self-service BI."
"The solution's initial setup isn't too complicated."
"It's a very easy-to-use solution."
"The virtualization of Microsoft BI is very good."
"Visual Insights (VI)"
"We prefer having the analytic capabilities in a single platform, like MicroStrategy provides, because it is easier. The customer gets used to one type of tool, then sticks with it."
"I have shown our users how to stop using Excel. They would create these vast Excel files, and I showed them how to do the same thing with MicroStrategy, which saves a significant amount of time for them everyday."
"Our primary use case is to deliver all data insights to our company."
"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."
"It is easy to use and visually very appealing. One thing that sets it apart is that it has got a great ETL tool. As compared to some of the other solutions, it is much easier to process data from other applications in MicroStrategy. That's why we prefer using it."
"We pretty much use the knowledge base. We feel that Microstrategy's community is a good forum to use."
"The solution's platform analytics gives us real-time analysis of how a particular user uses the report and how the systems behave."
"They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it."
"I would like to see some AI incorporated into this solution in the future."
"From an improvement perspective, I think if the Power BI developers of that platform would really focus on being more detailed and specific on the error messages, it would help a lot of developers troubleshoot and maintain the report ECT or the dashboard ECT."
"In an upcoming release, the solution could be simplified and have a more complete product package rather than a suite of products that we have to put together."
"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."
"In the future, Microsoft BI can be better by increasing user-friendliness"
"The Power Query feature needs to be improved to handle large amounts of data. This feature is also slow for large data transfers making it better to use some kind of script."
"My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."
"Needs tighter mapping integration."
"Data writeback, and on-the-fly predictive analysis results from R and Python could be improved."
"If they can make it more stable, in terms of the connectivity, that would help."
"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."
"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."
"The solution's reports are not very flexible."
"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."
"Lacks decent visualization and the process for creating new objects needs to be simplified."
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.