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.
"It provides easy integration with Office tools."
"The dashboards of Microsoft BI are easy to use."
"The solution is quite scalable."
"Its connectivity with other Office applications, mostly with Excel, and the ability to deploy it very easily are the most valuable features. It comes sort of bundled with the cloud, so you don't need to set up a server and a standalone infrastructure. So, getting into the system or building something that you can deploy is very easy and very cheap. With other systems, you need to have a server, and you need to have a license for the server. The initial setup is very costly."
"The solution is stable with reasonable performance."
"The interface is very easy to use."
"Power BI allows you to create user defined charts which is really useful."
"The reports are easy to create."
"Building apps is easy. You just drag in your data, and then you drag in all the elements that you want on your app. It's drag and drop design, and then you can customize your visuals. They make it all easy with plug and play widgets."
"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."
"We are using it for operations analysis and sales data analysis."
"It drives us away from Excel. For what it is for, it is good. You can't run a business on Excel."
"In terms of functionality, MicroStrategy is alright. It's a solid BI tool and can handle most tasks you'd expect."
"There are people who are using MicroStrategy as transaction services."
"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 most valuable features of MicroStrategy are user-friendliness and integration with the different data warehouse systems."
"Microsoft needs to do some more research and development to make it more stable."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"Microsoft BI lacks some of the scheme features. It would be beneficial if there were a way to show how we move values in a different way."
"The look is simple, and could be a little more professional."
"Our expectation is putting BI to work in real-time data collection systems in the maritime environment."
"When I create measures, sometimes the error messages aren't clear. It makes me spend more time searching for solutions. I need the error messages to be more specific. So, I would like clearer error messages when creating measures."
"I think that they can add more types of charts because the selection on the desktop version is limited."
"Microsoft BI typically connects to a database, often SQL Server, but it's also capable of connecting to multiple databases, pulling data from them, and allowing for data consolidation. You can then aggregate and generate dashboards and reports from this combined data. Personally, I wouldn't claim to have the expertise to suggest significant changes or additional features, as it functions quite well as is."
"It would be good if it had greater analytics so we could build these visualizations by ourselves with scripts."
"The pricing could be lower because it is costly."
"I don't think that they will, but I'd like to see parallel processing, scalable parallel processing."
"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."
"MicroStrategy's mobile dashboard is still not a RESTful design."
"I did not see any additional value of providing one button for installation on the whole platform if it was going to be installed for different servers. You would have to make customization every time. There was no additional value in an installer."
"It crashes multiple times for even small changes that I make on the fly in the dashboard. After doing all the necessary changes, the MicroStrategy desktop or even the web version kicks the users out, and all the changes are lost. This functionality is buggy in MicroStrategy. It is hard to keep track of all the changes that I have done before. I don't want to make copies of each change that I have made because I would end up creating a hundred dashboards. It is not feasible in a real environment. I haven't worked on integrating MicroStrategy with the cloud. I am not sure how it behaves in the cloud, but I have heard from a few of my friends that there are some hiccups when you kind of sync to the cloud through MicroStrategy."
"Data writeback, and on-the-fly predictive analysis results from R and Python could be improved."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 297 reviews while MicroStrategy is ranked 8th 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.