Friday, February 13, 2009

QlikView vs. BO

Dear Friends,

A Most Awaited Comparison of QlikView with BO is ready for you. While comparing QlikView with BO and Cognos I was really wondering if you have to buy either BO or Cognos which one you will opt for you. Why I am wondering for because it is really hard to find difference between BO and Cognos technically both the architectures are almost same. Then you left yourself on the sales person's experience (I mean now it depend on the sales persons of both products how better they can explain their product and convince you).

I suggest before you decide for a BI ,you must have a look on QlikView and ask your QlikView vendor for a proof of concept (POC), it will help you to explore capabilities of QlikView and a POC will not take more than 3 hrs to make decent no. of reports. Hope this Comparison with BO will help you while deciding a BI tool for you.

I welcome your suggestions.

Happy Reading.

#

Product

Business Objects

Qlik View

A

Product

1

Product

Business Objects

QlikView: World's Fastest Growing BI tool. With 10.3 customers being added every working day.

2

Vendor

SAP

QlikTech

QlikView is an IN-memory based BI tool which can be deployed in a week's time. It comes at HALF the TCO and delivers TWICE the value compared to any OLAP based BI Solution In QUARTER of the TIME

C

Applications

1

Business intelligence

Yes

QlikView is a single integrated tool for ETL, DW, Multi Dimensional Analysis, Dash boarding, Reporting, as per the Butler group user takes couple of hours training instead of weeks taken by traditional OLAP based tools

2

Multi dimensional view

3

Strategic planning

Yes

4

Budgeting

Yes

5

Forecasting

Yes

6

Consolidation

Yes

7

Score carding

Yes

D

Hardware and Licenses

1

Warehousing is (Mandate/ Optional)

Mandate

NOT REQUIRED, One of the major advantage of using QlikView is, it does not require database which saves money and very well skilled human resource. With no data warehouse required QlikView can be implemented in a couple of weeks saving a lot of TIME, MONEY AND RESOURCES.

2

Server Licenses(Named/CPU)

Named

Named

3

User Licenses (Name/Concurrent/Unlimited)

Named

Named

4

Web Users

Unlimited

User lic

5

If preparatory Database specify (Technical and Methodology)

NO

NO: QlikView uses its integrated Robust ETL to Extract data from multiple data sources and forms a data repository using its patented Technology (AQL: Associative Query Logic) This technology overcomes the efforts and time required to build data warehouse, normalization, schema writing, creation of cubes. And Empowers the customer to be independent of the vendor to create and use analytics

E

Technology

1

Supported database

Any OLEDB, ODBC complains which covers althea database in the world today + FLAT FILE, WEBFILE. TEXT FILE DELIMITED FILE. ALSO WORKS WITH SYBASE

Microsoft SQL Server

Y

Y

Oracle

Y

Y

Pervasive SQL

Y

Y

IBM DB2

Y

Y

Informix

Y

Y

Access

Y

Y

FoxPro

Y

Y

Progress

Y

Y

MySQL

Y

Y

2

Supported networks

Microsoft

Y

YES

Linux

Y

Y TO CONNECT TO THE DATABASE

Unix

Y

Y TO CONNECT TO THE DATABASE

AIX

Y

Y TO CONNECT TO THE DATABASE

Novell Netware

Y TO CONNECT TO THE DATABASE

IBM AS/400 (OS/400)

Y

Y TO CONNECT TO THE DATABASE

3

Development tools used to build application

NO THIRD PARTY DEVELOPMENT TOOL REQUIRED. THE CUSTOMER BECOMES VENDOR INDEPENDENT FOR ANY NEW APPLICATION/ CHANGES REQUIRED

4

Report writer used - which one(s)?

Crystal

NO THIRD PARTY TOOL REQUIRED

5

Data Extract Transform Load (ETL) tools - which one(s)?

All Major ETL Tools (bobj Data Integrator)

