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.
"This product has a lot of features and most of them are user-friendly."
"What Power BI is, is a whole collection of templates of small amounts of data that can be used to do something for a real world project, that can be easily set up and become the business intelligence environment or a data warehouse for a large amount of data, for a real world customer. That's what is remarkable."
"We have found the product to be scalable."
"Implementation is very quick and the solution is very user-friendly."
"In the process of using data there is the Extract, Transform and Load (ETL). For extracting we are using another software, for transforming we are using our own coding in C#, and then we use Microsoft BI for loading the information. Microsoft BI displays information very well."
"The most valuable feature would be the abundance of connectors. It is also easy to use."
"The data can be accessed from anywhere."
"It is really flexible. The charts and reports are really nice. You have the flexibility of self-service."
"I think we have a huge enterprise-wide push to Visual Insight. Our environment has transformed over the last year. We were a strong "grid to PDF," "document to PDF," that's all we did. And then they came in with these Visual Insights and everyone was like, "Wow, that's kind of cool." We created a static reporting portal behind it and now, it's just taken our reports to another level. The level of insight that you get in a 30-second glimpse, it just revolutionized it for us. It gives the user a larger subset of the data so that they can actually maneuver around, rather than being specifically pointed at whatever your document is designed for."
"The platform can be easily monitored. You have quite a good overview of tasks which are being run."
"It's a stand-alone mobile development app that you don't even have to do business intelligence on. You can just use it to build apps."
"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."
"The solution is a very good enterprise tool with excellent enterprise functionality for security and user access. It also works perfectly in distribution, with everyone getting their own reports. It is very complex, so you can do whatever you want. If you want to make some data limitations, you can do it. I also like the internal in-memory engine with the Symantec layer. This makes the solution pretty powerful."
"Technical support is knowledgeable. The right person gets back to us whenever we email them."
"The usability for users to be able to drag and drop, then create their own reports."
"The option to use various administrative tools, like Integrity Manager, is a valuable feature."
"They can improve the user interface a little bit to make it more user-friendly. When creating a dashboard, it is not very user-friendly. You have to click on a certain style and use your keyboard keys to move it. You cannot drag and drop it."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"Defining a relationship was very confusing. There were circular directions for which I had to do a lot of adjustments in the data. They can do something to make it easier."
"It needs more graphics and overlays."
"I'm looking for something that can make it much easier to incorporate Power BI visuals or dashboards into, let's say, Power Apps – custom Power Apps or anything like that. The most important thing would be to seamlessly embed reports in applications. For example, to have buttons that can be navigated through multiple solutions – from Power Apps to Power BI to SharePoint – via links or something like that."
"A few features available in Tableau are not available in Power BI. For example. Tableau has the ability to make up the physical layer and all other stuff at runtime. In Power BI, we have to develop a proper physical layer to connect it. The limitation that we normally face is related to the direct query mode. When it comes to the direct query mode, most of the functionality is not working, which is an issue for us. We have to use the direct query mode frequently because the client needs real-time data. They should work on this limitation. There are a lot of other technical things that need to be improved. I am also following the Power BI platform and Microsoft Support Center platform on the web where users have put their requirements. Microsoft is also working on improving this solution. In every update, they add new features to this solution."
"The solution could improve by providing more free visuals. A lot of them are very nice but you have to purchase them."
"I think that the solution is harder to use for people who are not experts in data."
"They need to improve the web."
"I don't think that they will, but I'd like to see parallel processing, scalable parallel processing."
"The solution's reports are not very flexible."
"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."
"You can now do data blending at the document level and data blending allows you to show results from different data sets in one grid, so to speak. I want to be able to create a data set that can receive data from multiple cubes, have it in one data set, and then bring it to the document, because then I can reuse it for other documents. Now, I have to do it in a document and then it's less reusable, because if I want to share that functionality, I have to copy the document, strip a lot of things, and then work on that basic element that I've built in that document."
"We've found the scalability to be very good. However, it depends on the environment. In general, it could be much better."
"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."
"Getting our data to work with the tool is where we are having issues."
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 Databricks, 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.