What users are saying about

SAS Advanced Analytics

Top Rated
81 Ratings

MicroStrategy Analytics

206 Ratings
Score 7.5 out of 101

SAS Advanced Analytics

Top Rated
81 Ratings
Score 8.4 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

SAS Advanced Analytics

SAS Advance Analytics is well suited for data that is visual. Data where you want to see multiple graphs and models are good for this software. However, if your data is more descriptive this may not be the best program. SAS is well suited for data where you need to make comparisons on the feasibility of two different programs. Data that can be compared is perfect for this software.
No photo available

Feature Rating Comparison

BI Standard Reporting

MicroStrategy Analytics
6.3
SAS Advanced Analytics
Pixel Perfect reports
MicroStrategy Analytics
6.1
SAS Advanced Analytics
Customizable dashboards
MicroStrategy Analytics
6.7
SAS Advanced Analytics
Report Formatting Templates
MicroStrategy Analytics
6.1
SAS Advanced Analytics

Ad-hoc Reporting

MicroStrategy Analytics
7.7
SAS Advanced Analytics
Drill-down analysis
MicroStrategy Analytics
8.6
SAS Advanced Analytics
Formatting capabilities
MicroStrategy Analytics
7.6
SAS Advanced Analytics
Integration with R or other statistical packages
MicroStrategy Analytics
5.9
SAS Advanced Analytics
Report sharing and collaboration
MicroStrategy Analytics
8.7
SAS Advanced Analytics

Report Output and Scheduling

MicroStrategy Analytics
7.5
SAS Advanced Analytics
Publish to Web
MicroStrategy Analytics
7.8
SAS Advanced Analytics
Publish to PDF
MicroStrategy Analytics
8.0
SAS Advanced Analytics
Report Versioning
MicroStrategy Analytics
6.9
SAS Advanced Analytics
Report Delivery Scheduling
MicroStrategy Analytics
7.8
SAS Advanced Analytics
Delivery to Remote Servers
MicroStrategy Analytics
7.0
SAS Advanced Analytics

Data Discovery and Visualization

MicroStrategy Analytics
7.4
SAS Advanced Analytics
Pre-built visualization formats (heatmaps, scatter plots etc.)
MicroStrategy Analytics
7.6
SAS Advanced Analytics
Location Analytics / Geographic Visualization
MicroStrategy Analytics
7.2
SAS Advanced Analytics
Predictive Analytics
MicroStrategy Analytics
7.3
SAS Advanced Analytics

Access Control and Security

MicroStrategy Analytics
8.4
SAS Advanced Analytics
Multi-User Support (named login)
MicroStrategy Analytics
8.0
SAS Advanced Analytics
Role-Based Security Model
MicroStrategy Analytics
8.1
SAS Advanced Analytics
Multiple Access Permission Levels (Create, Read, Delete)
MicroStrategy Analytics
8.9
SAS Advanced Analytics
Single Sign-On (SSO)
MicroStrategy Analytics
8.4
SAS Advanced Analytics

Mobile Capabilities

MicroStrategy Analytics
7.7
SAS Advanced Analytics
Responsive Design for Web Access
MicroStrategy Analytics
7.6
SAS Advanced Analytics
Dedicated iOS Application
MicroStrategy Analytics
8.0
SAS Advanced Analytics
Dedicated Android Application
MicroStrategy Analytics
8.1
SAS Advanced Analytics
Dashboard / Report / Visualization Interactivity on Mobile
MicroStrategy Analytics
7.2
SAS Advanced Analytics

Application Program Interfaces (APIs) / Embedding

MicroStrategy Analytics
7.7
SAS Advanced Analytics
REST API
MicroStrategy Analytics
8.0
SAS Advanced Analytics
Javascript API
MicroStrategy Analytics
6.6
SAS Advanced Analytics
iFrames
MicroStrategy Analytics
8.0
SAS Advanced Analytics
Java API
MicroStrategy Analytics
8.0
SAS Advanced Analytics
Themeable User Interface (UI)
MicroStrategy Analytics
8.0
SAS Advanced Analytics
Customizable Platform (Open Source)
MicroStrategy Analytics
7.5
SAS Advanced Analytics

