MicroStrategy Analytics vs. Microsoft SQL Server

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
MicroStrategy Analytics
Score 7.6 out of 10
N/A
MicroStrategy Analytics is an enterprise business analytics and mobility platform. Key features include automatic big data analysis and reporting, data discovery and visualization, digital security credentials, and support for mobile devices.N/A
Microsoft SQL Server
Score 8.7 out of 10
N/A
Microsoft SQL Server is a relational database.
$1,418
Per License
Pricing
MicroStrategy AnalyticsMicrosoft SQL Server
Editions & Modules
No answers on this topic
Subscription
$1,418.00
Per License
Enterprise
$13,748.00
Per License
Offerings
Pricing Offerings
MicroStrategy AnalyticsMicrosoft SQL Server
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
More Pricing Information
Community Pulse
MicroStrategy AnalyticsMicrosoft SQL Server
Considered Both Products
MicroStrategy Analytics
Chose 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 …
Microsoft SQL Server
Chose Microsoft SQL Server
Microsoft was the original creator of the SQL database, and thus, they still rule the market and drive innovation when it comes to data warehousing systems. It's comparable in price and allows you to retain the structured datasets that you lose when you change to a NoSQL …
Chose Microsoft SQL Server
The major factor in favor of Microsoft SQL Server as compared to Oracle DBMS is its cost for small to medium enterprises. For larger organizations, Oracle DBMS's value is in being a bit more competitive but when it comes to smaller organizations, Microsft SQL Server is much …
Top Pros
Top Cons
Features
MicroStrategy AnalyticsMicrosoft SQL Server
BI Standard Reporting
Comparison of BI Standard Reporting features of Product A and Product B
MicroStrategy Analytics
3.5
25 Ratings
Microsoft SQL Server
-
Ratings
Pixel Perfect reports3.122 Ratings00 Ratings
Customizable dashboards4.222 Ratings00 Ratings
Report Formatting Templates3.323 Ratings00 Ratings
Ad-hoc Reporting
Comparison of Ad-hoc Reporting features of Product A and Product B
MicroStrategy Analytics
3.7
23 Ratings
Microsoft SQL Server
-
Ratings
Drill-down analysis3.321 Ratings00 Ratings
Formatting capabilities4.923 Ratings00 Ratings
Integration with R or other statistical packages3.115 Ratings00 Ratings
Report sharing and collaboration3.322 Ratings00 Ratings
Report Output and Scheduling
Comparison of Report Output and Scheduling features of Product A and Product B
MicroStrategy Analytics
4.9
22 Ratings
Microsoft SQL Server
-
Ratings
Publish to Web4.021 Ratings00 Ratings
Publish to PDF5.822 Ratings00 Ratings
Report Versioning6.619 Ratings00 Ratings
Report Delivery Scheduling4.921 Ratings00 Ratings
Delivery to Remote Servers3.34 Ratings00 Ratings
Data Discovery and Visualization
Comparison of Data Discovery and Visualization features of Product A and Product B
MicroStrategy Analytics
5.8
21 Ratings
Microsoft SQL Server
-
Ratings
Pre-built visualization formats (heatmaps, scatter plots etc.)4.119 Ratings00 Ratings
Location Analytics / Geographic Visualization3.318 Ratings00 Ratings
Predictive Analytics9.917 Ratings00 Ratings
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
MicroStrategy Analytics
4.2
20 Ratings
Microsoft SQL Server
-
Ratings
Multi-User Support (named login)4.818 Ratings00 Ratings
Role-Based Security Model4.319 Ratings00 Ratings
Multiple Access Permission Levels (Create, Read, Delete)4.319 Ratings00 Ratings
Single Sign-On (SSO)3.58 Ratings00 Ratings
Mobile Capabilities
Comparison of Mobile Capabilities features of Product A and Product B
MicroStrategy Analytics
6.0
18 Ratings
Microsoft SQL Server
-
Ratings
Responsive Design for Web Access2.518 Ratings00 Ratings
Mobile Application9.015 Ratings00 Ratings
Dashboard / Report / Visualization Interactivity on Mobile3.318 Ratings00 Ratings
Application Program Interfaces (APIs) / Embedding
Comparison of Application Program Interfaces (APIs) / Embedding features of Product A and Product B
MicroStrategy Analytics
8.0
7 Ratings
Microsoft SQL Server
-
Ratings
REST API4.15 Ratings00 Ratings
Javascript API8.06 Ratings00 Ratings
iFrames9.04 Ratings00 Ratings
Java API9.03 Ratings00 Ratings
Themeable User Interface (UI)9.04 Ratings00 Ratings
Customizable Platform (Open Source)9.05 Ratings00 Ratings
User Ratings
MicroStrategy AnalyticsMicrosoft SQL Server
Likelihood to Recommend
5.1
(46 ratings)
9.1
(95 ratings)
Likelihood to Renew
9.9
(27 ratings)
9.0
(6 ratings)
Usability
3.5
(5 ratings)
9.9
(10 ratings)
Availability
9.0
(3 ratings)
10.0
(2 ratings)
Performance
9.0
(3 ratings)
9.0
(2 ratings)
Support Rating
2.5
(8 ratings)
7.9
(49 ratings)
In-Person Training
-
(0 ratings)
9.0
(1 ratings)
Online Training
9.0
(5 ratings)
9.0
(1 ratings)
Implementation Rating
9.0
(7 ratings)
9.0
(10 ratings)
Configurability
9.0
(1 ratings)
10.0
(1 ratings)
Ease of integration
-
(0 ratings)
9.0
(1 ratings)
Product Scalability
9.0
(2 ratings)
9.0
(1 ratings)
Vendor post-sale
10.0
(1 ratings)
9.0
(1 ratings)
Vendor pre-sale
10.0
(1 ratings)
9.0
(1 ratings)
User Testimonials
MicroStrategy AnalyticsMicrosoft SQL Server
Likelihood to Recommend
MicroStrategy
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
Read full review
Microsoft
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.
Read full review
Pros
MicroStrategy
  • 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.
Read full review
Microsoft
  • 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
Read full review
Cons
MicroStrategy
  • 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.
Read full review
Microsoft
  • 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
Read full review
Likelihood to Renew
MicroStrategy
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.
Read full review
Microsoft
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.
Read full review
Usability
MicroStrategy
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.
Read full review
Microsoft
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.
Read full review
Reliability and Availability
MicroStrategy
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.
Read full review
Microsoft
Its does not have outages.
Read full review
Performance
MicroStrategy
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.
Read full review
Microsoft
SSAS data cubes may some time slow down your Excel reports.
Read full review
Support Rating
MicroStrategy
Good user community. Support team is available if you are under AMC. You get decent support after raising the support ticket. If it is product bug they will inform you and let you know which patch will resolve the same.
Read full review
Microsoft
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.
Read full review
In-Person Training
MicroStrategy
No answers on this topic
Microsoft
It was good
Read full review
Online Training
MicroStrategy
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.
Read full review
Microsoft
very hands on and detailed training
Read full review
Implementation Rating
MicroStrategy
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
Read full review
Microsoft
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.
Read full review
Alternatives Considered
MicroStrategy
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.
Read full review
Microsoft
[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.
Read full review
Scalability
MicroStrategy
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.
Read full review
Microsoft
SQL server does handle growing demands of a mid sized company.
Read full review
Return on Investment
MicroStrategy
  • 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.
Read full review
Microsoft
  • 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.
Read full review