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.
"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."
"It is stable enough. It has a lot of powerful functions. It can also be customized with the DAX language. It is also intuitive enough and incremental. You can start with something simple, and then step-by-step, you can increase the reports and dashboards according to your needs."
"Key features are its dashboard functionality and ease of integration with various data sources."
"Management reporting solution that's very stable and scalable."
"The product is stable."
"Premium features that used to cost $5,000 per company per month recently became a lot more accessible. Microsoft recently implemented a per user feature in Power BI Premium; it's $20 per month."
"Connectivity, installation, and configuration are pretty fast and seamless compared to Cognos."
"Microsoft BI allows us to connect to any database or any dataset."
"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."
"The technical support is quite good."
"We leverage it, not only for reporting but for analytics and also for geospatial reporting."
"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."
"Has a great semantic layer."
"Provides seamless integration between browser-based BI and Mobile BI."
"Comprehensive security control and more."
"It has had a direct impact on bottomline improvements."
"Real-time refreshing for SAP BW would be nice. We know its on the radar for the development team at MS. "
"I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple."
"It would be better if they had some video tutorials. Most people from an Excel background may struggle with measures in Microsoft BI."
"The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"The way you navigate the product, compared to other products in this industry, that could be improved a bit."
"I have a little problem with Synapse Analytics because it's very new. It's a product that has many capabilities, but it is not very well developed. I have to see the list of permissions from one object. I can't do this in Synapse. I have to search on the web for a solution because I don't have the tool for it."
"Its performance and stability can be improved. It takes time to load, and sometimes, it also breaks down for the whole region. Its usability could also be better, and it could also have more connections with different data sources."
"MicroStrategy lacks that community support. You're either stuck figuring things out yourself or paying expensive fees to MicroStrategy consultants for help."
"MicroStrategy needs to do some more development to make the platform easier to use. It's a complicated platform that requires a lot of skill to effectively utilize. So they could work on reducing the complexity to make it more accessible for a broader community of people."
"When we come to them with a problem, they might know more of a generalized solution, but not one targeted to our industry."
"I would like to see a single standalone application to control everything from the administration perspective, and also to develop new applications."
"There might be opportunities for reporting or data analysis, perhaps even in the realm of simulation."
"MicroStrategy is not cloud native today and some of their APIs are a little limiting."
"The UI seems klutzy with its manual entry."
"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."
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.