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.
"We have found the solution to be stable."
"The solution integrates with other Microsoft solutions very well."
"My favorite feature is the power query editor, where it can do the data transformations."
"I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice."
"It's a great tool for visualization data, and it's free for engineers."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"Microsoft BI was very helpful for me because I had a huge variety of connections. It is very convenient to build reports, even if somebody has no experience using BI tools or data visualizations. Additionally, the performance is very good when generating reports."
"The solution's initial setup isn't too complicated."
"It drives us away from Excel. For what it is for, it is good. You can't run a business on Excel."
"Dossiers are going to change the name of the game for us. We want to be able to have the executive committee go into a meeting and tell a story. We want them to tell us a story, not us."
"The solution is a very good enterprise tool with excellent enterprise functionality for security and user access. It also works perfectly in distribution, with everyone getting their own reports. It is very complex, so you can do whatever you want. If you want to make some data limitations, you can do it. I also like the internal in-memory engine with the Symantec layer. This makes the solution pretty powerful."
"The most important feature is the way it handles ad hoc queries and provides formatted reports."
"Project Schema/metadata- Very flexible, connects to a variety of different data sources and is very flexible for many specific tasks. Attributes/metrics/filters created once used by everyone."
"Technical support is knowledgeable. The right person gets back to us whenever we email them."
"It definitely impacts people, who are excited to use it."
"The drill-down functionality is also very good."
"I cannot comment on the stability as we haven't yet used it for a big project."
"The reporting part of Microsoft BI is rather limited compared to other reporting tools."
"Power BI could be improved by implementing more options for data integration. Nowadays, the cloud takes care of scalability and security. As we all know, data sources are increasing, so we get data from a variety of streams. But if we could get the downstream data into the database and update the reports more easily, Power BI would be better."
"Actionable insights could be better."
"I would like to see integration with Excel."
"I would like to see more AI capabilities in future releases. There's a strong interest in AI, including technologies like GPT, which facilitate real-time interactions."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"Microsoft BI lacks some of the scheme features. It would be beneficial if there were a way to show how we move values in a different way."
"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."
"From a stability standpoint, from MicroStrategy, I would say it's fairly consistent. I would give it a "B" because there are times where we have issues that are just inexplicable. They go away and then we have no resolution. To me, that's not acceptable. There are just times where our users can't access things and we're not sure why, and that's a problem to me."
"MicroStrategy lacks that community support. You're either stuck figuring things out yourself or paying expensive fees to MicroStrategy consultants for help."
"It is actually pretty complicated to use. It is complicated enough that user adaptation is sometimes difficult. We developed more experts rather than people using it."
"If you compare it with Power BI with the DAX language, it would be great to put that into MicroStrategy."
"The In-Memory Capability (cubes) needs a lot of improvement."
"Its price should be lower. In terms of features, what we have is quite encompassing right now."
"I would like to see more Writeback capabilities that would allow our IT department not to be worried about the wild, Wild West of Writeback."
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.