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 are some great automation elements in the product."
"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."
"It's a pretty scalable product."
"I like all the tools in Microsoft BI because they all have different purposes. There are a lot of people using Microsoft BI, and everybody is using it. The users have adapted well to the technology."
"SSRS and the Tabular server/Vertipaq engine/DAX are probably the two most valuable components."
"The most valuable feature is that it's easy to use. It's very useful for non-engineers and it is the ultimate solution for providing information and insights. Power BI is the best visualization tool I have ever worked with."
"Easy to use. End-users can make changes to the graphics."
"I like the downloadable visualizations a lot. I think that they give the user a very nice starting point in creating awesome dashboards, with the right way to tell their data story."
"Mobile brings reports/dashboards closer to the business user."
"The platform can be easily monitored. You have quite a good overview of tasks which are being run."
"We pretty much use the knowledge base. We feel that Microstrategy's community is a good forum to use."
"It is one tool which you can find everything. "
"I think what we're currently excited about is the ability to integrate R. Most of our data scientists use R for their modeling. I heard at one of the sessions, here at MicroStrategy World 2018, that you can put your R scripts directly into MicroStrategy, so any modeling effort that you've done in the past can be transferred into MicroStrategy."
"It helps all the store managers and supply chain people to obtain a view of the data and plan the next week, the next month, quarters, and so on."
"It is a good tool to help our customers visually see loads of data."
"I like the user interface and the experience has been great."
"The solution struggles with large amounts of data."
"It is definitely a wonderful analytics tool. However, database ETL, data integration functionality would be absolutely perfect in many cases. Currently, it doesn't get the job done and we need to extract, transform, and load the data from faulty data sets into something more suitable for the deployment of the analytics tool."
"I think that there should be visuals for financial reporting videos. It should just be a plug and play because there is a lot of coding that goes into it with different clients."
"Automation could be improved and performance enhanced."
"Real-time updating needs improvement."
"Better mapping capabilities and easier administration access would be beneficial, especially for understanding who has viewed reports."
"It is too slow. I hope in future it will be a comparable big data tool, such as, for example, Data Lake."
"Capacity could be improved."
"Sometimes, it has become too complex to upgrade and adjust to the ecosystem."
"There are some challenges in our organization on how we store the data."
"I think they're still lacking on customer service. I think historically, MicroStrategy's customer service was a lot better than it is today."
"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."
"The solution's licensing could be improved because its cost is heavy on the pockets."
"MicroStrategy needs to do some more development to make the platform easier to use. It's a complicated platform that requires a lot of skill to effectively utilize. So they could work on reducing the complexity to make it more accessible for a broader community of people."
"They need to supply the support system that's just not there right now. They don't have Enterprise Manager classes. You need in-depth classes to understand what those metrics are doing, to understand the table associations from one to the other. You can't just go and pick it up and understand that DT_DAY connects to all of these tables, without going into Architect, looking at the source tables. I, as a analyst, a slightly technical user, I don't have the expertise to do that. Business users definitely don't have the expertise to do that."
"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,"
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.