What users are saying about

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
352 Ratings
210 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.6 out of 101

Microsoft Power BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
352 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

Add comparison

Likelihood to Recommend

MicroStrategy Analytics

It is appropriate when wishing to show big data to a group that needs to make informed decisions quickly, and that does not have a technical background and cannot get bogged down in percentages and technicalities. For those that want it, however, Microstrategy provides gridded reports that make detailed examination of data easy. Both are simple to create
No photo available

Microsoft Power BI

Power BI is great for power Excel users and what I call “data archeologists” or people who dig up old data and clean it up for modern usage. It strings many files together and lets you customize the connections and format of the data. It does not work well with large data set or pull data from large databases, you will find it timing out unless you limit the data set first with a SQL View or Tabular Model before going after it. Also, large data sets take forever to refresh and update, so if you have a lot if iterations, you will spend a lot of time going out for coffee while the data reloads. Other BI tools allow you to localize the data with the first load (Qlik QVD’s) so you can refresh quicker. Comparatively, a refresh of SQL data on Power BI took 45 minutes, the exact same data set would refresh in 30 seconds using Qlik Sense.
No photo available

Feature Rating Comparison

BI Standard Reporting

MicroStrategy Analytics
6.7
Microsoft Power BI
8.0
Pixel Perfect reports
MicroStrategy Analytics
5.9
Microsoft Power BI
7.7
Customizable dashboards
MicroStrategy Analytics
7.6
Microsoft Power BI
8.4
Report Formatting Templates
MicroStrategy Analytics
6.5
Microsoft Power BI
7.9

Ad-hoc Reporting

MicroStrategy Analytics
7.6
Microsoft Power BI
8.2
Drill-down analysis
MicroStrategy Analytics
8.9
Microsoft Power BI
8.5
Formatting capabilities
MicroStrategy Analytics
8.2
Microsoft Power BI
8.1
Integration with R or other statistical packages
MicroStrategy Analytics
5.6
Microsoft Power BI
8.0
Report sharing and collaboration
MicroStrategy Analytics
7.5
Microsoft Power BI
8.1

Report Output and Scheduling

MicroStrategy Analytics
7.6
Microsoft Power BI
7.9
Publish to Web
MicroStrategy Analytics
7.7
Microsoft Power BI
8.8
Publish to PDF
MicroStrategy Analytics
8.5
Microsoft Power BI
7.9
Report Versioning
MicroStrategy Analytics
6.6
Microsoft Power BI
7.7
Report Delivery Scheduling
MicroStrategy Analytics
8.4
Microsoft Power BI
7.7
Delivery to Remote Servers
MicroStrategy Analytics
7.0
Microsoft Power BI
7.3

Data Discovery and Visualization

MicroStrategy Analytics
7.6
Microsoft Power BI
8.1
Pre-built visualization formats (heatmaps, scatter plots etc.)
MicroStrategy Analytics
8.4
Microsoft Power BI
8.4
Location Analytics / Geographic Visualization
MicroStrategy Analytics
7.1
Microsoft Power BI
8.5
Predictive Analytics
MicroStrategy Analytics
7.3
Microsoft Power BI
7.5

Access Control and Security

MicroStrategy Analytics
8.7
Microsoft Power BI
7.9
Multi-User Support (named login)
MicroStrategy Analytics
7.9
Microsoft Power BI
8.2
Role-Based Security Model
MicroStrategy Analytics
8.7
Microsoft Power BI
7.3
Multiple Access Permission Levels (Create, Read, Delete)
MicroStrategy Analytics
9.3
Microsoft Power BI
7.8
Single Sign-On (SSO)
MicroStrategy Analytics
9.0
Microsoft Power BI
8.3

Mobile Capabilities

MicroStrategy Analytics
7.7
Microsoft Power BI
7.8
Responsive Design for Web Access
MicroStrategy Analytics
7.6
Microsoft Power BI
7.9
Dedicated iOS Application
MicroStrategy Analytics
8.0
Microsoft Power BI
7.8
Dedicated Android Application
MicroStrategy Analytics
8.0
Microsoft Power BI
7.8
Dashboard / Report / Visualization Interactivity on Mobile
MicroStrategy Analytics
7.1
Microsoft Power BI
7.8

Application Program Interfaces (APIs) / Embedding

MicroStrategy Analytics
7.7
Microsoft Power BI
7.1
REST API
MicroStrategy Analytics
8.0
Microsoft Power BI
7.6
Javascript API
MicroStrategy Analytics
6.7
Microsoft Power BI
7.4
iFrames
MicroStrategy Analytics
8.0
Microsoft Power BI
7.0
Java API
MicroStrategy Analytics
8.0
Microsoft Power BI
6.4
Themeable User Interface (UI)
MicroStrategy Analytics
8.0
Microsoft Power BI
7.4
Customizable Platform (Open Source)
MicroStrategy Analytics
7.5
Microsoft Power BI
6.9

