Microsoft R Open / Revolution R Enterprise vs. MicroStrategy Analytics vs. SAS Viya

If you are a MS shop specifically, or have more generic data requirement needs from Microsoft sourced data this will work well. If you have a lot of disparate data across a number of unique platforms/cloud systems/3rd party hosted data warehouses then this product will have issues or a lack of documentation on the net. Performance-wise this product is equal to other R platforms out there.

Incentivized

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

Incentivized

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.

Incentivized

• It allows distributed algorithm runs on Hadoop HDFS cluster
• It allows using different file formats such as SAS7BAT files or complex files in tab or comma delimited making data munging easier
• It provides scalable solutions by allowing users to re-use R scripts and distributing the computing over nodes through RHadoop

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

• SAS is can be used as query builder tool which can automate a lot of excel process.
• There are variety of statistical options available that tie up good visual analytics.
• There are inbuilt models available for different operations which doesn't require any coding and are easy to run.

Incentivized

• Very steep learning curve... for such a quick and useful tool the learning curve is unacceptable.
• Very dangerous in the wrong hands. Because most add-ons are pre-written, you have to trust the community that malicious script is not used.

Incentivized

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

Incentivized

• SAS Analytics does not have very good graphic capabilities. Their advanced graphics packages are expensive, and still not very appealing or intuitive to customize.
• SAS Analytics is not as up-to-date when it comes to advanced analytical techniques as R or other open-source analytics packages.

Incentivized

In general, Revolution Analytics brings a lot of value to the organization. The renewal decision would be based on return on investment in terms of quantified actionable insights that are getting generated against the cost of the product. Additionally, market brand of the tool and reputation risk in terms of possible acquisition and its impact to overall organizational analytic strategy would be considered as well.

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.

Incentivized

Not only does SAS become easier to use as the user gets more familiar with its capabilities, but the customer service is excellent. Any issues with SAS and their technical team is either contacting the user via email, chat, text, WebEx, or phone. They have power users that have years of experience with SAS there to help with any issue.

It is good, easy to use, improvements are being made to the product and more info being shared in the community. It just needs some more time to become more integrated to other platforms and tools/data out there.

Incentivized

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.

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.

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.

Incentivized

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.

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.

Incentivized

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.

Generally support comes through the forums and user generated channels which are helpful, easy to access, quickly turned around and provided by knowledgeable users. However the support channels are not employees and the channels are often used as a way to learn quick difficult elements of R. Better design, users interface and tutorial options would alleviate the need for this sort of interaction.

Incentivized

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.

Incentivized

SAS is generally known for good support that's one of the main reasons to justify the cost of having SAS licenses within our organization is knowing that customer support is just a quick phone call away. I've usually had good experiences with the SAS customer support team it's one of the ways in which the company stands out in my view.

Incentivized

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.

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.

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.

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

Incentivized

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.

The two are different products for different purposes. But for someone who has little or no experience in R programming, Power BI would be better for starting with. Having said that, Microsoft R is built on R, thus allowing for customization of complex calculations not typically available otherwise.

Incentivized

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.

Incentivized

SAS was the incumbent tool, and what the team knew. We did look into using Revolution Analytics enterprise version of R, but the learning curve on that caused us to stick with SAS. In my current position, I've opted for WPS over SAS. I can still leverage my SAS experience, but the price is about 15% of what SAS charges, with extra functionality, such as direct database access. I can supplement WPS with free software, such R for anything that it might be missing.

Incentivized

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.

Incentivized

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.

• Helped save company money versus buying other stat software

Incentivized

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

• SAS is pretty expensive, so a company would need to take that into consideration before purchasing a license.
• A lot of companies are now starting to use SAS Advance Analytics, it is great for sharing data between departments.
• Presentations come out better when using SAS, and estimates are more precise to the confidence interval.

Incentivized