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.
"MS SQL & SQL Server Analysis Services."
"My favorite feature is the power query editor, where it can do the data transformations."
"What I have found valuable about Microsoft BI is its performance and ease of use. The interface is very simple and it is accessible to everyone. If someone is new to this type of solution it is straightforward to understand."
"The fact that you can visualize items is great."
"The stability is good."
"There is a lot of help and documentation on the Internet, so no special training is needed to use the source code."
"The solution is very easy to use."
"I like the fact that Power BI lets me use Excel data. At least 90% of my state data is in Excel spreadsheets. Having the ability to just attach a spreadsheet as a data source is very, very important. It's also good for training and teaching. Sometimes you don't always have access to a live production database, so having a spreadsheet with sample data is always nice."
"The single stack solution will always be more profitable, scalable, and elastic for organizational needs."
"Dependency on development teams, as well as managing the platform, has reduced a lot with Visual Insight."
"On our mobile solution you can deploy up to 100,000 users. In our case, we're up to about 10,000 active users, and MicroStrategy's server technology behind the scenes, the Intelligence Server and the Mobile Servers, are very robust and they can handle the workload."
"Semi-automatic support of implementing date dimensions, including delta to prior year implementation."
"The most valuable features are drill down, dashboards, documents, bringing everything under one roof, and visualizations."
"The solution's platform analytics gives us real-time analysis of how a particular user uses the report and how the systems behave."
"It has landing pages, and that makes life easy for exhibiting things."
"Having the intelligence server sit in the middle is huge for us. It is going to save us a lot of time, make our work a lot simpler, make it easier for deployment, and getting the reports in the hands of our users sooner."
"Microsoft is behind IBM when it comes to security features."
"The setup took a lot of tinkering with InfoSec to allow us to do stuff."
"The only challenge I have found is that they do not have a Mac version."
"The one thing that I noticed specifically was the graphical features, and some of the analytical features. They were stronger on the Tableau side."
"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."
"I would like them to provide a license that just allows us to see dashboards. What I don't like about this solution is that in order to just watch a dashboard, you need a license. Currently, you need to purchase a full license of Power BI Pro just to see something, which is not attractive. If you have a license, you can see a shared dashboard, but you can also build a dashboard or you can collaborate with other people. However, if you only want to see a dashboard, there is no license for that. I only want to see the dashboard, and I don't want to do anything more than watching the information on the dashboard. There is no license that allows you to see a shared dashboard. This is one of the areas of opportunity because I would like a lot of people to be able to see a shared dashboard, not to interact with it or to collaborate online with it. I would like to see more compatibility with non-Microsoft data sources. Given the fact that everything is related to Microsoft Azure and all services available on Microsoft Azure, I see that they're building more connections to Microsoft Azure services instead of other non-Microsoft services. I understand the strategy, but it would be good to have more compatibility with non-Microsoft data sources."
"I would like for there to be some type of user manual that shows steps on how to navigate the solution."
"Microsoft BI can improve some of the visual level filters or visual functionality, that are available in other BI tools, such as Tableau or Qlik Sense."
"The product is designed for enterprise. A lightweight version would be easier for a smaller workgroup."
"The solution lacks good visualization. They should work on the user interface to make it more slick and modern."
"MicroStrategy's mobile dashboard is still not a RESTful design."
"With Cube partition (v10.1 and above) scalability has not been an issue, but the Cube publish time, and temporary space consumption while the Cube is being published, has almost doubled during implementation of Cube partition."
"I prefer the capabilities of a single platform, but it does not always work. We are a huge company. Some areas do not use MicroStrategy, so you have to blend whatever systems they are using together to get the data points that you are looking for."
"They need to improve the web."
"Our users tend to say the interface is a pain."
"There might be opportunities for reporting or data analysis, perhaps even in the realm of simulation."
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.
