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.
"The stability is great and continues to get better and better."
"Ability to extract data from a variety of sources and systems."
"Technical support has been great."
"Reports, dashboards, and visualizations are most valuable."
"The drill-down capabilities and automatic charts are the best ones. The visualization is also very good. In terms of visualization, no competing product, such as IBM Cognos or any other product, has the same capabilities."
"It is a pretty straightforward and flexible solution for data integration and modeling. It is a low-code solution. When you are doing data integration, you can use the GUI, which is very simple and straightforward. You can also do very intricate custom queries and model it at different levels. It is very easy to use and scalable."
"They should add mobile access."
"They find Power BI's data pull mechanism to be sufficient and cost-effective, especially considering the stability it provides. In comparison with other solutions, Power BI stands out as a fantastic choice. Therefore, I would definitely recommend sticking with the Pro license."
"The most valuable feature is the ability to build reports, then customize for different groups instead of having to build multiple reports. Therefore, the ability to build customization in the reports for different groups."
"Tech support has been great, very responsive. We usually hear back within a day. We usually email them and that works out perfect. The right person always gets back to us."
"Project Schema/metadata- Very flexible, connects to a variety of different data sources and is very flexible for many specific tasks. Attributes/metrics/filters created once used by everyone."
"The hyperintelligence is the most valuable feature."
"It keeps BI in the hands of everyone, rather than a developer or an analyst."
"The most important feature is the way it handles ad hoc queries and provides formatted reports."
"The option to use various administrative tools, like Integrity Manager, is a valuable feature."
"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."
"There is no specific area that I have a problem with. It's just that, with whatever feature you come across, every visual has its own formatting and behavior. What you get in one visual for a feature, you don't seem to get in another."
"The only challenge I have found is that they do not have a Mac version."
"I believe there is room for improvement in terms of authentication and certain functionalities in Power BI. For instance, adjusting the width of columns is not easily done, as there is only an option to enable or disable automatic adjustment. This can be a significant drawback for clients who desire more flexibility."
"It would be nice to use other connectors to link with the data."
"The solution could improve by simplifying the user interface and adding integration or compatibility with APA."
"Most of the dashboarding tools have prebuilt graphs. So, you have to stick with them, unless you are going to use a third-party tool to create them, and then you are going to upload them to the BI tool. In Power BI, they started supporting this functionality and created a tool for that, but it isn't yet complete and mature. It is still exceeding the expectations and is better than most of the BI tools when it comes to creating custom graphs, but it needs more enhancement and simplification. It would be good to have a design tool provided by Power BI to design the graphs that we want and set the figures that we want on them."
"It should be more user-friendly and simple."
"BI is scalable, but there are some problems with limited online storage."
"I prefer the capabilities of a single platform, but it does not always work. We are a huge company. Some areas do not use MicroStrategy, so you have to blend whatever systems they are using together to get the data points that you are looking for."
"We're starting to open it up to more and more people to give them the ability and start looking at these things themselves, but it's not the most intuitive system, Enterprise Manager that is, so it's tough. We're trying to bridge the gap between usability and who we let in the system, because you're not going to come in and just pick it up."
"I don't think that they will, but I'd like to see parallel processing, scalable parallel processing."
"They need to supply the support system that's just not there right now. They don't have Enterprise Manager classes. You need in-depth classes to understand what those metrics are doing, to understand the table associations from one to the other. You can't just go and pick it up and understand that DT_DAY connects to all of these tables, without going into Architect, looking at the source tables. I, as a analyst, a slightly technical user, I don't have the expertise to do that. Business users definitely don't have the expertise to do that."
"We have not invested nor are we planning to invest in MicroStrategy's mobile platform."
"MicroStrategy is not cloud native today and some of their APIs are a little limiting."
"I would like to see a single standalone application to control everything from the administration perspective, and also to develop new applications."
"The pricing could be lower because it is costly."
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.