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.
"My favorite feature is the power query editor, where it can do the data transformations."
"The stability is great and continues to get better and better."
"This is a self-service BI tool, so it doesn't require a huge amount of technical training, knowledge, or a background in BI in order to induct new people into it."
"Because this solution is very easy, and very visual, you can have results in minutes."
"You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
"The amount of customization that you can do is good, and it's relatively straightforward to do."
"It's quite flexible, and it's easy to create reports using this system. It is very graphic and very user friendly."
"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."
"I have never had any problems with the stability."
"Semi-automatic support of implementing date dimensions, including delta to prior year implementation."
"It keeps BI in the hands of everyone, rather than a developer or an analyst."
"Tech support has been great, very responsive. We usually hear back within a day. We usually email them and that works out perfect. The right person always gets back to us."
"We are embedding multimedia content in our apps... You can embed streaming video from websites, or you can host the video files on your internal media servers. The video is clear, absolutely."
"The most valuable features are ad hoc reporting and the ability to create dashboards."
"I really like the visualizations. I like how you can put large data sets in there, then the user can quickly go through the data and drill down at various levels to understand things."
"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."
"There needs to be improved guidance and documentation for the initial setup of Power BI as it currently remains complex."
"SSMS & SSRS."
"One thing I would like to have is the scripting language, as they already have within Excel. It's already within a Microsoft business product, because Excel is the number one business product out there. So it would be nice to have the scripting capability in order to automate certain processes."
"I think because I'm moving more into RPA, I'd definitely like to see integration across the RPA, Power BI, or Tableau platforms, because that integration could then make automation and mundane reporting much faster."
"The orchestration module for refreshing data flows is something that is missing and we have to do it manually."
"When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."
"The solution could be more customizable and you do not have too much freedom on the code."
"It needs more graphics and overlays."
"We've found the scalability to be very good. However, it depends on the environment. In general, it could be much better."
"Needs tighter mapping integration."
"Our users tend to say the interface is a pain."
"There needs to be better visualization."
"MicroStrategy should improve migration automation. Additionally, I would like there to be better partnership support."
"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,"
"Getting our data to work with the tool is where we are having issues."
"If you compare it with Power BI with the DAX language, it would be great to put that into MicroStrategy."
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.