KNIME Analytics Platform vs. SAS Viya

KNIME Analytics Platform has vastly improved our effectiveness when working with large data sets. The self documenting GUI allows analysts to focus on what they are trying to accomplish, not complex code syntax. If we were to use traditional tools, like SQL, work would take much longer and it would be more difficult to collaborate both internally and with clients. Since KNIME Analytics Platform is database oriented, some spreadsheet functions are not supported, which is as it should be. For small data sets we often use Excel vlookup and pivot tables in place of KNIME Analytics Platform. If VBA code is requried, we go to KNIME Analytics Platform as we find VBA to be unstable in Excel.

We piloted SAS AA at my organization to see how well it compares with other free software tools such as RStudio and Anaconda. So far what we saw was very impressive especially with the visual display but was a little out of our price range. It would be useful in analyzing population health metrics combined with financial data.

Incentivized

• Visual programming as oppose to scripting encourages data analysts to reap deeper insights from their data
• Large community contribution in extending the KNIME Analytics Platform into other areas of analytics, e.g. Text Analytics, Predictive Analytics, ML, etc.
• Open source with periodic updates ensures it is equipped to deal with the most sophisticated data analytics use case

• 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

• Automation - e.g. RapidMiner Studio provides a Turbo Prep function, where one can get to working on models more quickly (RapidMiner is not open source though)
• KNIME does not replace a regular reporting tool - it is not meant to. However, if I have already spent some time developing a data acquisition and analytical model, it would be nice to be able to deploy, for example, a monitoring or reporting module that would process data autonomously and react accordingly.

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

We are happy with Knime product and their support. Knime AP is versatile product and even can execute Python scripts if needed. It also supports R execution as well; however, it is not being used at our end

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.

The training KNIME Analytics Platform provide helps you get to grips with a product that is already very intuitive. There is a KNIME Analytics Platform way of thinking about addressing problems, but once you understand a couple of patterns which you see again and again in your workflow it all makes sense.

Incentivized

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.

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.

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.

KNIME's HQ is in Europe, which makes it hard for US companies to get customer service in time and on time. Their customer service also takes on average 1 to 2 weeks to follow up with your request. KNIME's documentation is also helpful but it does not provide you all the answers you need some of the time.

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.

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.

KNIME Analytics Platform is easy to install on any Windows, Mac or Linux machine. The KNIME Server product that is currently being replaced by the KNIME Business Hub comes as multiple layers of software and it took us some time to set up the system right for stability. This was made harder by KNIME staff's deeper expertise in setting up the Server in Linux rather than Windows environment. The KNIME Business Hub promises to have a simpler architecture, although currently there is no visibility of a Windows version of the product.

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.

There are two aspects which put KNIME Analytics Platform ahead of other products. Firstly the fact that KNIME Analytics Platform comes at no cost and no restrictions on its use is an instant winner for any organisation wanting to democratise their data. It means that a client is free to install it on as many machines as they wish without worrying about costs, the number of seats required or payment models or procurement negotiation. It also means that we are not building costs into our clients business. Secondly, KNIME Analytics Platform has a very comprehensive set of tools for importing/exporting data, data manipulation and data science. Some products offer analytics packages on top of their base offering at additional cost and they are still not as comprehensive as what you get with KNIME Analytics Platform for free. For some types of analysis you may require to download additional packages with KNIME Analytics Platform, but its invariably at no cost, those packages are kept out of the main download to keep the size down. Due to the easy integration with R and Python, I view KNIME Analytics Platform as also having the capabilities of those languages too. This has helped me in the past with seamlessly importing a rare filetype and using very specific models not directly available in KNIME Analytics Platform.

Incentivized

SAS is faster then both SPSS and STATA. SAS also has better models and graphs when comparing the three softwares. However, STATA and SPSS are more user friendly. It is easy to use SPSS and STATA, because a lot of it is point-click. SAS requires some training to be able to use it as effectively as possible. SAS is better with large data sets, and it is easier to analyze many data points at the same time

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.

• It is suited for data mining or machine learning work but If we're looking for advanced stat methods such as mixed effects linear/logistics models, that needs to be run through an R node.
• Thinking of our peers with an advanced visualization techniques requirement, it is a lagging product.

Incentivized

• 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