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.
"There is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
"The best feature for me is Power Query. I know that probably sounds strange, but you can't do too much with visuals and reports if the backend stuff is horribly dirty and just bad. But for me, that is absolutely fantastic. I can load the data and do the transformation and be able to load it in a useful way. There are tons of connections, which is absolutely fantastic as well. It's been fairly easy, and it's intuitive."
"Microsoft BI's initial setup is very straightforward."
"The solution is quite scalable."
"I have found the quick reporting and the conductivity with all the data sources valuable."
"The initial setup is straightforward."
"The interface is very fluid."
"It is always nice to have one solution in a single platform. You can do pretty much everything, instead of having to get a little bit here or a little bit there."
"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."
"The option to use various administrative tools, like Integrity Manager, is a valuable feature."
"The most valuable features are ad hoc reporting and the ability to create dashboards."
"MicroStrategy has what they call the Semantic Graph — an enterprise-grade semantic graph — and I think the technology is fantastic."
"I haven't come across any bugs."
"The product is very mature. It's quite robust and an excellent enterprise-level solution."
"It drives us away from Excel. For what it is for, it is good. You can't run a business on Excel."
"Sluggish performance when handling large amounts of data."
"BI is scalable, but there are some problems with limited online storage."
"The data source definition is all over the place."
"The on-premises version lacks some technical features that are available with the Cloud version."
"I believe the price should be degressive, and we should have a lower, or better unit price if we have more 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."
"There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual."
"If I have to update data automatically, where I have to pin the gateway, it doesn't update. There is a scheduled refresh functionality so that it refreshes automatically, but I find it very hard to make it work."
"Data writeback, and on-the-fly predictive analysis results from R and Python could be improved."
"They need to improve on distribution services. There are lack of features which were there earlier with Narrowcast, but they are not there in the distribution services."
"The In-Memory Capability (cubes) needs a lot of improvement."
"They should provide more tutorials and include some project files."
"If there are some advanced visualization features - maybe I'm not aware of them - but if there were a Vitara which could work on top of MicroStrategy, it would make sense for MicroStrategy to have that within their own library. So they should add more visualizations to the library."
"The web developer tool for documents creation does not have all the features of the client version"
"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."
"We would really like to see MicroStrategy have some support teams based more in Europe, because for now it seems that there is one person for the whole CE region. That is not exactly what we would like to see. We do know that MicroStrategy supports most places, either in the US or India, but those are different time zones, people, and cultures."
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.