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 product is easy to use and simple to navigate."
"Microsoft BI is better than most solutions we have. It's pretty easy to conduct analysis with it."
"Provides a full platform (database, ETL, reporting, analysis, and so on)"
"We like the drag and drop interactability visualization. We really like that. It's user-friendly."
"Power BI allows you to create user defined charts which is really useful."
"The solution integrates with other Microsoft solutions very well."
"It works well with SSAS, which we use to generate all different kinds of trending and analytics reports. Sometimes we use Power Query and DAX to build some aggregations on the Power BI side as well."
"The solution is stable with reasonable performance."
"MicroStrategy's best feature is that it is a user-friendly tool."
"It has had a direct impact on bottomline improvements."
"In the past, when we had so many legacy systems, with Cognos and others, it was took multiple steps to get what we wanted. Now, it's a seamless integration. We can connect directly, in the form of In-Memory Cubes or live-publish cubes, to the data warehouse, and blend in the data with big data. Not only relational databases, but we can also integrate other third-party files, and create a single-source software."
"It drives us away from Excel. For what it is for, it is good. You can't run a business on Excel."
"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."
"Has a great semantic layer."
"There are people who are using MicroStrategy as transaction services."
"I like the user interface and the experience has been great."
"The reporting needs to be improved."
"It should be easier to use when there are multiple system sources."
"It has come a long way in terms of how it was working two years ago, but there are some things that you still can't do with it. For example, permission management and user access management are still a bit limited. It is basically based on the idea that everybody from the organization can see everything or limit the type of data they can see. If I want you to see only one report and the other guy to see another report, I can't do it. There should be a better way to manage permissions and users. It should also support external users much better."
"Microsoft needs to provide more drivers to connect other data sources in a native way."
"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."
"I would like to see better, undisturbed stability without any interruptions."
"Integration with artificial intelligence would help. Humans take time to review the data and eliminate errors. Artificial intelligence based on machine learning and understanding can bring the same functionality."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
"MicroStrategy is dragging behind other tools on the self-service visualizations, like Tableau. I would rate Tableau as a 10. For the same visualizations, I would say MicroStrategy is an eight, maybe nine. They're still behind on the self-service visualizations,"
"There are some challenges in our organization on how we store the data."
"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."
"Data writeback, and on-the-fly predictive analysis results from R and Python could be improved."
"Needs more visualizations out-of-the-box."
"It would be good if it had greater analytics so we could build these visualizations by ourselves with scripts."
"There is room for improvement on the graphs."
"Preparation, data loading and data management application is challenging with MicroStrategy. It lacks cube-based analytics as it is outdated, meaning there is no memory or fast processing analytics or MMA deployment."
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.