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

Microsoft BI

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

Likelihood to Recommend

Microsoft BI

Most suitable scenarios:
-Large scale report automation and distribution.
-Self service BI for internal and external users.
-Relational databases and multidimensional models.
-Comprehensive security & access control.

Less appropriate scenarios:
-Non-relational databases
-Low budget
-Tight timeframe

I'd invite anyone reading this far to think hard on his/her goals with BI. Are you trying to build a solid and endurable BI service for your clients or your own organisation? Or do you just need to have some quick visualisation of the data you have to make strategic or operational decisions in a few weeks time?

Implementing a MicrosoftS BI stack takes time, knowledge, and skills, none of these comes cheaply these days. If your answer to my first question is "yes", go ahead and study Microsoft BI a bit more then make your decision on your own. If you see my second question is most relevant to you, go and grab a web-based BI tool such as SiSense, Tableau, Splunk, and so on. Take the free trial option and see if you can test your ideas fast and at a lower cost. Good luck!
Haibo Yang profile photo

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

Feature Rating Comparison

BI Standard Reporting

Microsoft BI
8.0
MicroStrategy Analytics
7.1
Pixel Perfect reports
Microsoft BI
7.8
MicroStrategy Analytics
6.0
Customizable dashboards
Microsoft BI
7.9
MicroStrategy Analytics
8.3
Report Formatting Templates
Microsoft BI
8.2
MicroStrategy Analytics
6.9

Ad-hoc Reporting

Microsoft BI
8.4
MicroStrategy Analytics
7.4
Drill-down analysis
Microsoft BI
8.2
MicroStrategy Analytics
9.1
Formatting capabilities
Microsoft BI
8.4
MicroStrategy Analytics
8.7
Integration with R or other statistical packages
Microsoft BI
8.2
MicroStrategy Analytics
5.2
Report sharing and collaboration
Microsoft BI
8.9
MicroStrategy Analytics
6.7

Report Output and Scheduling

Microsoft BI
8.2
MicroStrategy Analytics
7.7
Publish to Web
Microsoft BI
8.3
MicroStrategy Analytics
7.3
Publish to PDF
Microsoft BI
8.8
MicroStrategy Analytics
8.8
Report Versioning
Microsoft BI
8.1
MicroStrategy Analytics
6.4
Report Delivery Scheduling
Microsoft BI
7.5
MicroStrategy Analytics
8.8
Delivery to Remote Servers
Microsoft BI
8.2
MicroStrategy Analytics
7.0

Data Discovery and Visualization

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

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

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

Pros

Microsoft BI

  • Point 1. User defined automation of report execution and distribution. Microsoft SSRS so far is one of the most user friendly report scheduling and distribution platforms available. Our client users, often non-technical business people, can subscribe to any reports they have access to on the report server and make a customised execution by setting up parameter values, export formats, receipients, etc. etc. Many users use this feature to monitor their action lists and risk profiles on a regular basis. They absolutely love it!
  • Point 2. Extensive programmability. Programmability has always been a great strength of many Microsoft products. Adding to my point 1, take Microsoft SSRS for example, it comes with a great deal of programmability. This means what client users need do in point 1 to set up the report execution and distribution by themselves, can now be programmed and completed automatically. One trick we often do is to program on SSRS for automatically executing and distributing a report using different parameter values to generate different results and then send to the email boxes of tens, if not hundreds of line managers within client organisations. Every line manager will only receive the results relevant to his/her own business unit(s). Once set up, a client organisation can save hundreds hours of work on Excel spreadsheets each month. Clients are willing to pay you a fortune for such a level of automation in reporting process!
  • Point 3. Flexible integration with SSAS. Instead of praising the more techinical features such as partitions and actions shipped with SSAS, I'd make my point 3 to be more business user friendly by emphasising the integration options of SSAS. Excel, Power BI, SharePoint, and third party tools such as Tableau, can all be easily and nicely integrated with SSAS objects. Not to mention since MSSQL 2012 you also have got the choice between Tabular models and Multidimensional models. Your business analysts will love the flexibility SSAS can provide!
  • Point 4. Stability of the IDE. Of course this one is to me when I'm in a BI developer mode. Using Visual Studio to develop SSAS, SSIS, and SSRS objects is a relaxing experience and will be good to the longevity of your developers. Why? Because VS is stable enough to not crash your developers' computers. As a matter of fact, VS has never crashed my OS since 2008...I mean it.. though a few times before 2008...Unlike some other seemingly simpler IDEs which may freeze or overpower your OS while processing your design changes... VS is a powerful yet stable tool and your developers will love it.
Haibo Yang 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

  • The graph options are not as robust as an Excel user might want.
  • The metadata layer can sometimes be slower, and it takes a long time for reports to run.
  • Viewing the data feed entered can be cumbersome at times, in terms of validation with reports.
No photo available

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 have been using Microstrategy for 8 years now and I have been exposed to other BI Tools. Hands down Microstrategy is the most robust and versatile tool I have used in my career.
Shawn Stephens profile photo

Usability

Microsoft BI

Microsoft BI 7.0
Based on 5 answers
It's a good rating for people willing to learn and get used to it, but it's not inherently user friendly, especially to people who are not Excel power users.
Alexander Lubyansky profile photo

MicroStrategy Analytics

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

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
Quick response. Lots of blogs and support forums are there to get the answer myself
No photo available

MicroStrategy Analytics

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

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

Implementation

Microsoft BI

Microsoft BI 9.6
Based on 7 answers
Be prepared to help business users define their data. We found that different campuses had different definitions for the same thing. This took some change management and negotiating to get each team to come to a common understanding.
Robert Goodman profile photo

MicroStrategy Analytics

MicroStrategy Analytics 8.0
Based on 3 answers
Will require a technical and knowledgeable team.
No photo available

Alternatives Considered

Microsoft BI

Microsoft BI provides the most flexibility and best integration across of the products in the SQL Server Microsoft BI Suite (and with other Microsoft tools). The tools are flexible enough to work just as well in a small group as they are in a large enterprise and without having to re-learn the products to fit those different scenarios. All of the tools in the SQL Server Microsoft BI stack are provided with one licenses (assuming you install everything on one server) and all of the development tools required are available for free if they they aren't included with the main installer. The Microsoft BI tools will work with most of the major database systems out of the box and if it doesn't, there is a very active 3rd party software environment that develops free or paid add-ons that will cover the options that Microsoft doesn't out of the box. The tools are easy to learn and use and updated on a very regular basis. There is always the flexibility to add or take away from the products installed as part of a Microsoft BI solution, so you never have to be locked into using only the tools provided by Microsoft.
Steve Wake profile photo

MicroStrategy Analytics

Tableau was more costly and took longer to learn to use. While it does have some perks (such as no metadata layer), I find using the online version of Tableau is not as fast as the online version of Microstrategy, and creating data descriptors is easier in the latter. Tableau does not offer customization of reports as easily, either
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

  • At the moment, the lack of use of Power BI has indered our market progression IMO
  • A large majority of customers keeps the solution once implemented, very few have switched platform
  • Once organizations implement Office 365, the potential for added business with Microsoft BI will really manifest. At this time, the slow adoption of Office 2013 or more recent is limiting the analysis and visualizations capabilities of our average client.
Charles Saulnier profile photo

MicroStrategy Analytics

  • No comment since MicroStrategy was already implemented prior to my employment.
Randy Kirschner 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

Microsoft BI
Edition
Power BI
$0
Power BI Pro
$102
2. 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

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

Add comparison