What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
642 Ratings

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
642 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
230 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 100

Likelihood to Recommend

Microsoft Power BI

Power BI is great for reporting of any type. The dashboards I create for my executive team are crisp and easy to understand. I often get complements on it, and suggestions on what other reports or data could benefit from Power BI. Power BI is still dependent on data sources, so if my data source connections break, then the report is no good. This isn't something that you can create and forget. It needs eyes on it to ensure the data is correct
Richard Crane | TrustRadius Reviewer

MicroStrategy Analytics

MSTR is great for any organization that is looking for a way to deliver complicated data in an uncomplicated way. From business teams to marketing and finance, several departments benefit from using MSTR to keep track of KPIs enabling teams to make optimizations along the way. MSTR provides great visual representations of data enabling team members to distill thousands of data points into easily digestible charts and graphs
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

Microsoft Power BI
8.4
MicroStrategy Analytics
7.9
Pixel Perfect reports
Microsoft Power BI
8.1
MicroStrategy Analytics
7.5
Customizable dashboards
Microsoft Power BI
8.6
MicroStrategy Analytics
8.6
Report Formatting Templates
Microsoft Power BI
8.4
MicroStrategy Analytics
7.5

Ad-hoc Reporting

Microsoft Power BI
8.5
MicroStrategy Analytics
7.6
Drill-down analysis
Microsoft Power BI
8.6
MicroStrategy Analytics
8.2
Formatting capabilities
Microsoft Power BI
8.4
MicroStrategy Analytics
8.0
Integration with R or other statistical packages
Microsoft Power BI
8.4
MicroStrategy Analytics
7.0
Report sharing and collaboration
Microsoft Power BI
8.7
MicroStrategy Analytics
7.3

Report Output and Scheduling

Microsoft Power BI
8.5
MicroStrategy Analytics
7.3
Publish to Web
Microsoft Power BI
9.0
MicroStrategy Analytics
7.7
Publish to PDF
Microsoft Power BI
8.5
MicroStrategy Analytics
8.8
Report Versioning
Microsoft Power BI
8.5
MicroStrategy Analytics
7.3
Report Delivery Scheduling
Microsoft Power BI
8.6
MicroStrategy Analytics
7.7
Delivery to Remote Servers
Microsoft Power BI
8.2
MicroStrategy Analytics
5.0

Data Discovery and Visualization

Microsoft Power BI
8.4
MicroStrategy Analytics
8.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft Power BI
8.6
MicroStrategy Analytics
7.7
Location Analytics / Geographic Visualization
Microsoft Power BI
8.5
MicroStrategy Analytics
9.0
Predictive Analytics
Microsoft Power BI
8.0
MicroStrategy Analytics
7.5

Access Control and Security

Microsoft Power BI
8.6
MicroStrategy Analytics
8.4
Multi-User Support (named login)
Microsoft Power BI
8.6
MicroStrategy Analytics
8.2
Role-Based Security Model
Microsoft Power BI
8.4
MicroStrategy Analytics
8.6
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft Power BI
8.6
MicroStrategy Analytics
8.2
Single Sign-On (SSO)
Microsoft Power BI
8.9
MicroStrategy Analytics
8.4

Mobile Capabilities

Microsoft Power BI
8.3
MicroStrategy Analytics
7.9
Responsive Design for Web Access
Microsoft Power BI
8.4
MicroStrategy Analytics
7.3
Dedicated iOS Application
Microsoft Power BI
8.2
MicroStrategy Analytics
9.0
Dedicated Android Application
Microsoft Power BI
8.3
MicroStrategy Analytics
8.5
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft Power BI
8.3
MicroStrategy Analytics
6.7

Application Program Interfaces (APIs) / Embedding

Microsoft Power BI
8.2
MicroStrategy Analytics
8.5
REST API
Microsoft Power BI
8.3
MicroStrategy Analytics
9.0
Javascript API
Microsoft Power BI
8.4
MicroStrategy Analytics
8.3
iFrames
Microsoft Power BI
8.1
MicroStrategy Analytics
8.5
Java API
Microsoft Power BI
7.9
MicroStrategy Analytics
9.0
Themeable User Interface (UI)
Microsoft Power BI
8.4
MicroStrategy Analytics
7.7
Customizable Platform (Open Source)
Microsoft Power BI
8.3
MicroStrategy Analytics
8.5

Pros

Microsoft Power BI

  • Engaging dashboard displays with drag and drop modules to convey data in a meaningful ways.
  • Familiar Microsoft "Ribbon" type interface that creates an integral feel with the rest of the Microsoft suite of products.
  • Built-in mobile optimization window and associated Mobile applications that allow viewing from any location connected to the server.
