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.
"Being able to transfer data with the Power Query feature is great for teaching with about one to two hundred rows of data. I am also able to see the relationship between multiple tables and create various sheets and dashboards."
"Its data visualization provides the user the ability to quickly look at data and focus on relevant information, allowing them to make an immediate decision."
"The scalability is good. We have 20 people in my organization using this solution and plan to increase usage."
"It's quite flexible, and it's easy to create reports using this system. It is very graphic and very user friendly."
"The DAX coding language is good for creating formulae."
"The solution is very easy to use."
"Ease of development and maintenance."
"It has provided customer purchase patterns and great visualization."
"With the new version that's coming out, I think they have simplified a lot of things. Also, when it comes to the administration part, and sharing, and the collaboration features, they are really great. You can send out comments with a filter to someone in your organization, and if the person clicks on it, he actually sees what you are seeing. So that's really great."
"Stability is great, especially with package deployments. It is very consistent and stable."
"I have never had any problems with the stability."
"The most valuable features are the Visual Insights and the visualizations."
"It's user-friendly, also the MTDI cube is a very good approach, as it helps you to use the pre-format instead of using the standard objects from the schema of MicroStrategy."
"This solution is the most scalable BI platform in the world."
"The data governance leads people to trust the data that they have, and they know where to get it."
"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."
"Power BI's administration could use some work, and the user experience needs to improve because it is a client-based tool. If you want to generate a model or report, you need to use client tools, but client tools are limited for end-users who don't have enough hardware. For example, maybe a client lacks enough memory or CPU power for report generators. If you use a model that requires a massive amount of data, your client will face several problems."
"They can provide a user-friendly and easy way to use this tool for people who don't know about programming or technical things. It will be quite good if they can improve the look and feel and make it simpler to operate. They can make it easier to create some of the reports. They can also include predefined templates that you can directly use."
"From any improvement perspective, I want the product to be made available to users free of cost...The stability and scalability of the product can be better."
"I'm not overly technical, and so I can't really speak to any shortcomings from a technical standpoint."
"It is not yet ready for enterprises. For a big enterprise data model, it is not so stable, and it also doesn't scale so well."
"The integration with third-party products could be more stable."
"We did have some issues building the Microsoft blog."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"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."
"They should give proper industry-based tutorials so that one can learn it easily and implement it based on the requirements. They should give more MMP files so that we can import a whole project altogether and learn from that project."
"Sometimes, it has become too complex to upgrade and adjust to the ecosystem."
"Lacks decent visualization and the process for creating new objects needs to be simplified."
"I think they're still lacking on customer service. I think historically, MicroStrategy's customer service was a lot better than it is today."
"Enterprise Manager should be a little bit less quirky when you build out-of-the-box customization reports for it."
"Its price should be lower. In terms of features, what we have is quite encompassing right now."
"The solution's reports are not very flexible."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while MicroStrategy is ranked 8th 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 Databricks, 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.