What users are saying about

MicroStrategy Analytics

206 Ratings
Score 7.5 out of 101

Microsoft BI

594 Ratings
Score 7.8 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 BI

Many companies consider SSIS as 'free' since it comes included with the SQL server database. It seems an obvious choice if your data resides in SQL server to go ahead and utilize Microsoft BI tools. Notice, this is not the only option you have but one that many people would consider convenient. However, if most of your data does not reside in SQL server already, consider a wider choice of options for your BI. Another factor is the availability of skilled resources to maintain your BI environment. Due to its popularity on the market you will find most of people in the BI world are able to work with Microsoft BI
Julia Gusman profile photo

Feature Rating Comparison

BI Standard Reporting

MicroStrategy Analytics
6.3
Microsoft BI
8.2
Pixel Perfect reports
MicroStrategy Analytics
6.1
Microsoft BI
8.1
Customizable dashboards
MicroStrategy Analytics
6.7
Microsoft BI
8.1
Report Formatting Templates
MicroStrategy Analytics
6.1
Microsoft BI
8.4

Ad-hoc Reporting

MicroStrategy Analytics
7.7
Microsoft BI
8.5
Drill-down analysis
MicroStrategy Analytics
8.6
Microsoft BI
8.6
Formatting capabilities
MicroStrategy Analytics
7.6
Microsoft BI
8.3
Integration with R or other statistical packages
MicroStrategy Analytics
5.9
Microsoft BI
8.3
Report sharing and collaboration
MicroStrategy Analytics
8.7
Microsoft BI
8.8

Report Output and Scheduling

MicroStrategy Analytics
7.5
Microsoft BI
8.7
Publish to Web
MicroStrategy Analytics
7.8
Microsoft BI
8.7
Publish to PDF
MicroStrategy Analytics
8.0
Microsoft BI
8.5
Report Versioning
MicroStrategy Analytics
6.9
Microsoft BI
8.8
Report Delivery Scheduling
MicroStrategy Analytics
7.8
Microsoft BI
8.8
Delivery to Remote Servers
MicroStrategy Analytics
7.0
Microsoft BI
8.5

Data Discovery and Visualization

MicroStrategy Analytics
7.4
Microsoft BI
8.8
Pre-built visualization formats (heatmaps, scatter plots etc.)
MicroStrategy Analytics
7.6
Microsoft BI
9.0
Location Analytics / Geographic Visualization
MicroStrategy Analytics
7.2
Microsoft BI
8.8
Predictive Analytics
MicroStrategy Analytics
7.3
Microsoft BI
8.5

Access Control and Security

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

Mobile Capabilities

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

Application Program Interfaces (APIs) / Embedding

MicroStrategy Analytics
7.7
Microsoft BI
8.4
REST API
MicroStrategy Analytics
8.0
Microsoft BI
8.6
Javascript API
MicroStrategy Analytics
6.6
Microsoft BI
8.4
iFrames
MicroStrategy Analytics
8.0
Microsoft BI
8.4
Java API
MicroStrategy Analytics
8.0
Microsoft BI
8.3
Themeable User Interface (UI)
MicroStrategy Analytics
8.0
Microsoft BI
8.7
Customizable Platform (Open Source)
MicroStrategy Analytics
7.5
Microsoft BI
8.0

Pros

  • Extremely fast and reliable sql generation, report and document development.
  • Flexibility and integration with nearly all data sources.
  • Self reliant product, many out of the box products that allow easy maintenance, development, and monitoring.
  • Cost of product is more reasonable than many other in its class.
  • Reports and documents produced can be pixel perfect and allow for extremely custom dashboards and scorecards.
Paul Campbell profile photo
  • The interfaces of the products are familiar to most people that currently use Microsoft products so its comfortable in that respect
  • Creating a report is easy to do with drag/drop functionality. You also have alot of dropdowns. You can use formulas the same way you do in Excel. They have "expressions" which are like formulas with a mix of SQL.
  • Publishing a report to the server is simple as well. You go to the server and upload the file from your file directory.
  • Setting up subscriptions is simple as well. Anyone can do it with minimal knowledge. Its sort of like creating a recurring calendar event.
  • The hierarchy within SSRS is intuitive. A Project is the top level item. You can add as many reports as you want to a project. Similar to any other IDE where you keep all your files in one project (HTML, CSS, JavaScript, JSP, Servlet) except in the case of SSRS its all reports.
  • Whether you choose to use 2008 or 2012 the interface is layed pretty much the same. So if you start of in 2008 and then upgrade, you dont have to re-learn anything. Their are slight differences in the two versions but it wont hinder your ability to build a report.
