2013-11-10T18:51:00Z

SAS BI vs. QlikView

it_user11115 - PeerSpot reviewer
  • 1
Published:
Explore related topics
Product comparison that may be of interest to you
PeerSpot user
3

3 Comments

it_user5802 - PeerSpot reviewer
Vendor
2013-11-14T15:57:58Z
Nov 14, 2013

I can tell you all about SAP Business Objects. I do not have any experience with QlikView/QlikTech. Just looking over the info for them, QlikView is somewhat of a cross between Informatica, Cognos, and SAP Business Objects. It has it's own servers to assemble and present the data and connections to most any type of datasource. They all pretty much offer the same thing. The devil is in the details and the underlying development of the data acquisition layer. No one creates an engine that can look at your data in its original data structure and magically produce reports for you. Especially with the dynamics of "drill into". SQL Server's Anayltics are about as close as it gets, on a SQL Server database. The real trick is to find a product that the Information team understands, and have people that know the data structure and business rules build the foundational data acquisition layer of the product. It all comes down to how the data is laid out, how the table joins are made, and how well tuned the systems are. A poorly designed database will give you poor performance no matter what tool you use. The table joins are key because you do not always join tables the same way in very large highly flexible systems like EPIC's Clarity model (for healthcare)

it_user7716 - PeerSpot reviewer
Vendor
2013-11-17T12:36:46Z
Nov 17, 2013

I don't have direct experience with either tool. Anecdotally, SAP BI is great if you have a big IT department behind you. It is at least an enterprise-level tool. QlikView is a "me too" product that offers some of the features behind enterprise-level tools but is fairly stripped down. Almost anything will be easier to implement than SAP BI, but if SAP is this company's native ERP, they will save on integration costs by using SAP BI.

Neither will be easy to implement. It is a misconception that any BI tool is easy to use. All of them have a steep learning curve. All run best with a data warehouse behind them. Any BI tool can do some things easily, and just about any will do dashboards on non-dimensional data such as the relational tables ERPs use. For any kind of in-depth analysis you'll need at least a partially dimensional structure.

The benefit of using a BI tool that integrates with the ERP is that you can use canned reports. If stripped down P&L style reports are what is needed, those can usually be done pretty quickly.

For cost savings, nothing beats MS SQL Server. Anything above 2008 has at least rudimentary data mining tools also. The interface is clunky, but it's just queries and displays.

it_user3996 - PeerSpot reviewer
Consultant
2013-11-14T15:47:48Z
Nov 14, 2013

Without understanding the company's context, it is hard to recommend one over the other. The big unanswered question is, what problem are they trying to accomplish with a new BI product?

SAS is probably the most widely used statistical analysis tool in the market, having been around for decades. SAS has added some BI reporting features but that would not be its strength. It can be very expensive; alternatives include IBM SPSS and the open-source R package. These are technical developer tools.

QlikView is a data visualization tool popular in Europe and gained some momentum here in the states. QlikView's competitors include Tableau and Tibco Spotfire (of the three, Tableau is probably the winner). These are business analysts tools.

If the company is looking for BI reporting products, they would consider offerings such as: IBM Cognos, SAP Business Objects, MicroStrategy, and Information Builders' WebFOCUS.

I have a manufacturing background and would be happy to talk.

Find out what your peers are saying about Microsoft, Tableau, SAP and others in BI (Business Intelligence) Tools. Updated: March 2024.
765,234 professionals have used our research since 2012.
Related Questions
HE
Jun 7, 2023
Jun 7, 2023
Dataiku is my choice as it's not bulky and the learning path for people like me (noobs in ML and data science) is not steep at all, so after a couple of pieces of training I feel very confident. Also, you can check it out for free, it has the sandbox free of charge. For the guys who are tech-aware, it provides a wide variety of tools as well as flexible customization (via code notebooks, preset...
See 1 answer
MI
Jun 7, 2023
Dataiku is my choice as it's not bulky and the learning path for people like me (noobs in ML and data science) is not steep at all, so after a couple of pieces of training I feel very confident. Also, you can check it out for free, it has the sandbox free of charge. For the guys who are tech-aware, it provides a wide variety of tools as well as flexible customization (via code notebooks, preset connectors, etc). The pricing bites but the charge depends on the scale of your needs, so you have a choice there. As for SAS - I personally didn't use it but read many reviews stating that it's kinda clumsy and not intuitive to use vs many other solutions, though I might be wrong.
Julia Miller - PeerSpot reviewer
Jan 3, 2024
Jan 3, 2024
The product is expensive and needs the integration of more languages.
2 out of 8 answers
SL
Aug 10, 2021
The powerful nature of SAS can sometimes work to its detriment, because there is a need for coding when it comes to digital reporting and that's a little overwhelming or intimidating for some of my coworkers. They're features that not all solutions have. Our biggest frustration with the solution is not being able to easily embed things on our website. That's become more important for us and we're trying to work with SAS support to be able to do that. There's a lot of back and forth, but they're willing to help. Adoption of the software has been difficult because people automatically assume that it's going to be more difficult than it is. People want to be able to create dashboards very quickly and get them on the website as fast as possible so they'll do it with Tableau, and SAS doesn't work that way. SAS deals more with those wanting to create dashboards based on a database.
LM
Dec 13, 2021
Regarding performance, they have some issues. They have always had some issues there. They are better, however, still, there are some issues around performance. The installation process can be a bit complex.
Related Articles
EB
May 2, 2022
May 2, 2022
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Here you'll find recent contributions by PeerSpot community members: questions, articles and trending discussions. Trending See what your peers are discussing at the moment! What to choose: an endpoint antivirus, an EDR solution, or both? What is your recommended IT Service Management (ITSM...
EB
Apr 4, 2022
Apr 4, 2022
Hi peers, This is our new Community Spotlight that includes recent contributions (questions, articles and discussions) by the PeerSpot community members. Trending Is RPA beneficial for a healthcare organization? With the increasing risk of cyber attacks in the west, due to the war in Ukraine, how safe is your data in the cloud? Articles 8 Business Automation Ideas to Sav...
Product Comparisons
Related Articles
EB
May 2, 2022
Community Spotlight #13: Top Products and Solutions
Hi peers, We're happy to share our new bi-weekly Community Spotlight with you. Her...
EB
Apr 4, 2022
Community Spotlight #11
Hi peers, This is our new Community Spotlight that includes recent contributions (ques...
Download Free Report
Download our free BI (Business Intelligence) Tools Report and find out what your peers are saying about SAS, Tableau, Microsoft, and more! Updated: March 2024.
DOWNLOAD NOW
765,234 professionals have used our research since 2012.