Pros

  • MicroStrategy was a helpful tool for providing daily, monthly, and quarterly reporting due to the ability to build automated reports that can be sent to large groups of people using distribution lists.
  • I found MicroStrategy very helpful when putting together monthly performance reviews using the visual reporting tools. The ease with which I was able to switch from data tables to charts as a better way to tell stories about complicated data sets was particularly useful.
  • When we needed to pull user information for targeted marketing campaigns, MicroStrategy dramatically reduced the amount of time we spent tying User IDs to user activity within our DMP. In turn, we were able to leverage the data to create user segments which helped us focus our marketing spend more effectively for marketing campaigns.
Toreyan Clarke profile photo
  • Microsoft Power BI has excellent visualizations, patterns, spot charts.
  • It has a great length of connectivity with databases and other software. This includes: MS Access, PL/SQL, JSON, SAP HANA, MySQL, etc.
  • It's very cheap and helps focus on the right areas during presentations/meeting discussions.
Purav Vaidya profile photo

Cons

  • Perhaps it was the nature of the size of the company I previously worked for, but the amount of time it took for changes and upgrades to be implemented was a bit frustrating at times.
  • It would be incredibly helpful if users had the ability to make changes to metrics and attributes without having to rely to heavily on MicroStrategy developers, it would make the product a great deal more useful.
  • Being able to distribute rich MicroStrategy reports without sending enormous emails was problematic at times. If there was a way to let data rich reports being distributed via email live in a web environment would be a big plus for the platform.
  • Being unable to view reports on smartphones was a bit of a pain at times as well, particularly when you need to send reports to colleagues working off-site without a laptop or desktop computer available.
Toreyan Clarke profile photo
  • Microsoft Power BI could become a little more user friendly and added videos for training. This is one place where Tableau does a little better.
  • Power BI also needs to become available in the cloud for better usage.
  • Power BI deployment flexibility needs to be improved. This is better in other software.
Purav Vaidya profile photo

Likelihood to Renew

MicroStrategy Analytics9.9
Based on 27 answers
There are other BI tools out there that definitely overcome some of the shortcomings of MSTR and we have been testing them to see how they meet our needs
No photo available
Microsoft Power BI10.0
Based on 1 answer
I find it helpful and easy to use
jim paroly profile photo

Usability

MicroStrategy Analytics7.0
Based on 3 answers
It is difficult to learn, but once you figure it out through training, it becomes simpler and the reasons for it's complexity becomes apparent.
Paul Campbell profile photo
Microsoft Power BI8.8
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 profile photo

Reliability and Availability

MicroStrategy Analytics10.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 profile photo
No score
No answers yet
No answers on this topic

Performance

MicroStrategy Analytics10.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 profile photo
No score
No answers yet
No answers on this topic

Support

MicroStrategy Analytics10.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 profile photo
No score
No answers yet
No answers on this topic

Online Training

MicroStrategy Analytics7.8
Based on 4 answers
The MicroStrategy training is incredible, they have great online teachers. I was fortunate to be learning MicroStrategy while also implementing a project from scratch. This helped to solidify a lot of the concepts and be able to ask questions about real world problems in addition to class room exercises.
Paul Campbell profile photo
No score
No answers yet
No answers on this topic

Implementation

MicroStrategy Analytics8.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 profile photo
No score
No answers yet
No answers on this topic

Alternatives Considered

Tapan Jain profile photo
Power BI takes it to another level with the report and dashboard designing for a wide variety of purposes, and always gives you the option to be collaborative within their native sync features, that is also an advantage to set things up, for example, to promote reports into intranets or weekly reports.
Litzi Saraí Gordils Ortuño profile photo

Scalability

MicroStrategy Analytics10.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 profile photo
No score
No answers yet
No answers on this topic

Return on Investment

  • Greatly enhances our ability to help customers understand their data -- we import client data into Microstategy to provide a variety of services to them.
  • Provides one version of the truth as all reports/dashboards access the exact same data, formulas, metrics, etc.
  • Gained tremendous flexibility for all sorts of reporting and analysis needs. Beyond anything we could build ourselves in-house.
Sid Haas profile photo
  • It's a good start for setting up customized dashboards.
  • Available for all users based on Office 365 platform we have in place.
  • Doesn't really allow depth of report - specifically customization of visual displays.
Mark Metz profile photo

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
MicroStrategy Analytics
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

Microsoft Power BI

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft Power BI Editions & Modules
Microsoft Power BI
Additional Pricing Details