NOT REQUIRED: QLIK VIEW HAS ITS OWN ROBUST ETL INTEGRATED AS A QLIKVIEW SUITE. THE ETL IS WIZARD DRIVEN CAN BE LEARNT IN A FEW DAYS AND OPERATED BY CUSTOMER HENCE EMPOWER THEMSLEF TO CREAT OWN APPLICATION AS AND WHEN DEMAND ARISES

6

Cubes supported - which one(s)?

All Major OLAP

IN ADDITION TO ITS OWN DATA REPOSITORY QLIKVIEW SUPPORTS ALL MAJOR OLAP CUBES

7

Existing integration to accounting and ERP systems - which systems?

SAP, PeopleSoft, JDE, SSA Global/BAAN, Portal integration kits

ALL ODBC COMPLAINT DATABASE(all the current database in the market) IRRISPECTIVE OF THEIR FRONT END, SAP USING A SAP CERTIFIED CONNECTOR

8

Existing integration to customer relationship management systems - which systems?

Siebel

BY MEANS OF THE GLOBAL STANDARD ODBC, OLEDB CONNECTIONS (all major crm system)

9

Existing integration to payroll systems - which systems?

All Payroll systems on an ODBC data source.

BY MEANS OF THE WORLD STANDARD ODBC, OLEDB CONNECTIONS( all major payroll system)

10

Existing integration to HRMS systems - which systems?

All Payroll systems on an ODBC data source.

BY MEANS OF THE WORLD STANDARD ODBC, OLEDB CONNECTIONS (all major hr system)

F

Features

1

Analytic functionality

Yes

YES

2

Bubble up exceptions

Yes

This feature is better handled where the exceptions are managed at the lower level and not popped to the upper layer and confuses the user. However all precautions are taken to handle the exceptions efficiently.

3

Drill down

Yes

YES

4

Drill through to source data

Yes

DRILL DOWN TO THE TRANSACTIOANL LEVEL. AS AGAINST TO THE AGREGATED DATA IN CASE OF OLAP BASED APPLICATIONS

5

Ranking

Yes

YES

6

Sorting

Yes

YES

7

Restrict results by date range

Yes

YES

8

Includes dashboard

Yes

YES

9

Time trending (for example, over 12 months)

Yes

YES AS MANY YEARS AS THE DATABASE HOLDS

10

Pareto filtering (automatically groups the categories that amount to less than 20% of a row or column total into "other")

Yes

YES

11

Calculations

Yes

YES

12

Counts

Yes

YES

13

Percentage of total

Yes

YES

14

Allocations

Yes

YES

15

Total and Sub-total

Yes

YES

16

Create OLAP cubes

Yes

NOT REQUIRED

17

Data extraction and transformation tools

Yes

INTEGRATED

18

Incremental extraction

Yes

YES

19

Impact analysis - objects impacted by change

Yes

YES

20

Can schedule process to run overnight

Yes

YES

21

Formatting

Yes

YES

22

By dimension

Yes

YES: N DIMENTION

23

By level

Yes

YES

24

By cell

Yes

YES

25

Zero-row suppression

Yes

ZERO/NULL FIELD SUPPRESSION

26

Conditional formatting by cell, e.g., highlight cells below threshold

Yes

YES

27

Returns text (e.g., if value > 90, returns "excellent")

Yes

YES

28

French version

Yes

UNICODE: CAN BE IMPLEMENTED IN ANY LANGUAGE

29

Screens

Yes

YES

30

Reports

Yes

YES

31

Documentation

Yes

YES

32

Metadata

Yes

YES

33

OLAP functionality

Yes

NOT REQUIRED

34

Skip missing levels - support ragged dimensions

Yes

YES

35

Write back

Yes

NO

36

With audit trail

Yes

YES

37

Includes charting tools

Yes

YES

38

Access multiple cubes at a time

Yes

YES

39

Excel client

Yes

YES

