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 gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite."
"Most of the clients I am interacting with are looking towards Power BI because of the cost and simplicities. It provides an entire feature set and a complete solution. It has tight integration with Office 365, Dynamics 365, Microsoft Technology Stack, and datatypes like R and Python."
"Its ease of use is most valuable."
"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."
"The solution is easy to use and charts can be built quickly with the tools."
"The stability is good."
"The amount of customization that you can do is good, and it's relatively straightforward to do."
"We like the drag and drop interactability visualization. We really like that. It's user-friendly."
"The technical support is quite good."
"It is definitely customizable. We have been able to put in key metrics and performance indicators, thus it is customizable."
"The most valuable features are the Visual Insights and the visualizations."
"We've made it an open BI platform, so that all our business analysts can build their own dashboards and Dossiers."
"Having the analytics capabilities on a single platform."
"Mobile brings reports/dashboards closer to the business user."
"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 of MicroStrategy are user-friendliness and integration with the different data warehouse systems."
"If you have to pull multiple data sources performance is somewhat lacking."
"The solution could use a faster speed on certain interactions and a refresh of the dashboards."
"Trend data and dashboards need improvement."
"The look and feel should be updated in terms of the types of dashboards and graphs that you can produce. They aren't as visual as some of its competitors."
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."
"The DAX features need some improvement. It's not as easy as Excel. They need more DAX formulas."
"It's not really complicated, but I didn't find the things I was looking for. The ones I used to work with within Dash are more open, and there are more choices. But with Power BI, there are only limited types of plots that I can use. For example, when I wanted to put the plots in Power BI, there was no extendable space. You have a limited page where you can place a maximum of three plots in that, and you can't do more than that on a single page. You have to create a new page, a different page for that. That made it a bit annoying, and the filtering part is limited, with basic functions. If you want to make custom filtering or custom functions, you can't do that."
"We did have issues with stability, and that was because we were co-located with another business unit, and we outgrew them on the unit. So we had to get to a separate physical instance."
"MicroStrategy lacks that community support. You're either stuck figuring things out yourself or paying expensive fees to MicroStrategy consultants for help."
"This solution is missing enhanced features in the dashboards."
"One of the things that I want to see MicroStrategy do is become more cloud native. Right now, the deployment on cloud is very easy to ruin, it is very much like spinning up separate VMs."
"It crashes multiple times for even small changes that I make on the fly in the dashboard. After doing all the necessary changes, the MicroStrategy desktop or even the web version kicks the users out, and all the changes are lost. This functionality is buggy in MicroStrategy. It is hard to keep track of all the changes that I have done before. I don't want to make copies of each change that I have made because I would end up creating a hundred dashboards. It is not feasible in a real environment. I haven't worked on integrating MicroStrategy with the cloud. I am not sure how it behaves in the cloud, but I have heard from a few of my friends that there are some hiccups when you kind of sync to the cloud through MicroStrategy."
"It is performing well, but sometimes we have complex requirements and the performance decreases, and then we have to find another way to make it perform again. That is what you encounter when use the project, but that's inevitable because if we would have used another product, we would've had the same thing."
"I want to be able to have one report that's delivered to 30 different people and all 30 different people see something different. Now, you can do that today with metrics. You cannot do that with attributes. There's a component of that which, if an attribute is on granularity-one and another is on granularity-two, and you remove granularity-one, you're now going to be summing to a level that you did not expect before."
"The graphs available for the new dashboard of version 10 are weak."
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, 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.
