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."
"Data integration enabled my organization to easily pool data from our varied system into one data warehouse."
"Its seamless integration with Microsoft products, such as Microsoft SQL Server or Microsoft Excel, is the most valuable."
"Microsoft BI is easy to use and to design. I found Microsoft BI a lot easier than Tableau."
"We have found the solution to be stable."
"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."
"Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"The most valuable features of MicroStrategy are user-friendliness and integration with the different data warehouse systems."
"The technical support of MicroStrategy can be helpful through implementation."
"The whole repository side of things is beneficial because you develop it once, and you can use it anywhere, in the Enterprise grade."
"It is one tool which you can find everything. "
"We prefer having the analytic capabilities in a single platform, like MicroStrategy provides, because it is easier. The customer gets used to one type of tool, then sticks with it."
"MicroStrategy's best feature is that it is a user-friendly tool."
"It definitely impacts people, who are excited to use it."
"This solution has allowed us to become a top-class competitor among other consulting companies."
"Integrating it with the physics build model or the engineering model should be included."
"Compared to other applications, like Tableau, Microsoft BI doesn't have as many functions that allow you to do more in-depth analysis and represent the findings."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"I'm missing collaborations functionality to operate or to work connected with multiple people on a data source or on virtualization. There should be more collaborations functions, such as in Confluence. We haven't explored the solution sufficiently in this area, but at this time it doesn't look sufficient."
"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."
"I would like to see a change in the premium capacity."
"I would prefer that the solution not be shared. I'm concerned that if we make a mistake we could reveal information to people who shouldn't see it. I would like to have my own on-prem server, to buy my own server and have my own infrastructure for Microsoft BI, with only with my data."
"My main complaint is that the error messages need to be made more clear. Currently, they are either too generic or outright misleading, and finding the real problem is like searching for a needle in a haystack."
"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."
"Our data warehouse is sort of static; negative load and that is it. It is not as real-time as we would like. We are working on building that out first to create more real-time, at which point we will work on some potential integrations with other applications, but I don't think we are there yet."
"I did not see any additional value of providing one button for installation on the whole platform if it was going to be installed for different servers. You would have to make customization every time. There was no additional value in an installer."
"It needs better visualizations."
"I would try to make it a little more basic, user-friendly. In terms of the UX, it's a bit sluggish there."
"I would like to see the enterprise version available in a demo or as a trial version."
"There are a lot of offerings, and we are not fully using everything to its advantage."
"They should provide more tutorials and include some project files."
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, SAP BusinessObjects Business Intelligence Platform, IBM Cognos, 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.