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.
"In the early stage of an implementation, it not only helps decision making, but it allows people to have insight into problems with data so that they can go and get it corrected."
"It provides easy integration with Office tools."
"ou can pull reports, visualize them in real-time, and connect them to a variety of other data sources."
"The most valuable feature of this solution is real-time report tracking."
"It has greatly improved our reporting capabilities."
"Good reporting and data analysis tool that's user-friendly, easy to deploy, stable, and scalable."
"Technical support has been great."
"I like data modeling. You can connect with your database, which is quite useful for me. It is a good tool if you have a large amount of data and you want to gather different data and interconnect it. The Power Query functionality is quite an interesting feature. If you have a query in Excel, you can also copy your query and run it in Power BI. Its dashboard is also very nice and not complicated. You don't need to be a developer to be able to use it. I am not an IT guy, and it is quite easy to use for somebody who is not an IT person."
"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."
"There's extensive logging capabilities, if something is wrong then we are able to find out why."
"I have had a lot of projects where we had a lot of users, like thousands of users, and the data was in one report which could bring in six million records. MicroStrategy is doing a good job on scalability."
"We've made a few enhancements to our Enterprise Manager system to allow self-reporting to grow. We see that as a very useful system. It's been incredibly beneficial in diagnosing production performance issues, diagnosing what reports are running slowly, where the SQL could be optimized, opportunities or metrics where we see long-time running performance. Enterprise Manager has been absolutely vital in giving us some of the insights about our system."
"The subscription model is excellent. About half of our reporting comes out of the subscription, and from there, the ease of use in dragging and dropping reporting objects."
"Stability is great, especially with package deployments. It is very consistent and stable."
"Speed for high level aggregation by using Intelligent Cubes."
"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."
"I think that the product would benefit by increasing the range of visuals and graphics readily available, as opposed to using a third party included as part of the product."
"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."
"One area for improvement in Microsoft Power BI is serviceability. Compared to one of its competitors: Tableau, there are a lot of things which you cannot do in this tool, that can be done in Tableau."
"The on-premises version lacks some technical features that are available with the Cloud version."
"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."
"Microsoft BI’s integration and visualization could be improved."
"Microsoft has made a lot of progress with Power BI in the past couple of years, but there is still some room for improvement. For example, Integration is one area they could work on. They are adding more integration with other Microsoft tools, but I would like it if they sped up the process."
"The solution's licensing could be improved because its cost is heavy on the pockets."
"The solution has a very non-logical user usage part. It has a library mode where users can access all the data, reports, and dashboards, but they also can be accessed from a platform. They have to log into the platform. The user experience is confusing for the users. MicroStrategy needs to define which one they will use. Some functionality isn’t available in library mode but is available in the portal. There should be Office integration. For example, if I do a presentation, then I should be able to add a chart to my presentation."
"Needs more visual essence and connectors for the ecosystems, which would be easy to use."
"It needs row-level security, column-level security, on attributes. I want to be able to handle full-scale security model from the semantic layer, flat out."
"Getting our data to work with the tool is where we are having issues."
"MicroStrategy should improve migration automation. Additionally, I would like there to be better partnership support."
"The In-Memory Capability (cubes) needs a lot of improvement."
"I would like to see more Writeback capabilities that would allow our IT department not to be worried about the wild, Wild West of Writeback."
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, 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.