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>
727 Ratings

Microsoft BI

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
727 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101
225 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 101

Likelihood to Recommend

Microsoft BI

If the client you are dealing with already has existing Microsoft licensing agreements, selecting the Microsoft Stack may be a no-brainer. However, truly understanding the client's needs is the most important place to start versus selecting the technology stack. B2C clients that need a visualization tool may need to look elsewhere if you are looking for a data visualization tool, as costs for licensing are high at the time of writing.
No photo available

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

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
7.8
MicroStrategy Analytics
8.6
Pixel Perfect reports
Microsoft BI
7.5
MicroStrategy Analytics
8.2
Customizable dashboards
Microsoft BI
7.8
MicroStrategy Analytics
9.4
Report Formatting Templates
Microsoft BI
8.0
MicroStrategy Analytics
8.1

Ad-hoc Reporting

Microsoft BI
8.2
MicroStrategy Analytics
8.3
Drill-down analysis
Microsoft BI
8.0
MicroStrategy Analytics
8.8
Formatting capabilities
Microsoft BI
8.2
MicroStrategy Analytics
8.5
Integration with R or other statistical packages
Microsoft BI
7.9
MicroStrategy Analytics
8.4
Report sharing and collaboration
Microsoft BI
8.6
MicroStrategy Analytics
7.5

Report Output and Scheduling

Microsoft BI
7.8
MicroStrategy Analytics
8.3
Publish to Web
Microsoft BI
8.1
MicroStrategy Analytics
8.7
Publish to PDF
Microsoft BI
8.4
MicroStrategy Analytics
8.8
Report Versioning
Microsoft BI
7.7
MicroStrategy Analytics
7.9
Report Delivery Scheduling
Microsoft BI
7.1
MicroStrategy Analytics
9.2
Delivery to Remote Servers
Microsoft BI
7.8
MicroStrategy Analytics
7.0

Data Discovery and Visualization

Microsoft BI
7.7
MicroStrategy Analytics
9.0
Pre-built visualization formats (heatmaps, scatter plots etc.)
Microsoft BI
8.0
MicroStrategy Analytics
9.7
Location Analytics / Geographic Visualization
Microsoft BI
7.5
MicroStrategy Analytics
9.3
Predictive Analytics
Microsoft BI
7.5
MicroStrategy Analytics
7.9

Access Control and Security

Microsoft BI
8.1
MicroStrategy Analytics
8.8
Multi-User Support (named login)
Microsoft BI
8.1
MicroStrategy Analytics
8.3
Role-Based Security Model
Microsoft BI
7.7
MicroStrategy Analytics
9.1
Multiple Access Permission Levels (Create, Read, Delete)
Microsoft BI
8.3
MicroStrategy Analytics
8.9
Single Sign-On (SSO)
Microsoft BI
8.3
MicroStrategy Analytics
8.9

Mobile Capabilities

Microsoft BI
8.0
MicroStrategy Analytics
8.4
Responsive Design for Web Access
Microsoft BI
7.9
MicroStrategy Analytics
7.9
Dedicated iOS Application
Microsoft BI
8.1
MicroStrategy Analytics
8.8
Dedicated Android Application
Microsoft BI
7.8
MicroStrategy Analytics
8.8
Dashboard / Report / Visualization Interactivity on Mobile
Microsoft BI
8.0
MicroStrategy Analytics
7.8

Application Program Interfaces (APIs) / Embedding

Microsoft BI
7.6
MicroStrategy Analytics
8.7
REST API
Microsoft BI
7.5
MicroStrategy Analytics
8.8
Javascript API
Microsoft BI
8.1
MicroStrategy Analytics
8.3
iFrames
Microsoft BI
7.4
MicroStrategy Analytics
8.8
Java API
Microsoft BI
7.9
MicroStrategy Analytics
8.8
Themeable User Interface (UI)
Microsoft BI
7.5
MicroStrategy Analytics
8.8
Customizable Platform (Open Source)
Microsoft BI
7.4
MicroStrategy Analytics
8.7

Pros

Microsoft BI

  • The layout of Power BI is very intuitive. Someone that is familiar with Excel and working with Charts and Graphs in that environment will find the learning curve a rather short one to start using Power BI.
  • I like the way Power BI fits an assortment of users and how the functionality that you engage is replicated in Excel, that being Power Query and Power Pivot. So what you learn in one tool can be readily applied towards the other which allows you to more effectively apply your training.
  • I appreciate how Microsoft is working to develop tools that go a long ways to empowering the end user. Prior to Power BI I would have had to consult with a "BI" professional to develop a dashboard. With Power BI I don't have to consult with anyone, I can work to put together the dash board I want and using a tool set that is really robust and allows me to engage an enormous amount of data. It's provides a great deal of flexibility and the types of data I can connect to.
  • Updates...Microsoft is working diligently to keep Power BI current with monthly updates. They do a really good job of listening to the end user, if there is functionality not currently present just give them a month or so.
  • Just to be clear, even though it's easy to get going right out of the gate with Power BI it provides plenty of opportunities to create some really sophisticated reporting solutions. With DAX in Power Pivot and M language in Power Query, you are provided with plenty of head room to do some really amazing things in Power BI.
  • Training...there are resources across the web for learning and growing your skills and Power BI. And what's even better is the majority of those resources are free.
  • Data engagement, when presenting the data to the end user Power BI goes a long way to allowing that end user to engage the data and begin to identify root cause by simply interacting with the graph/chart/data set. It allows for really fluid engagement. Prior to Power BI so many times during the presentation of data we often times ended the engagement with that data with more questions than what were answered. With Power BI, more often than not, the end user is able to get answers to the questions by simply clicking on the data in the graph/chart/dataset to see the details. This tool really does have the capacity to make you look like a rock star.