40

Internet Explorer client

Yes

YES

41

Netscape client

Yes

Firefox

42

Geographical representation

Yes

YES

43

Drag and drop

Yes

YES

44

Attach notes to cube

Yes

CUBES NOT REQUIRED SAVES TIME AND MONEY

45

Attach notes to cells

Yes

CELLS NOT REQUIRED SAVES TIME AND MONEY

46

Password security

Yes

YES: UP TO THE FIELD LEVEL( BETTER THAN THE LISTING BELOW)

47

By company

Yes

YES

48

By department or division

Yes

YES

49

By menu

Yes

YES

50

By function (view, add, change, delete)

Yes

YES

51

By dimension

Yes

YES

52

By level

Yes

YES

53

By cell

Yes

YES

54

Respect active directory authentication

Yes

YES: CAN BE INTEGRATED WITH ACTIVE DIRETORY AUTHENTICATION FOR A SINGLE LOG ON PER USER

55

Respect database security

Yes

YES

56

Portal generation that includes HTML reports

Yes

YES

57

Report writer

Yes

NOT REQUIRED: INTEGRATED FEATURE

58

Web-based

Yes

YES

59

Generate cube

Yes

NOT REQUIRED: OVERCOMES CUBE DRAWBACKS

60

Drag and drop

Yes

YES

61

WYSIWYG report design

Yes

YES

62

Technology

Yes

YES (AQL)

63

API-enabled (SDK provided)

Yes

YES

64

Web-based (only need browser at client)

Yes

YES

65

For entire application

Yes

YES

66

Support for .NET web services

Yes

YES

67

Support for Java web services

Yes

YES

68

Transfer data to:

Yes

yes

69

Report writer

Yes

QLIKVIEW IS NOT A REPPORT WRITER HOW EVER IT SUPPORTS GENERTING REPORTS AND THIS FEATURE IS INTEGRATED PART OF QLIKVIEW.

70

Excel

Yes

YES

71

PivotTable

Yes

YES

72

HTML

Yes

YES

73

PDF

Yes

YES

74

PowerPoint

Yes

COPY PASTE (CTRL+C, CTRL+V)

75

XML

Yes

YES

76

Views

Yes

YES

77

Crosstabs

Yes

YES

78

Charts

Yes

YES

79

Both crosstabs and chart at the same time

Yes

YES

80

Work flow

Yes

Open to function with third party tools

81

Alerts can be automatically triggered

Yes

YES IN THE FORM OF POPUPS AND CAN BE USED TO AUTOMATE SENDING OF MAILS, ACTIVATE/RUN OTHER APPLICATIONS

82

Dynamically summarizing data without having to rebuild data?

ANALYSIS AT TRANSACTION LEVEL, WITH DRILL DOWN CAPABILITY FROM THE CONSOLIDATED ANALYSIS

83

Ability to pre-calculate results (aggregate) when they are available, or dynamically generating result from atomic information when necessary

YES

84

Ability to control and design cube aggregations

DOES NOT REQUIRE CUBES WHICH CAN HANDLE 3-10 DIMENTIONS ONLY. QLIKVIEW IS BASED ON AQL THAT CAN HANDLE AS MANY DIMENTIONS AS THE FILEDS AVAILABLE

85

Ability to monitor cube performance and tune the cube aggregations accordingly

DOES NOT REQUIRE CUBES WHICH CAN HANDLE 3-10 DIMENTIONS ONLY. QLIKVIEW IS BASED ON AQL THAT CAN HANDLE AS MANY DIMENTIONS AS THE FILEDS AVAILABLE

86

Can the cube be built using either of ROLAP, MOLAP, HOLAP techniques

DOES NOT REQUIRE CUBES WHICH CAN HANDLE 3-10 DIMENTIONS ONLY. QLIKVIEW IS BASED ON AQL THAT CAN HANDLE AS MANY DIMENTIONS AS THE FILEDS AVAILABLE

