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 solution's initial setup isn't too complicated."
"We have found the product to be scalable."
"Power BI is a complete ecosystem. It has an integrated ETL tool and good connectivity with applications such as Office 365 and SQL. There are also solutions for RPA, such as Microsoft Power Automate and Microsoft Power Apps. Power BI now has integration with Power Query, which has an AI feature for text analytics. Text analytics is a very good feature. This feature is also there in Tableau, but I like it in Power BI because you can write something like, "What is the total sale in the Eastern region?", and it will give you the answer. For example, when you have different types of user opinions, you just run one algorithm and you will have the output that provides the number of positive and negative responses. You can even have a dashboard with positive remarks. This feature has been introduced recently. Power BI supports the DAX and Power Query M languages. These languages are making Power BI very strong in data analytics, and you can do many types of analysis."
"PowerBi is used to import our production data and generate dashboards, then integrates other Excel sheets to provide managers dashboards. This helps them get insights to make better OEE improvement decisions, mainly where to focus resources. We became able to see indicators from any time frame (day, week, month, or year), then could make better decisions."
"What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
"In my opinion, Microsoft BI is a low-cost solution, and it could be an interesting solution for a tourism company."
"The good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R."
"The product can go easily go and extract data and it can put it into any format."
"Comprehensive security control and more."
"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."
"We are using mobile analytics, and it is amazing."
"This solution has allowed us to become a top-class competitor among other consulting companies."
"Stability is great, especially with package deployments. It is very consistent and stable."
"I like that they're trying to incorporate Developer into Workstation and Desktop into Workstation, so you get the all-in-one encompassing, highly technical Developer Workstation where you can do the VI, you can do the Dossier."
"The most valuable features are drill down, dashboards, documents, bringing everything under one roof, and visualizations."
"MicroStrategy has what they call the Semantic Graph — an enterprise-grade semantic graph — and I think the technology is fantastic."
"Power BI could have better metadata management. It's easy to use for a single person. However, it lacks an enterprise-grade metadata management system, which can be a problem if you're doing an enterprise deployment with multiple users."
"They asked you to pay if you want to synchronize more than eight times, you would have to go to a Power BI enterprise license, which is much more costly."
"The challenge of this product is in truncating the table data."
"The graphic interface could be better."
"Microsoft has got a very large repository of all change suggestions which have been raised by the BI community. They keep on adding features that are very widely sought after by the community. We don't focus on product features. We focus on business requirements. To use the solution, we find that existing features are good enough and offer us a very effective solution."
"I would like to see better, undisturbed stability without any interruptions."
"I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients."
"SQL Server Reporting Services (SSRS) is not user friendly."
"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."
"They need to improve on distribution services. There are lack of features which were there earlier with Narrowcast, but they are not there in the distribution services."
"The solution's licensing could be improved because its cost is heavy on the pockets."
"The interface you can design in MicroStrategy is great, but I feel it needs to be refreshed, add a bit more functionality. I would like to see more capabilities on the mobile side, to bring it on par with apps that you see in the App Store."
"The online community page of the product is an area of concern where improvements are required."
"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."
"The learning curve is quite steep."
"There are some challenges in our organization on how we store the data."
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 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.