Rick Botha | TrustRadius Reviewer

MicroStrategy Analytics

  • I think the dashboards are quite helpful to visualize on the spot data.
  • Creation of facts and attributes is simple - I have no programming experience and was still able to create and modify these items.
  • Scheduling reports to be run on a daily, weekly, or hourly basis is simple. It provides updated data on a timed basis with no need to go back into the program.
Anonymous | TrustRadius Reviewer

Cons

Microsoft Power BI

  • It is such a powerful system that it can come across as intimidating for some without some Excel knowledge
  • I'm not a database analyst or administrator, so calling the data in can be difficult (not necessary the fault of the software, but something that could be difficult for teams without someone with database knowledge)
  • It can come across as confusing, when there is both a local Power BI and online Power BI components. They don't necessarily do the same functions. You'll definitely want to know how to use the online version as this is how you'll publish and share the results of your findings, but the local one has a lot of capabilities that don't appear to be directly available in the online version (and if so, it's not immediately apparent).
Steffany Winkelmann | TrustRadius Reviewer

MicroStrategy Analytics

  • Visual Insight have multiple limitations. Few of them are listed here - i)Cannot change default graph colors ii) text/graph formatting are very very limited iii)Add metric to Color by / Thresholds is not possible iv)one of the worst limitation of the VI in older versions is that it is not possible to create filters that apply only to a specific visualization. For example if there are 4 graphs in one dashboard & if you have filters then those filters would be applicable for all of them
  • Some formatting options are not there either on Web or Developer especially while dealing with a document. We have to use both Web & Developer to solve issues.
  • While connecting with MDX cube reporting loses a lot of features.
Abanish Mishra | TrustRadius Reviewer

Likelihood to Renew

Microsoft Power BI

Microsoft Power BI 10.0
Based on 1 answer
I find it helpful and easy to use
jim paroly | TrustRadius Reviewer

MicroStrategy Analytics

MicroStrategy Analytics 9.9
Based on 27 answers
I would always choose to renew MicroStrategy as long as they lead the market in features, functionality and price. The support of MicroStrategy is timely and professional, I frequently get answers to my questions within 24 hours and normally have solutions within 48 hours. Training available for MicroStrategy completely covers everything required to be able to expertly use MicroStrategy and understand data warehousing.
Paul Campbell | TrustRadius Reviewer

Usability

Microsoft Power BI

Microsoft Power BI 9.0
Based on 3 answers
PBI is very easy to use because of its similarity with power pivot and excel. DAX is the basic foundation language to be mastered to quickly build reports. Custom measures have been introduce to write instant DAX functions (But doesnt work all the time and need a understanding of DAX to debug). Easy to chart multiple charts and also third party charts
Rohit Acharya | TrustRadius Reviewer

MicroStrategy Analytics

MicroStrategy Analytics 7.0
Based on 3 answers
The standard grid reporting could look more like the styling and object used for the Import and Visual Insight products. In addition, object properties almost seem to be hidden when first using the product. It's as if they are asking the engineers to only use the presets we make available...and, these presets are 10+ years old. On the positive side, Microstrategy seems to be the only product, not named Cognos, which can scale to Big Data. The product is "hackable" via the SDK or tricking the Intelligence Server to do uncommon things. The Microstrategy development team also seems to be very involved with their OEM partners; especially when it comes to features and enhancements. A large majority of the improvements we suggested have made it into the product or on the roadmap for future enhancements. Only suckas fall for the shiny objects from most other vendors; Microstrategy is really the only choice for Enterprise BI.
Wm. Dexter Jones | TrustRadius Reviewer

Reliability and Availability

Microsoft Power BI

No score
No answers yet
No answers on this topic

MicroStrategy Analytics

MicroStrategy Analytics 10.0
Based on 1 answer
I've never had an issue with MicroStrategy not being available due to MicroStrategy application malfunction. It is very robust and only failures I've seen were due to user error or the platform the machine running the service failed some how.
Paul Campbell | TrustRadius Reviewer

Performance

Microsoft Power BI

No score
No answers yet
No answers on this topic

MicroStrategy Analytics

MicroStrategy Analytics 10.0
Based on 1 answer
Being able to customize the performance based on the business need is extremely powerful. Proper configuration and understanding of the usage pattern is key, if the technical ability of the architect is not at top level, then the product will not be configured correctly which will lead to poor performance.
Paul Campbell | TrustRadius Reviewer

Support Rating

Microsoft Power BI

No score
No answers yet
No answers on this topic

MicroStrategy Analytics

