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.
"The initial setup is simple to do."
"I have found the quick reporting and the conductivity with all the data sources valuable."
"The amount of customization that you can do is good, and it's relatively straightforward to do."
"Helped identify bad data, enabling the corrections needed to the data for management."
"Users already using Excel can generate new reports and dashboards within minutes."
"Technical support has been great."
"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."
"The DAX coding language is good for creating formulae."
"It's user-friendly, also the MTDI cube is a very good approach, as it helps you to use the pre-format instead of using the standard objects from the schema of MicroStrategy."
"In the past, when we had so many legacy systems, with Cognos and others, it was took multiple steps to get what we wanted. Now, it's a seamless integration. We can connect directly, in the form of In-Memory Cubes or live-publish cubes, to the data warehouse, and blend in the data with big data. Not only relational databases, but we can also integrate other third-party files, and create a single-source software."
"The drill-down functionality is also very good."
"Transaction Services, that was really the part of the tool that made it very compelling for us, because it gave the opportunity to drive action."
"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."
"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."
"The scalability is great. It was one of the selling points for us on MicroStrategy."
"Our primary use case is to deliver all data insights to our company."
"There are some limitations in Power BI; you have to work in the Power BI base. However, if you want something not out-of-the-box and you want something custom, you have to do a lot of work."
"It is easy enough. I don't see any real substantial improvements that are needed. It is great as it is, but its interface could be a bit modern."
"Better mapping capabilities and easier administration access would be beneficial, especially for understanding who has viewed reports."
"Power BI's administration could use some work, and the user experience needs to improve because it is a client-based tool. If you want to generate a model or report, you need to use client tools, but client tools are limited for end-users who don't have enough hardware. For example, maybe a client lacks enough memory or CPU power for report generators. If you use a model that requires a massive amount of data, your client will face several problems."
"Real-time updating needs improvement."
"My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."
"The product could have better analytics capabilities."
"The solution's documentation needs improvement."
"Something I would be interested in is more visualizations, because right now we use SDK to create some. If there were more out-of-the-box options, we would be happy with that."
"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."
"If you do not learn the ins or outs, it can be a difficult tool to use. You could do a PoC and get enough out of it to be able to use it. However, when it comes to administering it, you definitely need the training."
"Needs more visual essence and connectors for the ecosystems, which would be easy to use."
"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."
"I would like to see a feature where migrations are easier. When you migrate from certain environments, it could probably be a little cleaner. Sometimes it seems to be somewhat clunky when you migrate from one environment, say a development to a test or production environment."
"I want to be able to have one report that's delivered to 30 different people and all 30 different people see something different. Now, you can do that today with metrics. You cannot do that with attributes. There's a component of that which, if an attribute is on granularity-one and another is on granularity-two, and you remove granularity-one, you're now going to be summing to a level that you did not expect before."
"It would be good if it had greater analytics so we could build these visualizations by ourselves with scripts."
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.