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 good part of it is that you can do whatever you want with it when it comes to building BI. In terms of languages, it supports Python, and it also natively supports R."
"We encourage end users to use Power BI because it's quite easy for them to interact with the menus and the navigation bar. Even for ordinary users, they can create their own dashboard using Power BI."
"There is also a chart store where we can download charts, which is extremely useful."
"It is very good, and it supports the Microsoft ecosystem, including Excel, etc."
"ou can pull reports, visualize them in real-time, and connect them to a variety of other data sources."
"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."
"You don't need much support with Microsoft Power BI because it has such a large base of users who can answer your questions on their forums. There are also many video tutorials and webinars available online that offer solutions to whatever problems you may have."
"Many of my customers already use Microsoft products like Office 365, so I often propose Microsoft Power BI because it integrates well with all the standard Microsoft business tools. And it's the quickest tool to implement and start using daily."
"It's a stand-alone mobile development app that you don't even have to do business intelligence on. You can just use it to build apps."
"It is always nice to have one solution in a single platform. You can do pretty much everything, instead of having to get a little bit here or a little bit there."
"Semi-automatic support of implementing date dimensions, including delta to prior year implementation."
"It is a great tool and has the best offerings for doing data analysis."
"It plays a vital role in establishing a connection with predictive continuous improvement."
"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."
"The implementation was fairly straightforward."
"It offers us a lot of out-of-the-box tools, which give us the ability to automate a lot of our administrative tasks. Some things become menial: user creation, restarting a server at 10 o'clock on a Friday - simple things that they really give you the tools to be able to do. That's one thing I really like about the MicroStrategy platform from an administrative perspective."
"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."
"Our expectation is putting BI to work in real-time data collection systems in the maritime environment."
"The solution could improve the extraction and transformation of data. For example, you transform the data and then send it to Microsoft BI without having to use your own API. We are only providing the API to Power BI, and then Power BI is doing the job."
"We haven't used it that long and I haven't come across anything that's stood out as needing to be fixed."
"I would like for there to be some type of user manual that shows steps on how to navigate the solution."
"It is kept very current, and there is an update literally every month. However, the interface changes quite randomly with no documentation, which is difficult at the domain and architectural level where you're planning things and engaging the business. Things change frequently, and you wonder where has the button for the new report gone. They should provide better documentation on interface changes. It should be better optimized. It is supposed to be a data integration tool, but it is doing relatively simple queries. It has its limitations. For example, you can only pull a number of columns. So, there is room for optimization on its ability to integrate multiple data sources. The desktop tool is very memory-intensive, and again, this is not documented clearly. It requires a heavy CPU and memory use, and it causes your operating systems to become unstable. I would like to see the ability to create datasets within Power BI. Microsoft is promoting Azure as a cloud solution, but it is dependent upon a desktop component, which seems a little bit deceptive. Data set is the basic element that you report from, but it has to be created on the desktop and then published to the cloud. So, you're in the cloud, and you create a data structure or the data flow, but you can't report from that. You have to leave the cloud, go to your desktop, create the data set on your desktop, and publish it to the cloud. You go back to the cloud and create your report by using that published data set, which is very non-intuitive. If you go to the Microsoft Power BI community, this is a common complaint across the entire community."
"A lot of people work on Excel, so being able to export an Excel file as part of a subscription would be an improvement."
"People without private emails cannot publish and, frankly, this doesn't allow for easy training."
"There are some challenges in our organization on how we store the data."
"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."
"Scalability is something which will need to be improved when it goes to a bigger audience."
"Enterprise Manager should be a little bit less quirky when you build out-of-the-box customization reports for it."
"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."
"Consolidate the functional offering to be more concise in the front-end for web reports, dashboards, and self-service."
"The web developer tool for documents creation does not have all the features of the client version"
"We're starting to open it up to more and more people to give them the ability and start looking at these things themselves, but it's not the most intuitive system, Enterprise Manager that is, so it's tough. We're trying to bridge the gap between usability and who we let in the system, because you're not going to come in and just pick it up."
Microsoft Power BI is ranked 1st in BI (Business Intelligence) Tools with 293 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.