MicroStrategy Analytics 10.0
Based on 3 answers
If the staff does not know they answer they either find it out at some point, or put in a feature request. I have never been left hanging or been given an answer that is unsatisfactory to the solution. Even if there was no current solution, I was still told the logical reason and why.
Paul Campbell | TrustRadius Reviewer

Online Training

Microsoft Power BI

No score
No answers yet
No answers on this topic

MicroStrategy Analytics

MicroStrategy Analytics 7.8
Based on 4 answers
I have attended many trainings offered by MicroStrategy; both distance and in-person training. I earned my CRD (Certified Report Developer) certification via the online training. I found the training to be well organized and concise. Overall I will definitely continue to increase my knowledge with MicroStrategy via the online training offering.
Shawn Stephens | TrustRadius Reviewer

Implementation Rating

Microsoft Power BI

No score
No answers yet
No answers on this topic

MicroStrategy Analytics

MicroStrategy Analytics 8.0
Based on 3 answers
Implementation is not easy, but also not difficult. With enough training on how to create a schema, and with the proper data warehouse schema the implementation can be very quick. If there are a lot of unknowns in the beginning phase of modeling, that can greatly extend the overall time taken for a fully implemented project.
Paul Campbell | TrustRadius Reviewer

Alternatives Considered

Microsoft Power BI

Microsoft Power BI as I said earlier is unfortunate in relation to the panels but compared to Tableau.Although Microsoft Power BI has a general interface easier to understand in my company because we already have a signature with the package Office 365 that the integration of the same is excellent.
Gabriel Oliveira | TrustRadius Reviewer

MicroStrategy Analytics

Tableau is probably MicroStrategy Analytic's biggest competitor I've noticed over time, and I'm not sure why. Tableau only covers visualizations independently for each business user, which then creates the issues of every employee creating their own version of the data, and then you have 20 versions of the truth. A enterprise data warehouse and MicroStrategy's Visual Insight is a better method.
Anonymous | TrustRadius Reviewer

Scalability

Microsoft Power BI

No score
No answers yet
No answers on this topic

MicroStrategy Analytics

MicroStrategy Analytics 10.0
Based on 1 answer
This software is extremely scaleable, one can add more core servers which performs as a load balancing. The configurations available to manage usage patterns and daily activity are as high a caliber as any other enterprise level software. This product can be installed on both a windows and unix platform allow for integration on a budget.
Paul Campbell | TrustRadius Reviewer

Return on Investment

Microsoft Power BI

  • I'm using the free version, so the only investment was the time spent to learn how to use the product (which as an Excel user, was very short).
  • I use Excel to store every single bit of information about all the projects I do, and being able to see them visualized helped me see some redundant steps I was taking.
  • No negative impact at all for me.
jim paroly | TrustRadius Reviewer

MicroStrategy Analytics

  • MicroStrategy was helpful for reducing the amount of time we needed to spend number crunching large data sets, and in doing so, allowed me as the primary users to spend more time gleaning insights from the data that in turn informed our leadership team to make strategic decisions.
  • By creating numerous canned reports available to all members of the team through email distribution or basic access to the platform, we were able to reduce the time I spent showing people how to pull the data in Microsoft Excel by nearly 40% .
  • We ended up needing to make many changes to the way our DMP was feeding data into MicroStrategy due to incorrect reporting that caused complications in accounting and finance.
Toreyan Clarke | TrustRadius Reviewer

Pricing Details

Microsoft Power BI

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Microsoft Power BI Editions & Modules

Additional Pricing Details

MicroStrategy Analytics

General

Free Trial
Yes
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

MicroStrategy Analytics Editions & Modules

On-premise Edition
Desktop$6001
  1. per named user
SaaS Edition
Web$6001
Web$300,0002
Mobile$6003
Mobile$300,0004
  1. per named user
  2. per CPU core
  3. per named user
  4. per CPU core
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Microsoft Power BI
8.6
MicroStrategy Analytics
8.4

Likelihood to Renew

Microsoft Power BI
10.0
MicroStrategy Analytics
9.9

Usability

Microsoft Power BI
9.0
MicroStrategy Analytics
7.0

Reliability and Availability

Microsoft Power BI
MicroStrategy Analytics
10.0

Performance

Microsoft Power BI
MicroStrategy Analytics
10.0

Support Rating

Microsoft Power BI
MicroStrategy Analytics
10.0

Online Training

Microsoft Power BI
MicroStrategy Analytics
7.8

Implementation Rating

Microsoft Power BI
MicroStrategy Analytics
8.0

Scalability

Microsoft Power BI
MicroStrategy Analytics
10.0

Add comparison