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."
"It integrates with all of the Microsoft tools."
"Good CS and administration."
"The feature I find most valuable is the ability to publish Power Bi reports, using an embedded link, directly onto a website."
"The scalability overall has been quite good."
"Scalability-wise, I rate the solution a nine out of ten."
"I liked that Microsoft Power BI handles a large amount of data. I can handle hundreds of rows from Postgres in a few minutes. I also like how it detects the relationship between the tables without explicitly saying that. It just detects the relationship automatically. That made it easier to work with the data."
"PowerBI – Self-service BI."
"Has a great semantic layer."
"Dossiers are going to change the name of the game for us. We want to be able to have the executive committee go into a meeting and tell a story. We want them to tell us a story, not us."
"I haven't come across any bugs."
"Mobile brings reports/dashboards closer to the business user."
"It is definitely customizable. We have been able to put in key metrics and performance indicators, thus it is customizable."
"Our primary use case is to deliver all data insights to our company."
"The reporting, the dashboards, and the new visualization functions. It is very easy for users to understand their data and dashboards."
"The ability to create aesthetically pleasing information by providing dashboards."
"The visualization aspect, while being the most visible to business users, also happens the be the weakest point in the entire Microsoft BI stack."
"There are certain features that are only available in the cloud version. It would be beneficial if they could be brought down to the on-premise version without the necessity of using the enterprise SQL database, as that can be very costly. We need more cost-effective features that are available in the cloud to be accessible on-premise."
"I would prefer that the solution not be shared. I'm concerned that if we make a mistake we could reveal information to people who shouldn't see it. I would like to have my own on-prem server, to buy my own server and have my own infrastructure for Microsoft BI, with only with my data."
"I have found using Microsoft BI is not easy. For example, trying to use the auto-refresh feature is not simple."
"Sometimes while developing, the front end is not easily customizable and it has limitations. We cannot go and do any UI we want. We have to stick to the limitations of the product."
"My data is restricted to my DB and I'm not sure how this would handle an extremely large dataset."
"The solution could improve by simplifying the user interface and adding integration or compatibility with APA."
"If you look at the new tool, even though they promised that you could do data modeling, that you could do everything from the Power BI side, if your data is really large in volume, sometimes it doesn't work on the Power BI. More feature testing from their side would certainly help users."
"They need to improve on having more professional, well-equipped premium support."
"There are some challenges in our organization on how we store the data."
"The online community page of the product is an area of concern where improvements are required."
"I don't think that they will, but I'd like to see parallel processing, scalable parallel processing."
"I would like to see the enterprise version available in a demo or as a trial version."
"We haven't invested in the mobile platform. We want to invest, but the problem is the security. We are in the health domain, so we have PHI data."
"Its price should be lower. In terms of features, what we have is quite encompassing right now."
"The solution lacks good visualization. They should work on the user interface to make it more slick and modern."
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.