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 is a feature in Microsoft BI that allows JSON data to SQL on the dashboards effectively and quickly."
"The amount of customization that you can do is good, and it's relatively straightforward to do."
"The interface is very easy to use."
"The initial setup is pretty straightforward."
"PowerBI – Self-service BI."
"It offers a lot of information and is very flexible and interactive."
"Microsoft BI allows us to connect to any database or any dataset."
"The querying capabilities are the most valuable because they allow me to build many automations. We have many workflows and many databases that we work on a daily basis. They need to be updated quite quickly. In order to not to take much of our time doing these updates manually, I have set up these automations using the systems. The process is just to ingest the data and reprocess it. Every time I click a button, everything is updated in almost real time. It is by far the easiest system not only for querying but also for data modeling, data visualization, and deployment. It is light years ahead of Tableau and even Microsoft Excel to do these kinds of things. It is very easy to use and set up, and it has a lot of videos on the internet."
"I have never had any problems with the stability."
"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."
"We've made it an open BI platform, so that all our business analysts can build their own dashboards and Dossiers."
"The technical support of MicroStrategy can be helpful through implementation."
"Now we can collaborate, in real time. In the past we had to wait for our business partners say if a visualization looked good or sufficed for their requirements. There was no real-time decision making. Now, with Dossier, it will accelerate the velocity of decision making."
"Has a great semantic layer."
"Having the analytics capabilities on a single platform."
"The platform can be easily monitored. You have quite a good overview of tasks which are being run."
"Microsoft BI lacks integration capabilities, so it needs to consider increasing its integration capabilities."
"The licensing needs improvement. There needs to be a middle option between Pro and Premium versions."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"The on-premises version lacks some technical features that are available with the Cloud version."
"The setup took a lot of tinkering with InfoSec to allow us to do stuff."
"I am a SAP user and I would like this tool to have more connectors - and to more easily connect to - the ERP or SAP environment."
"The challenge of this product is in truncating the table data."
"It has limited performance capabilities in terms of connecting to large transactional databases, but it is fine for simple and quick queries from Excel spreadsheets or one table. The premium level is going to be more applicable for the higher transaction-level databases."
"The solution lacks good visualization. They should work on the user interface to make it more slick and modern."
"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 graphs available for the new dashboard of version 10 are weak."
"Getting our data to work with the tool is where we are having issues."
"They should give proper industry-based tutorials so that one can learn it easily and implement it based on the requirements. They should give more MMP files so that we can import a whole project altogether and learn from that project."
"There needs to be better visualization."
"MicroStrategy should become more user friendly. It should behave more like Tableau."
"MicroStrategy's mobile dashboard is still not a RESTful design."
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.