87

A hybrid database that stores data in relational form and multidimensional form, as appropriate

QLIKVIEW DOES NOT NEED THIRD PARY DATABASE.

88

Is 'What-if" analysis supported

YES

89

GUI based Data Mining Capabilities

YES

90

Enterprise Platform

YES

Statistical Analytical Modeling

YES

91

Statistics

YES

92

Data & Text Mining

YES

93

Model Management & Deployment

94

Forecasting

YES

95

Econometrics

YES

96

Quality Improvement

97

Operations Research

98

Data Quality

AQL TAKES BUSINESS INTELEGENCE ONE STEP FURTHER THAN THE TREDITIONAL DATA WAREHOUSE ARCHITECHTURE - OLAP BASED SOLUTIONS

Initial implementation time

1/10 time than Cognos and BO

Initial implementation cost

1/6 time to implement than Cognos or BO

Time to proficiency

Only five day Application development training required. Time to become proficient is in days not in month that is 1/6 than Cognos and BI

Project Success rate

98 % in Comparison to 38 % in OLAP based BI Software.

TCO

1/2 than any BI tool

Value

Twice than Cognos and BO

41 comments:

  1. We are replacing our entire BO/CE reporting architecture with Qlikview. We are able to do things with Qlikview that BO/CE or SSRS could not do.

    ReplyDelete
  2. Ron I apreciate if you could share some more knowledge about your company and business as well as what are the problems you were facing with BO/CE or SSRS that led you to use QlikView

    ReplyDelete
  3. Mid-sized Healthcare organization. BO/CE licensing was getting too expensive to support large numner of users. We had to keep buying more hardware & licenses to handle both data growth and end user growth. Experiencing long wait times at month-end for financial processing. We have a lot of OLAP from SSAS, but we were out growing it. The end users had a need to get from the high-level to the transacion level quickly, in the same application. BO/CE does not do this well.

    ReplyDelete
  4. The licensing cost for Qlikview is fractions of BO/CE just as you listed above. The implementation is also very quick relative to the others too. The vendor has been honest and great to work with. Everything they have stated has turned out to be true--both the good & the bad. Unfortunately that is not always the case in the vendor community. I am a very large BO/CE implementation and I have not heard from a rep in almost 1-year. Not even sure who it is right now--not much of a partnership.

    ReplyDelete
  5. Thanks Ron for sharing your experience with me and my readers.

    ReplyDelete
  6. How can you possibly compare vendors on implentations costs, timeframes, proficiencies, successes, TCO's, values, etc's - without a ton of caveats.....yet, you are! That just makes everything else you say suspect. You need to keep the features and functions of the actual products you are comparing separate from business value for specific sales opportunity.

    Additionally, Business Objects/SAP has many products/features that QlickView can't even begin to compete with.

    If QlikView can't scale to meet the need of an organization's data crunching requirement, then it's value is SQUAT! You aren't helping your cause much....which is too bad, b/c it's not a bad product.

    ReplyDelete
  7. Hii Freinds One of my reader how is working on BO has written an email to me and I can resist my self to share with you.
    "
    On Wed, Jun 24, 2009 at 4:36 PM, prabhu reddy allaytech@gmail.com wrote:

    "m learning Qlikview, it has very excellent comparing othert BI tools . I m certified business objects consultant, i seen your comparison charts , it was really good .

    Need to learn in-depth qlikview, i search materials for qlikview, but i m not getting anything , if you dond mind , can u share some materials (is possible )
    "

    thanks

    Regards

    Prabhu

    ReplyDelete
  8. Dear Parbhu,
    Learning QlikView is very easy once you install QlikView it copies some reference manual in your disk. Look at program file where you have installed QlikView and search for reference manual. Otherwise you can sign up for an online training course on QlikCommunity. Link to QlikCommunity that is available at www.qlikView.com

    Regards
    Sudhir

    ReplyDelete
  9. I could resist from commenting on the post. The manner in which the entire report/blog has been submitted suggest that Enterprise BI product are worthless products and Qlikview does what they cannot do. I have a couple of simple questions to the author.

    Why do you need cube? the entire solution can be implemented in Cube + Database level. Giving the user the capability to go at any level.

    The reports in memory are faster. point accepted but what about the hardware cost...... Plus logically speaking you don't need every report to run every second.

    This is only one sentence i am quoting, I can go on and on and on about these. You say "YES IN THE FORM OF POPUPS AND CAN BE USED TO AUTOMATE SENDING OF MAILS, ACTIVATE/RUN OTHER APPLICATIONS". Who says that is not possible in other enterprise products. In fact you might have missed reading datasheets but everybody clearly states about events and alerts.

    I appreciate your post and time/effort you have put in to posting it. But then it doesn't serve the real purpose "This blog will help you to understand what is the solution for your ad hock reporting needs that you need to serve your management"......

    ReplyDelete
  10. Hii Anonymous,


    I would sugest you to read two more posts at link bellow. http://qlikviewvsolap.blogspot.com/2009/08/reasons-why-69-cube-based-bi-project.html

    and
    http://qlikviewvsolap.blogspot.com/2008/12/why-qlikview.html

    ReplyDelete
  11. I'm currently trying to compare QV and BO and I found your post.
    Great job, unfortunalty in my opinion your point of view is not objective, am I right?
    Could you also tell me where the data in a green background are coming from?

    ReplyDelete
  12. Blogs are so informative where we get lots of information on any topic. Nice job keep it up!!
    _____________________________

    MSC Dissertation

    ReplyDelete
  13. Thanks marry..I will try to put some more information in n ext post

    ReplyDelete
  14. Is this a marketing arm for Qlikview? So biased to Qlikview. What a "CHEAP" marketing!!!

    ReplyDelete
  15. This DOES appear to be a Marketing arm for qlikview... submitting a Google search for the following ("Sudhir Kumar Singh" qlikview) resulted in... Sudhir Kumar Singh - LinkedIn
    Sudhir Kumar Singh. Manager - Business Development for QlikView- World's fastest growing Business Intelligence Software. Delhi Area, India ... etc.

    ReplyDelete
  16. OOpps what a discovery of Anonymous Joker.Look at bottom of this page "Know the Blogger" section. It is mentioned their that he is a BDM.

    Insted making you fingers dirty on someones;s good effort better you comeup with comparision. Dont lay sily.. Show your guts to revel your name and profile also while putting comments..

    ReplyDelete
  17. To last "Anonymous" entry, you type as if you had guts. What kind of comment is "Dont lay sily.. Show your guts to revel your name and profile also while putting comments.." when you also hide behind this name?

    ReplyDelete
  18. Utterly disgusting blogs like this one plague the IT industry. What a jerk !

    ReplyDelete
  19. Fake flag bearers of IT industry like you... Who dont have even a single work to help end users just point fingures to someone's effort...

    ReplyDelete
  20. Definetly a tendencious analysis.

    ReplyDelete
  21. your providing such a valuable information about studying..and also have some good key points to every student.

    IBM MQ online training

    ReplyDelete
  22. Credibility of this blog should be checked by Oprah.

    ReplyDelete
  23. Wonderful blog! I found it while searching on Yahoo News.

    Do you have any tips on how to get listed in Yahoo News? I've been trying for a while but I never seem to get there! Many thanks

    My website http://doctorgolf.org/

    ReplyDelete
  24. I used to be able to find good info from your blog posts.


    Also visit my website :: car rentals Johannesburg exclusive holidays South Africa

    ReplyDelete
  25. No matter if some one searches for his vital thing, therefore he/she desires to be
    available that in detail, therefore that thing is
    maintained over here.

    my site :: office furniture Cape Town

    ReplyDelete
  26. I'm really enjoying the design and layout of your site. It's a very easy on the eyes which makes it much more
    enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme?
    Excellent work!

    My homepage: building renovations Johannesburg architectural services Johannesburg

    ReplyDelete
  27. Hi there! I know this is kinda off topic nevertheless I'd figured I'd ask.
    Would you be interested in exchanging links or maybe guest authoring a blog post or vice-versa?
    My blog covers a lot of the same subjects as yours
    and I believe we could greatly benefit from each other. If you happen to be
    interested feel free to shoot me an e-mail. I look forward
    to hearing from you! Wonderful blog by the way!

    my website ... pc repairs Johannesburg

    ReplyDelete
  28. Touche. Great arguments. Keep up the great effort.



    my website :: web site designer

    ReplyDelete
  29. You actually make it seem really easy along with your presentation however I in finding this matter
    to be really something which I think I'd by no means understand. It seems too complicated and very wide for me. I'm taking a look
    forward in your subsequent submit, I will try
    to get the grasp of it!

    my web page: first aid kits Johannesburg

    ReplyDelete
  30. When someone writes an paragraph he/she retains the image of
    a user in his/her brain that how a user can be aware of it.

    So that's why this post is outstdanding. Thanks!

    Here is my webpage :: illustration Johannesburg

    ReplyDelete
  31. Looking at your Comparision, I see the point no 35, you have mentioned BO has the Write-Back capability, where it's not at all there..

    ReplyDelete
  32. I really like what you guys are usually up too. Such clever
    work and coverage! Keep up the good works guys I've included you guys to our blogroll.

    Also visit my blog click this site

    ReplyDelete
  33. This site was... how do you say it? Relevant!
    ! Finally I've found something that helped me. Thank you!

    My web site; visit this site

    ReplyDelete
  34. My spouse and I stumbled over here different website and thought I may as well check things out.
    I like what I see so now i'm following you. Look forward to checking out your web page yet again.

    Also visit my web-site: click This Site

    ReplyDelete
  35. Hey there would you mind stating which blog platform you're using? I'm looking to
    start my own blog in the near future but I'm having a difficult time deciding between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking
    for something completely unique.
    P.S Apologies for being off-topic but I had
    to ask!

    Also visit my website; Click here

    ReplyDelete
  36. Hi there Dear, are you genuinely visiting this web site regularly, if so then you will without doubt obtain fastidious experience.


    Take a look at my web-site; more info

    ReplyDelete
  37. Heya! I know this is sort of off-topic however I
    had to ask. Does building a well-established blog like yours require a massive amount work?
    I am completely new to writing a blog but I do write in
    my diary on a daily basis. I'd like to start a blog so I can easily share my experience and feelings online. Please let me know if you have any ideas or tips for new aspiring bloggers. Appreciate it!

    My blog post: pozyczka pozabankowa pod zastaw mieszkania

    ReplyDelete
  38. Levitt funded the 2007 renovation effort of the Overton
    Park Shell that preceded its re-opening in fall of last year as the Levitt Shell
    is the complete opposite. My personal opinion is that you do not pay
    attention which could be a problem for small children.
    Wicked Tour Tickets opened on Broadway in 2003 and since then has opened
    productions in Chicago, Los Angeles, Japan and London.
    The Commercial Appeal reported that the show's judges at the Orpheum Theatre1192 Market St.

    Feel free to surf to my page - wicked tickets discount codes

    ReplyDelete
  39. This is one sided review. :-(

    QlikView is really very good but this comparison sounds like there is nothing like this. This tool too have limitations.

    Rav

    ReplyDelete
  40. the comparison and the point mentioned here are really good... qlikview is really good tool.
    i have found some interesting points here -

    https://sites.google.com/site/businessobjectsondemand/home/comparison-business-objects-vs-qlikview

    ReplyDelete

Search more on BI on Web

Know the Blogger