What users are saying about

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
617 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 BI

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

Add comparison

Likelihood to Recommend

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
No photo available

Microsoft BI

I found that Tableau is more efficient in providing options to calculate measures, percentages as compared to MS BI Power Pivot. Also, Tableau is more web-friendly. However, analytic capability is well suited in Microsoft BI. Microsoft BI is well suited in larger organization setup which requires various integration with external line of business applications. Sometimes, the cost impact can be bigger for smaller organizations as they look for savings while shopping for minimum viable product.
Ved Mishra profile photo

Feature Rating Comparison

BI Standard Reporting

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

Ad-hoc Reporting

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

Report Output and Scheduling

MicroStrategy Analytics
7.6
Microsoft BI
8.2
Publish to Web
MicroStrategy Analytics
7.7
Microsoft BI
8.3
Publish to PDF
MicroStrategy Analytics
8.5
Microsoft BI
8.8
Report Versioning
MicroStrategy Analytics
6.6
Microsoft BI
8.1
Report Delivery Scheduling
MicroStrategy Analytics
8.4
Microsoft BI
7.6
Delivery to Remote Servers
MicroStrategy Analytics
7.0
Microsoft BI
8.1

Data Discovery and Visualization

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

Access Control and Security

MicroStrategy Analytics
8.7
Microsoft BI
8.4
Multi-User Support (named login)
MicroStrategy Analytics
7.9
Microsoft BI
8.4
Role-Based Security Model
MicroStrategy Analytics
8.7
Microsoft BI
8.1
Multiple Access Permission Levels (Create, Read, Delete)
MicroStrategy Analytics
9.3
Microsoft BI
8.6
Single Sign-On (SSO)
MicroStrategy Analytics
9.0
Microsoft BI
8.5

Mobile Capabilities

MicroStrategy Analytics
7.7
Microsoft BI
8.2
Responsive Design for Web Access
MicroStrategy Analytics
7.6
Microsoft BI
8.2
Dedicated iOS Application
MicroStrategy Analytics
8.0
Microsoft BI
8.4
Dedicated Android Application
MicroStrategy Analytics
8.0
Microsoft BI
8.1
Dashboard / Report / Visualization Interactivity on Mobile
MicroStrategy Analytics
7.1
Microsoft BI
8.3

Application Program Interfaces (APIs) / Embedding

MicroStrategy Analytics
7.7
Microsoft BI
7.8
REST API
MicroStrategy Analytics
8.0
Microsoft BI
7.9
Javascript API
MicroStrategy Analytics
6.7
Microsoft BI
8.3
iFrames
MicroStrategy Analytics
8.0
Microsoft BI
7.7
Java API
MicroStrategy Analytics
8.0
Microsoft BI
7.5
Themeable User Interface (UI)
MicroStrategy Analytics
8.0
Microsoft BI
7.8
Customizable Platform (Open Source)
MicroStrategy Analytics
7.5
Microsoft BI
7.4

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
  • Ease of use: For end user Microsoft Power BI is incredibly easy to use. Excel is simple for most people. The presentation through SharePoint gives users with any medium the ability to instantly use the dashboards. End users are able to use mobile, local and just about anyway they would choose.
  • High Adoption Rate: We had a very high adoption rate causing many of our users to be incredibly engaged. The adoption of is due to many users already familiar with the tools they grew up on. If you grew up on Excel, then you will instantly feel at home in the tools. The new add ons are rarely a challenge even for novice users.
  • Mapping functions: The mapping functions are one of the cooler features. Power Maps automatically recognizes zip codes and other addresses much like other packages. The one item I really liked was the ability to create a movie file that would play over time showing the growth across a map through the different areas. Saved as a MP4 then blended with music made this function particularly delicious for many of our end users.
  • The Gateway: MS has provided a really cool little trick. The Gateway. I will explain this part later in my review.
Sean Warren profile photo

Cons

  • My organization is on an older version of the tool with a lot less bells and whistles
  • If an employee is familiar with SQL enough, they can avoid using microstrategy
  • No other major cons
★Alex Khamudis profile photo
  • No end user controlled reporting. An analyst with SQL coding knowledge needs to program each report.
Bryan Simmons profile photo

Likelihood to Renew

MicroStrategy Analytics9.9
Based on 27 answers
MicroStrategy is deeply engrained in the daily reporting. They are also constantly updating and making the product better. There would have to be a viable alternative that has features so beneficial it would make the investment to switch worth it.
Randy Kirschner profile photo
Microsoft BI8.0
Based on 25 answers
Microsoft BI is a great tool but may require additional, expensive staff to maintain the software and keep it running on a day to day basis from an operational perspective. Other BI products are making the jump to "Self Service" Business Intelligence, empowering the end user to create and modify their data needs. However, if a company resides on a MS SQL server structure, Microsoft's BI tool is easy to integrate and can deploy an enterprise BI solution in a relative short time. Considering the initial software costs, you get a lot for your money
Bryan Simmons profile photo

Usability

MicroStrategy Analytics7.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 profile photo
Microsoft BI7.0
Based on 5 answers
Easy to use. Good User Interface and visualizations
No photo available

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
Microsoft BI9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

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
Microsoft BI7.0
Based on 2 answers
SQL Server Reporting Services (SSRS) can drag at times. We created two report servers and placed them under an F5 load balancer. This configuration has worked well. We have seen sluggish performance at times due to the Windows Firewall.
Robert Goodman profile photo

Support

MicroStrategy Analytics10.0
Based on 3 answers
From our experience, Microstrategy is very well supported. Whenever we have issues, they are resolved quickly
★Alex Khamudis profile photo
Microsoft BI7.1
Based on 6 answers
I am basing this rating not on Microsoft's paid premium support, but rather on the resources available (both from Microsoft and 3rd parties) to BI consumers. There is such a huge community working with and building solutions with the Microsoft BI stack (SQL Server) that I have always been able to find a solution (or at least a workaround) to any problems that have come up.
Sean Brady profile photo

In-Person Training

No score
No answers yet
No answers on this topic
Microsoft BI6.9
Based on 3 answers
This training was more directed toward what the product was capable of rather than actual programming.
Stephanie Grice profile photo

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
Microsoft BI8.5
Based on 2 answers
I have used on-line training from Microsoft and from Pragmatic Works. I would recommend Pragmatic Works as the best way to get up to speed quickly, and then use the Microsoft on-line training to deep dive into specific features that you need to get depth with.
Sean Brady profile photo

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
Microsoft BI9.6
Based on 7 answers
Thorough project planning and requirements gathering ensured project's success.
Boris Skylar profile photo

Alternatives Considered

Tapan Jain profile photo
Microstrategy - I went with Microsoft BI because of features, usability, integration capabilities, performance, availability of talent, cost, and end-user (self-service) capabilities.
Sean Brady 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

  • Increased efficiency through scheduled reporting.
  • Decreased manual "massaging" of data through automated reporting.
  • Standardized metrics across business verticals.
Jonathon Frampton profile photo
  • Greatly reduced reporting project development time (and associated costs).
  • Significantly larger pool of experts to assist on large / ad-hoc projects.
  • Faster availability of critical business data to our users (due to decreased development time as well as performance of overall system - we are able to keep the data very fresh).
  • Significantly increased ETL / data integration capabilities means that more legacy and external system data is making it into the data warehouse.
Sean Brady 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 BI

General
Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No
Microsoft BI Editions & Modules
Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. per user per month
Additional Pricing Details