What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
1439 Ratings
257 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 7.3 out of 100

Microsoft SQL Server

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

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
Anonymous | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server is a great RDBMS and meets all of our requirements. If you need a stable DB platform to support your line of a business application you'll be well served. Licensing costs are far cheaper, more portable and a lot more user friendly than Oracle. Product support and security patches from Microsoft are strong.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

BI Standard Reporting

MicroStrategy Analytics
6.5
Microsoft SQL Server
Pixel Perfect reports
MicroStrategy Analytics
6.3
Microsoft SQL Server
Customizable dashboards
MicroStrategy Analytics
7.0
Microsoft SQL Server
Report Formatting Templates
MicroStrategy Analytics
6.3
Microsoft SQL Server

Ad-hoc Reporting

MicroStrategy Analytics
6.6
Microsoft SQL Server
Drill-down analysis
MicroStrategy Analytics
6.7
Microsoft SQL Server
Formatting capabilities
MicroStrategy Analytics
7.3
Microsoft SQL Server
Integration with R or other statistical packages
MicroStrategy Analytics
6.0
Microsoft SQL Server
Report sharing and collaboration
MicroStrategy Analytics
6.6
Microsoft SQL Server

Report Output and Scheduling

MicroStrategy Analytics
6.7
Microsoft SQL Server
Publish to Web
MicroStrategy Analytics
6.0
Microsoft SQL Server
Publish to PDF
MicroStrategy Analytics
7.4
Microsoft SQL Server
Report Versioning
MicroStrategy Analytics
7.5
Microsoft SQL Server
Report Delivery Scheduling
MicroStrategy Analytics
6.6
Microsoft SQL Server
Delivery to Remote Servers
MicroStrategy Analytics
5.8
Microsoft SQL Server

Data Discovery and Visualization

MicroStrategy Analytics
7.4
Microsoft SQL Server
Pre-built visualization formats (heatmaps, scatter plots etc.)
MicroStrategy Analytics
6.9
Microsoft SQL Server
Location Analytics / Geographic Visualization
MicroStrategy Analytics
6.3
Microsoft SQL Server
Predictive Analytics
MicroStrategy Analytics
9.1
Microsoft SQL Server

Access Control and Security

MicroStrategy Analytics
6.8
Microsoft SQL Server
Multi-User Support (named login)
MicroStrategy Analytics
6.8
Microsoft SQL Server
Role-Based Security Model
MicroStrategy Analytics
7.0
Microsoft SQL Server
Multiple Access Permission Levels (Create, Read, Delete)
MicroStrategy Analytics
6.6
Microsoft SQL Server
Single Sign-On (SSO)
MicroStrategy Analytics
7.0
Microsoft SQL Server

Mobile Capabilities

MicroStrategy Analytics
7.0
Microsoft SQL Server
Responsive Design for Web Access
MicroStrategy Analytics
6.0
Microsoft SQL Server
Dedicated iOS Application
MicroStrategy Analytics
8.0
Microsoft SQL Server
Dedicated Android Application
MicroStrategy Analytics
8.0
Microsoft SQL Server
Dashboard / Report / Visualization Interactivity on Mobile
MicroStrategy Analytics
6.2
Microsoft SQL Server

Application Program Interfaces (APIs) / Embedding

MicroStrategy Analytics
8.1
Microsoft SQL Server
REST API
MicroStrategy Analytics
7.0
Microsoft SQL Server
Javascript API
MicroStrategy Analytics
8.0
Microsoft SQL Server
iFrames
MicroStrategy Analytics
8.5
Microsoft SQL Server
Java API
MicroStrategy Analytics
8.5
Microsoft SQL Server
Themeable User Interface (UI)
MicroStrategy Analytics
8.8
Microsoft SQL Server
Customizable Platform (Open Source)
MicroStrategy Analytics
8.0
Microsoft SQL Server

Pros

MicroStrategy Analytics

  • They sell the product well, and make promises you will actually believe
  • "checks the box" for most features a company would need. Doesn't actually deliver them though
  • They answer the phone in a timely manner. Can't answer your questions or provide support, but the queue time isn't bad
  • They have online documentation. It's not up to date, and likely doesn't reflect the version of software you are using, but hey... they can point to it.
Jeff Harris | TrustRadius Reviewer

Microsoft SQL Server

  • Easy to configure and use with Visual Studio and Dot Net
  • Easy integration with MSBI to perform data analysis
  • Data Security
  • Easy to understand and use
  • Very easy to export database and tables in the form of SQL query or a script
Shivani Pandey | TrustRadius Reviewer

