QlikView vs. SAS Viya

Sales data validations have helped manage our justifications in the past, especially with regard to new product development and new business introduction. It has also been helpful in identifying trends with business impact and direction specific to quarter and monthly sales from ERP data as well as decisions to purchase equipment of staffing based on run rates and product demand.

One thing that can get out of hand is data output - if you aren't careful in your query, you may be overloaded with data dumps and drown in the amount of info you have to filter through. This is a user caution, not a comment on the software itself.

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

• QlikView has a simple, relational data model that's REALLY fast. Filtering and changing data is dead simple results are almost immediately available.
• The free version of Qlikview is almost completely featured, so you roll a pro-level product out to an entire department for really cheap.
• QlikView is really flexible--if you can imagine it, you can build it.

Incentivized

• 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

• We found that QlikView can be a bit slow in supporting some forms of encryption. It is web-based and we needed to upgrade all of our server to not support the older SSL and TLS 1 protocols, only support TLS 1.2 and TLS 1.3. However, QlikView could not run with TLS 1.2 and TLS 1.3. We had to wait over six months to get a version that would handle the newer TLS versions.
• There are so many options with QlikView that you can get lost when developing a visualization. There are still items I have not yet figured out, such as labeling a graph with the name of a selected detail item.
• QlikView works by pulling the data it is going to use for visualization into its database. I am a security reviewer and I need to make certain that PII and PHI is not pulled by QlikView for a visualization, otherwise this could become a reportable indecent.

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

Ease of use, ability to load from pretty much any data source. today I created an application that loaded time sheets from excel that are not in a table format. With Qlik's "enable transformation steps" I was able to automate loads of multiple spreadsheets and multiple tabs easily. Could not do that with any other tool.

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.

QlikView is very easy to implement. The installation is very straight forward. QlikView has several different data connectors that can connect to different data sources very smoothly. The user interface to build the reports is very easy to understand. This helps to have a smaller learning curve. Something very helpful is that QlikView is a browser application for the end users. So, you don't need to install any applications on the user's computer.

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.

We have not had any downtime issues with the product nor uncovered any significant bugs

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.

It is not a SAAS product.

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.

My experience with the Qlik support team has been somewhat limited, but every interaction I have had with them has been very professional and I received a response quickly. Typically if there is a technical issue, our IT team will follow up. My inquiries are specific to product functionality, and Qlik has been very helpful in clarifying any questions I might have.

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

My team attended, but I cannot myself rate, but I think it was good as they've successfully launched a training program at our company themselves for users. It was 3-4 day training.

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.

Training was as expected. The demo environments tend to be more fully featured that our own environment, but the training was clear and well delivered.

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.

"Implementation" can mean a few things... so I'm not sure that this is the answer you want.... but here it goes: To me, implementation means: "Is the user interface intuitive and can I produce meaningful reports with ease?" On that score, I'd say YES. The amount of training required was minimal and the results were powerful. The desktop implementation is a simple, "blank" interface just waiting for your creativity. The pre-populated templates give you a reasonable start to any project -- and a good set of objects to "play around with" if you're just getting started. Finally, note that the "implementation" I used was baked into QuickBooks 2016 Enterprise -- called "Advanced Reporting"..... That integration makes it ultra useful and simple.

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 only other vendor product that I have worked with that provides a similar experience to Qlikview is Tableau. I would recommend Tableau if your use case is to build a fixed dashboard. You can share reports for free without needing to buy additional licenses. I would recommend Qlikview if your users are looking for a more interactive experience. They can create new objects to represent the data which can't be accomplished as easily in Tableau

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

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.

• You can use the free desktop version to do a lot of reporting and analysis work more quickly so the ROI is huge
• QlikView is great at finding outliers such as data entry errors
• QlikView is great at helping you quickly discover new insights about your business that can prompt you to take action that can immediately affect your cash flow.

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