Mashhood Syed profile photo

Cons

  • There are many tools and products in the whole Analytics suite, I find this cumbersome and would like to see all these tools brought together
  • There is no version control built into the product. Versioning seems outdated and the principle way of handling versions is outdated and I think should be remodeled.
  • To a new user, learning the entirety of all MicroStrategy products is difficult and can take a long time to adapt to.
Paul Campbell profile photo
  • Power BI maturity: Power BI is a combination of add-ons for Microsoft Excel and a special Office365 hosting site. However, the primary presentation tool, Power View, has a long way to go to catch up with such competitors as Tableau and even Microsoft's current analytics platform, PerformancePoint. To address these concerns, Power BI releases are being scheduled out-of-band from normal version upgrades in order to address requirements of the user community.
  • Office 365: There are currently size limitations, like a 250GB max for PowerPivot worksheets, which might cause issues with organizations who want to utilize very large data sets with Power BI.
  • Messaging: Some of the marketing and best practices around the new cloud-based solutions are unclear, making it difficult for someone who doesn't work in the BI world to understand the benefits and the architecture for such solutions.
  • Multiple data manipulation languages: Currently there are four or five distinct query languages in the Microsoft BI stack: T-SQL for SQL Server, MDX and DAX for Analysis Services, and the Power Query Formula Language for Power Query. In Integration Services, there is yet another language used in some of the tasks. That seems to be a lot to keep abreast of!
Chris Utter profile photo

Likelihood to Renew

MicroStrategy Analytics9.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
Microsoft BI8.0
Based on 25 answers
The product has functioned as promised and the level of support has been excellent. We get a sense the Microsoft is putting a lot of effort into help us succeed with their products. Even though Power View and Report Builder are lacking in some functionality, I have already seen improvements in the tools and I know enhancements are forthcoming.
Nathan Patrick Taylor 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 BI7.0
Based on 5 answers
The product is very usable compared to competitive solutions. I didn't give it a full 10 because Microsoft needs to improve their Report Builder module.
Robert Goodman 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
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
Quick response. Lots of blogs and support forums are there to get the answer myself
No photo available

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

Breadth of Deployment

Our customers are mainly internal to the business having a user base in the hundreds. The types of users who are active with MicroStrategy range from business analysts to software developers.
Paul Campbell profile photo
Poorly adopted by users. Mostly caused by project priorities focused on technical aspect and not on reports and dashboards for final users.
Frederic Freyermuth ☁ profile photo

Alternatives Considered

Microstrategy is already used in the organization and it clearly is used by many leading industries. Tableau and Salesforce are comparatively new to this.
Rishi Bavishi, CSSGB, CAPM 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

Collaboration and Sharing

MicroStrategy Analytics7.5
Based on 14 answers
This capability really easy and handy to support especially if you have to provide limited access to virtual person or an intern. Data sharing and using inbuilt features are really easy and gives a lot of options. Subscriptions to reports and read/write capabilities are also helpful in terms of flexing up for modifications under reports.
Rishi Bavishi, CSSGB, CAPM profile photo
Microsoft BI8.2
Based on 27 answers
Microsoft BI allows users to access a portal where reports and indicators are published. Sharepoint also integrates very well with Microsoft BI, which greatly improves collaboration capabilities. The access through mobile devices improved a lot in the last versions and it is possible to access the reports, indicators, and dashboards natively from iOS.
Gonzalo Angeleri profile photo

Data Integration

MicroStrategy Analytics7.1
Based on 14 answers
The process of connecting data to Microstrategy is easy and appreciated. It functions as expected, there are no conflicts between the source and the end result that's pulled from Microstrategy.
★Alex Khamudis profile photo
Microsoft BI8.7
Based on 26 answers
It has been really simple to connect data sources, both offline and online
Micah Jones 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

  • Good returns considering integrated objects and reports for multiple mediums
  • Not sure but cost of development seemed a little higher which is also an outcome of lack of good development vendors or resources. Not a concern over MSTR as a tool.
  • Deployment to mobile or distribute sharing is an advantage as object oriented architecture reduces rework and maintenance steps.
Vineet Rai 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