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 dashboards of Microsoft BI are easy to use."
"It is a good platform for data analysis, organization, and all of the other interim performances that are necessary."
"Microsoft BI's dashboards are helpful."
"The stability is good."
"It gives us, the ability to do a lot of analysis quickly, similar to ad hoc analysis."
"It is more user-friendly compared to SSRS."
"Users already using Excel can generate new reports and dashboards within minutes."
"It offers a lot of information and is very flexible and interactive."
"Tech support has been great, very responsive. We usually hear back within a day. We usually email them and that works out perfect. The right person always gets back to us."
"The implementation was fairly straightforward."
"The feature I found most valuable is the drop and drag functionality available."
"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."
"Visual Insight gives you the capability of doing self-service analytics. This has been the most powerful and valuable feature."
"MicroStrategy has powerful data security features, which are crucial these days. For example, when users view data in MicroStrategy, they're only allowed to see a portion based on the permissions. When we evaluated other solutions like Power BI or Tableau, we found the security is very poor. They can't help us secure access to the data."
"We have been using it mostly for grid reports and its exporting features."
"I really like the visualizations. I like how you can put large data sets in there, then the user can quickly go through the data and drill down at various levels to understand things."
"The handling of the workspaces can be made more granular for user access rights. It can be managed a little bit better in terms of the connection to Active Directory so that we have more granular access rights. I am not sure if this is really possible or if we can solve it differently, but we need a lot of workspaces, and we are not sure how we can deal with it from the access rights perspective."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"Sluggish performance when handling large amounts of data."
"I would prefer that the solution not be shared. I'm concerned that if we make a mistake we could reveal information to people who shouldn't see it. I would like to have my own on-prem server, to buy my own server and have my own infrastructure for Microsoft BI, with only with my data."
"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."
"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."
"Microsoft Power BI can be confusing, because it has two languages that you need to learn if you want to use it, and this makes it more difficult for nontechnical users."
"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."
"The product is designed for enterprise. A lightweight version would be easier for a smaller workgroup."
"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."
"It needs better visualizations."
"It is actually pretty complicated to use. It is complicated enough that user adaptation is sometimes difficult. We developed more experts rather than people using it."
"The analytic speed would probably be what I would look for in terms of improvement because we have super huge data, and if I do not build views on top of data, then reports render really slowly."
"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."
"The product could be improved by adding additional visualization."
"Enterprise Manager should be a little bit less quirky when you build out-of-the-box customization reports for it."
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 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.