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.
"The initial setup is straightforward."
"The reports are easy to create."
"The one feature most of our customers like is data visualization. When we were doing BI directly from SQL, most users found it challenging to create their own reports. Power BI has self-serve analytics that the end-users can do themselves. On most projects, people are primarily using data visualization and self-serve analytics."
"I like how the Query Editor lets me manipulate the data, and the available visuals are good. You can do everything using the UI."
"Our setup is very straight forward and can be done in a matter of hours."
"We are able to collaborate on things and get insightful data visualizations."
"I have found the best features to be the dashboard creation, graphs, charts, and presentation bar graphs."
"The product can go easily go and extract data and it can put it into any format."
"This solution is the most scalable BI platform in the world."
"The most valuable features are drill down, dashboards, documents, bringing everything under one roof, and visualizations."
"The solution has excellent features available on mobile."
"There's extensive logging capabilities, if something is wrong then we are able to find out why."
"The dashboard features and functionalities that come through the MicroStrategy Suite are the most valuable. It can be used by end users with minimum knowledge of the product. They can run a report or create a dashboard on their phones, which is kind of cool."
"We have ramped up user adoption."
"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 drill-down functionality is also very good."
"It has come a long way in terms of how it was working two years ago, but there are some things that you still can't do with it. For example, permission management and user access management are still a bit limited. It is basically based on the idea that everybody from the organization can see everything or limit the type of data they can see. If I want you to see only one report and the other guy to see another report, I can't do it. There should be a better way to manage permissions and users. It should also support external users much better."
"The UI is the main improvement that could be made. Specifically, there is something called DAX, in Power BI, which is complicated compared to calculated fields used in Tableau."
"The reporting could be a bit better."
"Microsoft should offer additional features for visualization and have additional features for slicing and dicing that data."
"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 is getting better but still, there are opportunity areas in some aspects, especially the Windows OS dependency."
"When there are large amounts of data being processed there are additional tools needed to handle it."
"I feel the modeling page should be simplified."
"In the developer, there are things that you able to do in a document or a report that you are not able to do in the Dossier."
"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."
"One of the things that I want to see MicroStrategy do is become more cloud native. Right now, the deployment on cloud is very easy to ruin, it is very much like spinning up separate VMs."
"There is room for improvement on the graphs."
"I would like to see a single standalone application to control everything from the administration perspective, and also to develop new applications."
"They need to improve on distribution services. There are lack of features which were there earlier with Narrowcast, but they are not there in the distribution services."
"Needs more visualizations out-of-the-box."
"We would really like to see MicroStrategy have some support teams based more in Europe, because for now it seems that there is one person for the whole CE region. That is not exactly what we would like to see. We do know that MicroStrategy supports most places, either in the US or India, but those are different time zones, people, and cultures."
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 SAS Visual Analytics, 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.