Pros

  • Visual Insight is a very good tool for data discovery and for create quick dashboard presentation. This is is basically a online web based portal where you have capability to quickly slice & dice the data . Also it provides you options to create derived metrics & derived attribute (MSTR 10) with various mathematical or statistical functions. One of the major mention would be the map based data visualization where you can plot data based on Latitude & Longitude.Also with MSTR 10 following limitations were removed i) using hyperlink ii) HTML 5 is implemented instead of Flash ,so easy to be rendered in mobile too iii) Adding images is possible for hardcoding company logo & symbols
  • Drilling Capabilities. This requires some good backend data modeling. Once you bring in all the facts and dimensions you are supposed to establish relationship between them & create hierarchies. Then it would be easy to drill more & more. For example - Device hierarchy - (Device Used by User--> Browser-->Operating System)
  • Data Source Connectivity.
  • Enterprise Manager is basically BI to BI environment which is used by administrators or executives to track reporting usage, report performance,developer efficiency or frequency of usage & thousands of other statistics which proves to be very helpful in monitoring the efficiency of the whole environment. Once you set up Enterprise miner( which is a bit tricky) you will be able to access all the in built documents or you can custom built dashboard based on your usage
Abanish Mishra profile photo
  • Complex Survey Analysis- SAS is a great resource if you need to analyze complex survey data. One can easily write code for this by inserting (survey) in front of the procedure with the weight, cluster, and strata variables. (ex: surveyfreq)
  • Modeling/ Graphing- SAS creates clean and easy to understand graphs and models which take visual data to the next level.
  • Support- There is a large SAS Advanced analytics online support in place. It is easy to find help on many procedures that you will use in this software.
No photo available

Cons

  • 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
  • Expanded point and click options under the data tab.
  • Better resource information to help with circumstantial issues (i.e. graphing).
Nathan Och profile photo

Likelihood to Renew

MicroStrategy Analytics9.9
Based on 27 answers
I think there are better tools available than MicroStrategy such as Tableau based simply on the ease of manipulating data sets and how quickly you can churn through data sets. The amount of time it takes to train people on MicroStrategy is a bit frustrating as well. I think MicroStrategy has great potential, but could be a better product overall.
Toreyan Clarke profile photo
SAS Advanced Analytics4.5
Based on 5 answers
More cost effective options out there - WPS, Revolution Analytics (R), etc.
Bethany Klebanov 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
SAS Advanced Analytics6.1
Based on 2 answers
If SAS Enterprise Guide is utilized any beginning user will be able to shorten the learning curve. This is allow the user a plethora of basic capabilities until they can utilize coding to expand their needs in manipulating and presenting data. SAS is also dedicated to expanding this environment so it is ever growing.
Nathan Och 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
SAS Advanced Analytics10.0
Based on 1 answer
SAS probably has the most market saturation out of all of the analytics software worldwide. They are in every industry and they are knowledgable about every industry. They are always available to take questions, solve issues, and discuss a company's needs. A company that buys SAS software has a dedicated representative that is there for all of their needs.
Nathan Och 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
SAS Advanced Analytics9.0
Based on 1 answer
Although nothing is perfect, SAS is almost there. The software can handle billions of rows of data without a glitch and runs at a quick pace regardless of what the user wants to perform. SAS products are made to handle data so performance is of their utmost important. The software is created to run things as efficiently as SAS software can to maximize performance.
Nathan Och profile photo

Support

MicroStrategy Analytics10.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
SAS Advanced Analytics10.0
Based on 2 answers
Simple. Their knowledge and accessibility. Support can be reached via email, text, chat, or phone. They can also utilize WebEx to tap into your machine and see what the user is seeing. SAS is dedicated to helping their users maximize their software.
Nathan Och profile photo

In-Person Training

No score
No answers yet
No answers on this topic
SAS Advanced Analytics9.0
Based on 1 answer
SAS has regional and national conferences that are dedicated to expanding users' knowledge of the software and showing them what changes and additions they are making to the software. There are user groups in most of the major cities that also provide multi-day seminars that focus on specific topics for education. If online training isn't the best way for the user, there is ample in-person training available.
Nathan Och 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
SAS Advanced Analytics8.0
Based on 1 answer
There are online videos, live classes, and resource material which makes training very easy to access. However, nothing is circumstantial so applying your training can get tricky if the user is performing complex tasks. When purchasing software, SAS will also allocate education credits so the user(s) can access classes and material online to help expand their knowledge.
Nathan Och 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
SAS Advanced Analytics9.0
Based on 1 answer
Ask as many questions you can before the install to understand the process. Since a third party does the installation your company is sort of a passanger and it is easy to get lost in the process. It also helps to have all users and IT support involved in the install to help increase the knowledge as to how SAS runs and what it needs to perform correctly.
Nathan Och 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
No answers on this topic

Alternatives Considered

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
SAS allows the user a wider range of capabilities to cleanse and manipulate the data. Not only can the data be pulled directly into SAS, but before it is finalized it can be transposed, graphed, or altered in any way imaginable which puts it a step above the Business Objects and Crystal Reports. Not only that, but full reports can be created in SAS allowing the user to expand on the presentation of the data using charts, graphs, or lists. In addition, all SAS projects can be automated to update at a time chosen by the user which allows them to focus on other projects rather than on manually running projects repeatedly.
Nathan Och profile photo

