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.
"I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
"The most valuable feature of this solution is real-time report tracking."
"The initial setup is pretty straightforward."
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"It is good for us for onboarding the data. We can connect to multiple data sources, do transformations to make the data usable, and then model it within the transformation. Someone who has come from a Microsoft Excel environment will easily be able to use this solution. Power query and report modeling are easy to understand in this solution. Their technical support is very good. They are extremely responsive, helpful, and hands-on."
"Its data visualization provides the user the ability to quickly look at data and focus on relevant information, allowing them to make an immediate decision."
"I like Microsoft BI's drill-down feature and its overall ease of use."
"In my experience the scalability is good. You are able to increase users and add more data."
"The scalability is great. It was one of the selling points for us on MicroStrategy."
"The most valuable features are the Visual Insights and the visualizations."
"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."
"It is one tool which you can find everything. "
"The implementation was fairly straightforward."
"The usability for users to be able to drag and drop, then create their own reports."
"Visual Insight gives you the capability of doing self-service analytics. This has been the most powerful and valuable feature."
"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."
"The visual outlet or the visualization aspect can be improved because the settings piece is quite problematic. It requires a lot of time to set the visuals and check. It is quite fiddly to change all the settings and font sizes. It just needs better ability in terms of using templates or visualization templates to get the vision. Our users always benchmark based on the product, and they don't appreciate everything under the bonnet. The only rating is based on the actual reports in the settings for the dashboard. They should make it look a bit funky and a bit more aesthetically pleasing on the eye. It is quite a fiddly tool, but other than that, it is pretty slick. Because it is community-driven, the marketplace tends to be changing forever. You get the standard visualizations, and you've also got all other marketplace visualizations that require you to spend a bit more money and purchase things in the marketplace. With certain visualizations, there is no longevity. I had used certain visualizations, but they discontinued them, and I had to rebuild my reports, which is obviously very frustrating. There should be some sort of stabilization around how the marketplace visuals impact the users when they expire."
"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."
"SQL Server Reporting Services (SSRS) is not user friendly."
"Microsoft Power BI was born native on the cloud, however, it's quite difficult when it has to connect to on-premise data sources."
"The solution struggles with large amounts of data."
"Our expectation is putting BI to work in real-time data collection systems in the maritime environment."
"We have used other solutions and the reporting functionality should be user-friendly and have a drag and drop feature should be available, but Microsoft BI doesn't have these features. When you are creating reports and you can't change as a user. Every time you need one developer or one technical person to make the changes."
"The accounting data needs improvement."
"We have seen some stability issues with MicroStrategy on cloud. We have a few unhappy customers."
"With Cube partition (v10.1 and above) scalability has not been an issue, but the Cube publish time, and temporary space consumption while the Cube is being published, has almost doubled during implementation of Cube partition."
"There is room for improvement on the graphs."
"Sometimes, it has become too complex to upgrade and adjust to the ecosystem."
"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."
"I prefer the capabilities of a single platform, but it does not always work. We are a huge company. Some areas do not use MicroStrategy, so you have to blend whatever systems they are using together to get the data points that you are looking for."
"Native VI on mobile apps and better android support are lacking."
"The product could be improved by adding additional visualization."
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.