Cons

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.
Anonymous | TrustRadius Reviewer

Microsoft SQL Server

  • The import/export process can be tricky to follow with lots of steps and could be better for importing flat files
  • Obtaining help from Microsoft is cumbersome and often other internet sources are better and quicker
  • The documentation is not great and again it's generally better to obtain help elsewhere if needed
Paul Nockolds | TrustRadius Reviewer

Likelihood to Renew

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

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 6 answers
We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.
Lisandro Fernigrini | TrustRadius Reviewer

Usability

MicroStrategy Analytics

MicroStrategy Analytics 6.8
Based on 6 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 | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.6
Based on 10 answers
SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.
Andy Erickson | TrustRadius Reviewer

Reliability and Availability

MicroStrategy Analytics

MicroStrategy Analytics 9.0
Based on 3 answers
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 | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 10.0
Based on 2 answers
Its does not have outages.
Srikanth S | TrustRadius Reviewer

Performance

MicroStrategy Analytics

MicroStrategy Analytics 9.0
Based on 3 answers
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 | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 2 answers
SSAS data cubes may some time slow down your Excel reports.
Srikanth S | TrustRadius Reviewer

Support Rating

MicroStrategy Analytics

MicroStrategy Analytics 5.8
Based on 9 answers
MicroStrategy's support is very good. We don't have a lot of technical issues in the first place, but when we do have to open a case with them, their front-line engineers seem very capable and resolve most of the issues without escalation. Our sales team is also very good and keeps us in the loop on new features and makes sure we are satisfied customers.
Mark McCully | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 7.9
Based on 49 answers
We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.
luka horvat | TrustRadius Reviewer

In-Person Training

MicroStrategy Analytics

No score
No answers yet
No answers on this topic

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
It was good
Srikanth S | TrustRadius Reviewer

Online Training

MicroStrategy Analytics

MicroStrategy Analytics 9.0
Based on 5 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 | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
very hands on and detailed training
Srikanth S | TrustRadius Reviewer

Implementation Rating

MicroStrategy Analytics

MicroStrategy Analytics 9.0
Based on 7 answers
We measured following KPI for the success
  • Increase in Business Feeds Loads
  • Reduction in Controllers Manual Work.
  • Conversion of Manual Work into Systematic Workflows.
  • Increase in Customer Spend
  • Reduction in Service costs
  • Reduction in time-to-market for new campaigns
  • Increase in cross sell and Up sell
  • Error reduction in customer Identification
  • Existing client retained
Dharmesh Shah | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 10 answers
Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.
Bill Starling | TrustRadius Reviewer

Alternatives Considered

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.
Anonymous | TrustRadius Reviewer

Microsoft SQL Server

[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.
Anonymous | TrustRadius Reviewer

Scalability

MicroStrategy Analytics

MicroStrategy Analytics 9.0
Based on 2 answers
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 | TrustRadius Reviewer

Microsoft SQL Server

Microsoft SQL Server 9.0
Based on 1 answer
SQL server does handle growing demands of a mid sized company.
Srikanth S | TrustRadius Reviewer

Return on Investment

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

Microsoft SQL Server

  • Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
  • Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
  • Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.
Anonymous | TrustRadius Reviewer

Pricing Details

MicroStrategy Analytics

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Starting Price

MicroStrategy Analytics Editions & Modules

Additional Pricing Details
Must contact sales team for pricing information.

Microsoft SQL Server

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Starting Price

$0 Per License

Microsoft SQL Server Editions & Modules

Edition
Enterprise$13,748.001
Subscription$1,418.001
  1. Per License
Additional Pricing Details

Rating Summary

Likelihood to Recommend

MicroStrategy Analytics
6.3
Microsoft SQL Server
9.1

Likelihood to Renew

MicroStrategy Analytics
9.9
Microsoft SQL Server
9.0

Usability

MicroStrategy Analytics
6.8
Microsoft SQL Server
9.6

Reliability and Availability

MicroStrategy Analytics
9.0
Microsoft SQL Server
10.0

Performance

MicroStrategy Analytics
9.0
Microsoft SQL Server
9.0

Support Rating

MicroStrategy Analytics
5.8
Microsoft SQL Server
7.9

In-Person Training

MicroStrategy Analytics
Microsoft SQL Server
9.0

Online Training

MicroStrategy Analytics
9.0
Microsoft SQL Server
9.0

Implementation Rating

MicroStrategy Analytics
9.0
Microsoft SQL Server
9.0

Scalability

MicroStrategy Analytics
9.0
Microsoft SQL Server
9.0

Add comparison