Jason Leidig profile photo

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

Cons

Microsoft BI

  • Report Builder 3.0 shipped with MSSQL 2012 is a nice free tool but our client users sometimes encounter problems such as the tool automatically shut down without saving the changes being made. We haven't implemented the new RB with MSSQL 2016 yet thus cannot comment on the latest version.
Haibo Yang profile photo

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 profile photo

Likelihood to Renew

Microsoft BI

Microsoft BI 8.0
Based on 25 answers
Microsoft BI is fundamental to our suite of BI applications. That being said, Northcraft Analytics is focused on delighting our customers, so if the underlying factors of our decision change, we would choose to re-write our BI applications on a different stack. Luckily, mathematics are the fundamental IP of our technology... and is portable across all BI platforms for the foreseeable future.
Lee Cullom profile photo

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 profile photo

Usability

Microsoft BI

Microsoft BI 7.0
Based on 5 answers
Usability is great. This product will make most feel right at home. I feel like this question should be asked from two points of view:1. Creator of reports, Data Models, Views etc: Most Advanced users will still rate the usability as very high. Its capabilities are still robust. However when compared to other Enterprise Class products it will not do many of the advanced application queries. 2. End user, Consumer: All end users will feel right at home. Many will be able to create connections to already created data models and other external publicly available sources like twitter, Facebook, World Health order etc... These connections are then in turn very very easily available to publish to SharePoint and Power BI. It took me a while to understand what I think is Microsoft's strategy. This will handle all but the most of robust needs. Much like many American made cars and my favorite Corvette, Microsoft is fast, has it own break downs from time to time but all of these are really to tolerate when the price is considered and the next one up that can out perform it is three to four times as much money makes this an easy one to still recommend
Sean Warren profile photo

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 profile photo

Reliability and Availability

Microsoft BI

Microsoft BI 9.5
Based on 2 answers
The product has been reliable.
Robert Goodman profile photo

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 profile photo

Performance

Microsoft BI

Microsoft BI 7.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

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 profile photo

Support

Microsoft BI

Microsoft BI 7.1
Based on 6 answers
While support from Microsoft isn't necessarily always best of breed, you're also not paying the price for premium support that you would on other platforms. The strength of the stack is in the ecosystem that surrounds it. In contrast to other products, there are hundreds, even thousands of bloggers that post daily as well as vibrant user communities that surround the tool. I've had much better luck finding help with SQL Server related issues than I have with any other product, but that help doesn't always come directly from Microsoft.
Jacob Saunders profile photo

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 profile photo

In-Person Training

Microsoft BI

Microsoft BI 6.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

MicroStrategy Analytics

No score
No answers yet
No answers on this topic

Online Training

Microsoft BI

Microsoft BI 8.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

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 profile photo

Implementation

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
We are a consulting firm and as such our best resources are always billing on client projects. Our internal implementation has weaknesses, but that's true for any company like ours. My rating is based on the product's ease of implementation.
Jacob Saunders profile photo

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 profile photo

Alternatives Considered

Microsoft BI

Looking at the visualization portion of BI, there are three types of tools.
  1. Programming packages. Free and powerful, they let you make any diagram, at the cost of difficulty of use.
  2. Specialist software like Tableau and Microsoft BI. This is the best choice in most cases due to ease of use and quality of output.
  3. More generic software offered by the big IT companies, often part of a BI suite. There's really a lot of variety here. Use this when it fits the workflow and you are already using the relevant software. But, personally, I'd still use the specialist software.
Alexander Lubyansky profile photo

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

Scalability

Microsoft 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 profile photo

Return on Investment

Microsoft BI

  • Business users easily learned self service BI with training and what to do and what not to do with self service BI
  • Learning curve for Powerpivot and other office 365 tools for IT team who already knew about data warehousing concepts is steep
No photo available

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 profile photo

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

Edition
Power BI$0
Power BI Pro$102
  1. per user per month
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 BI
8.3
MicroStrategy Analytics
8.9

Likelihood to Renew

Microsoft BI
8.0
MicroStrategy Analytics
9.9

Usability

Microsoft BI
7.0
MicroStrategy Analytics
7.0

Reliability and Availability

Microsoft BI
9.5
MicroStrategy Analytics
10.0

Performance

Microsoft BI
7.0
MicroStrategy Analytics
10.0

Support

Microsoft BI
7.1
MicroStrategy Analytics
10.0

In-Person Training

Microsoft BI
6.9
MicroStrategy Analytics

Online Training

Microsoft BI
8.5
MicroStrategy Analytics
7.8

Implementation

Microsoft BI
9.6
MicroStrategy Analytics
8.0

Scalability

Microsoft BI
MicroStrategy Analytics
10.0

Add comparison