Collaboration and Sharing

MicroStrategy Analytics7.5
Based on 14 answers
1) One of the major aspect of reporting is access control. For example the Business Intelligence team interacts with lot of business like Finance, Product, Marketing etc. Each and every of these businesses consists of their corresponding employee hierarchy starting from executives in the top of the pyramid to the developer who is at the bottom of the pyramid. But everyone in the hierarchy shouldn't have access to view or modify the report. Here's why access control is required. Also if the company is part of an IPO they would like to restrict a lot of key metrics from the employees who are at the bottom of the pyramid.MicroStrategy provides great access control facilities so that we can control sharing capabilities. We can define security roles and assign members to each and every security role. Now we can configure each and every security role to have specific privileges which is really helpful. So we restrict not only permissions for viewing a report but also different tool access capabilities.
2) Subscription Option - Email Delivery Subscription, File Refresh Subscription & Attachment Option in ExcelI have seen that a lot of executives demand to view a ready made report (to view key metrics instantly) sent to their email so that they can access it by desktop as well as a cell phone. This can be achieved from MicroStrategy. We can deliver dashboards (documents) in a specific time via emails. Delivery options can be easily manipulated. It is also possible to deliver it in pdf or Excel via email by setting up a separate file subscription for granular view and embedding a link for the drive where the file is stored. It also contains compression capabilities, password protected files, and delimiter options. You can send a file only to specific users and send a preview to all users with options for email subscription.There are also time based unsubscribe options available.
3)Data Sharing Can be done in PDF, ExcelIt is possible to quickly export data into Excel from Visual Insight Grid or Documents. Until the recent version of MicroStrategy 9.4.1 for PDF everything was Flash based. But starting with MicroStrategy 10 everything is pretty much based on HTML 5.
4)Native Excel Drivers for Old School PeopleI have seen a lot of executives (non tech savvy people) still prefer to see the data in a grid in Excel as they are not fan of visualization. They just care about the numbers being correct at the end of the day without any fancy graphical representation. MicroStrategy provides an option to have native Excel Drivers directly interacting with a live document. Once we install this add-on Excel will show you a MicroStrategy add-in in menu bar based on what you can connect to MicroStrategy projects. This can be really helpful sometimes for a quick data preview.
5)Visual Insight helps to quickly plot dashboardsA lot of tech savvy new users now a days like to use a visualization tool to observe different trends in data. For the last two decades people have been using Microsoft Excel for drawing charts and pivot tables. But MicroStrategy’s Visual insight takes the whole thing to another level. It is very user friendly and gives lot of options for quick manipulations of data. You can visually observe the data in a different format. It gives the option of derived metrics and derived attribute (MicroStrategy 10). Complex formulas can directly be applied on the metrics to add derived metrics. There are filter options. There are date sliders (mainly used for trend lines) and options to select a specific part of whole data set. Also functions like OLAP, data mining and statistics makes manipulations very easy.
6)Intelligent Cubes can be scheduled to refresh the dataThere is the concept of an Intelligent Cube which can be built on top of architect facts and dimensions. For refreshing data on a daily basis we can input schedules which can update data or delete and insert data in intelligent cubes at a specific time or multiple times in a day. Reports are supposed to be built of top of these cubes.
7)Direct Control to Hadoop via Hive & Free Form SQL Query to HadoopThere is way to direct query big data (in free form ) via Hive from Hadoop. The new version of MicroStrategy prime has also introduced native drivers a way through which big chunks of data can be taken in memory for faster retrieval of data.
Abanish Mishra profile photo
No score
No answers yet
No answers on this topic

Data Integration

MicroStrategy Analytics7.1
Based on 14 answers
It can be done and seems to work pretty well. I haven't used this feature extensively. Works great with our data warehouse.
Brandon Fitzpatrick profile photo
No score
No answers yet
No answers on this topic

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
SAS Advanced Analytics9.0
Based on 1 answer
It all depends on the type of SAS product the user has. Scaleability differs from product to product, and if the user has SAS Office Analytics the scaleability is quite robust. This software will satisfy the majority of the company's analytic needs for years to come. In addition, if SAS is not meeting the users needs the company can easily find SAS solutions that will.
Nathan Och profile photo

Return on Investment

  • Increased efficiency through scheduled reporting.
  • Decreased manual "massaging" of data through automated reporting.
  • Standardized metrics across business verticals.
Jonathon Frampton profile photo
  • Excellent ROI
  • Met all objectives
Arthur Tabachneck 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

SAS Advanced Analytics

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
SAS Advanced Analytics Editions & Modules
SAS Advanced Analytics
Additional Pricing Details