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 gives you an edge if you are on the Microsoft platform. If you have been using Microsoft products for a long time or if you have the Microsoft infrastructure, this is the right tool for you. It has seamless integration with Microsoft SQL Server and other sources, and you get the best of the three things (SSIS, SSAS, and SSRS) in one suite."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"The virtualization of Microsoft BI is very good."
"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."
"Technical support is quite responsive."
"Good CS and administration."
"Users already using Excel can generate new reports and dashboards within minutes."
"It integrates better with other Microsoft products. It is very easy to use and has very powerful visualizations. It has also got a lot of development going on."
"The usability for users to be able to drag and drop, then create their own reports."
"I think what we're currently excited about is the ability to integrate R. Most of our data scientists use R for their modeling. I heard at one of the sessions, here at MicroStrategy World 2018, that you can put your R scripts directly into MicroStrategy, so any modeling effort that you've done in the past can be transferred into MicroStrategy."
"The most valuable features of MicroStrategy are user-friendliness and integration with the different data warehouse systems."
"Visual Insights (VI)"
"The convenience of it. Having it on the mobile, so someone has it right there in their pocket most of the time."
"The feature I found most valuable is the drop and drag functionality available."
"We have ramped up user adoption."
"The technical support is quite good."
"Real-time updating needs improvement."
"It should have more report outputs. They should expand the report outputs. Its documentation should also be better."
"One opportunity for improvement would be on the Power Query side. As a consultant, I know Power Query is not the main strength of Power BI. It is not where Power BI shines, but many customers use Power Query to do full ETL workloads for deliverable cookies."
"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."
"Microsoft BI could improve by allowing large-size data sources. We have large data sources, and we have problems loading them in Microsoft BI."
"Integration with artificial intelligence would help. Humans take time to review the data and eliminate errors. Artificial intelligence based on machine learning and understanding can bring the same functionality."
"There are some other visuals that are available in the Microsoft marketplace, however, you need to use them via trial and error. There needs to be a write-up about how to use them with a quick guide describing the visual."
"If I compare it to Tableau, I'd say the visualizations can be better. We should have multiple options. By that I mean, while there are multiple options for the visualization, the look and feel of the dashboard when you compare to Tableau is on the lower side. Tableau has a much better visualization."
"The online community page of the product is an area of concern where improvements are required."
"The product could be improved by adding additional visualization."
"The solution lacks good visualization. They should work on the user interface to make it more slick and modern."
"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."
"There needs to be better visualization."
"I think they're still lacking on customer service. I think historically, MicroStrategy's customer service was a lot better than it is today."
"MicroStrategy should improve migration automation. Additionally, I would like there to be better partnership support."
"We have the mobile server. We have not used it. That is because the people on our team have not been trained on it yet, but that is something that we want to do."
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.