Friday, January 23, 2009

QlikView Vs Panorama

Dear Readers,

This comparison will help you to understand QlikView against Panorama But I suggest before looking at any comparison please read why QlikView that is my first blog and you can find a link for it in labels or search it in archives.

I also wanted to share that after publishing comparison with cognos I got some resistance from some of my readers I welcome those critics but with sugestion as these posts are my own view and is correct up to my knowledege. If any of my reader is finding any mistake or have any suggestion I welcome all suggestion and critics. By doing this you can help others to evaluate and to get Good BI software. I am working for a comparison with BO and SAS also that will be published soon.

Happy reading.


#

Product

Panorama

Qlik View

A

Product

1

Product

Panorama

QlikView: Worlds Fastest Growing BI tool. With 10.3 customers being added every working day.

2

Vendor

Panorama Software

QlikTech

3

Version

4.5

8.5

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

B

Profile and Contact

1

World head office

International and U.S. Headquarters , Radnor, PA

2

Canadian head office

Toronto

International and U.S. Headquarters , Radnor, PA Research and Development, Lund, Sweden Scandinavian Headquarters, Lund, Sweden German Headquarters, Düsseldorf, Germany United Kingdom Headquarters, Lemington Spa, England

3

Website

www.panorama.com

www.qlikview.com

4

Branchs and Technical Support in India with Contact Person


IRT Computer Solutions (I) Pvt. Ltd. Reg. office: Cunningham Road, Bangalore Branches: Mumbai, Delhi. Conact: Annappa. HP: 9342250846

C

Applications

1

Business intelligence

Yes

Qlikview is a single integrted tool for ETL, DW, Multi Dmentional Analysis, Dashboarding, 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

Third Party

5

Forecasting

Third Party

6

Consolidation

Third Party

7

Scorecarding

Yes

D

Hardware and Licenses

1

Warehousing is (Mandate/ Optional)

Mandate

NOT REQUIRED, One of the the major advantage of usinq Qlikview is, it does not require database which saves money and very wel skilled human resource. With no datawarehouse required Qlikview can be impleted in a couple of weeks saving a lot of TIME, MONEY AND RESOURCES.

2

Server Licenses(Named/CPU)

Named

Named

3

User Licenses (Name/Concorent/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 Extarct 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 datawarehouse, normalization, schema writing, creation of cubes. And Empowers the customer to be independent of the vendor to creat and use analyitcs

E

Technology

1

Supported database

Any OLEDB, ODBC complaing which covers althe datbase 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

IBM DB2

Y

Y

Informix

Y

Access

Y

Y

FoxPro

Y

Progress

Y

Y

MySQL

Y

Y

2

Supported networks

Microsoft

Y

YES

Linux

Y TO CONNECT TO THE DATABASE

Unix

Y TO CONNECT TO THE DATABASE

AIX

Y TO CONNECT TO THE DATABASE

Novell Netware

Y TO CONNECT TO THE DATABASE

IBM AS/400 (OS/400)

Y TO CONNECT TO THE DATABASE

3

Development tools used to build application

Panorama is coded in C++, Java, and Visual Basic. Solutions on Panorama are built using ASP.NET, Javascript/DHTML

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

4

Report writer used - which one(s)?

Microsoft Reporting Services

NO THIRD PARTY TOOL REQUIRED

5

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

Microsoft Data Transformation Services

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)?

Microsoft Analysis Services

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

7

Existing integration to accounting and ERP systems - which systems?

Custom integration with most ERP solutions, including Microsoft Great Plains, SAP Business One

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?

Custom integration with most CRM solutions, including Microsoft CRM, Pivotal, Siebel

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

9

Existing integration to payroll systems - which systems?

Custom integration with most payroll solutions

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

10

Existing integration to HRMS systems - which systems?

Custom integration with most human resources solutions

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 handeled where the exceptions are managed at the lower level and not poped to the upper layer and confuse the user. However all precautions are taken to handle the exceptions eficiently.

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")

Customization

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

Third Party

NOT REQUIRED

17

Data extraction and transformation tools

Third Party

INTEGRATED

18

Incremental extraction

Third Party

YES

19

Impact analysis - objects impacted by change

Third Party

YES

20

Can schedule process to run overnight

Third Party

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

Future Date

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

Third Party

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

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

YES

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


38 comments:

  1. Hi Sudhir,
    Its really intresting. But want to know have you worked on Panorama or any other tools you have compared with Qlikview or ever somebody from the Other BI vendors organization validated and confirmed it is correct?

    ReplyDelete
  2. Hi ,

    Adding to above point you have mentioned there is You have mentioned Report Writer twice and there are two different answers and which one is correct?
    Also you have mentioned some of the features in Red which is specific to Qlikview. There are few features which are specific to other products and not in Qlikview why it has not been differentiated in that way.
    Now qlikview supports extensions,fusion charts all are third party products, If you want to work with Workbench or any customization in qlikview then you should be good at Microsoft techologies.Qlikview is Good in terms certain features but not all. I have been using Qlikview from 8.5 version.

    ReplyDelete
  3. Hey just wanted tο givе you a quick heads uρ.
    The text in your content seеm to be running off the ѕcreen in Ie.

    I'm not sure if this is a formatting issue or something to do with web browser compatibility but I thought I'd poѕt to let you
    know. Τhe laуоut loοk great though!
    Hοpe уou gеt the issuе resolved sοοn.
    Chеers

    http://www.allgirlаrmy.org/user/40459/contact
    Also see my website: used bucket truck

    ReplyDelete
  4. Just desire to say your article is as astounding.
    The clearness in your post is just spectacular and i could assume you're an expert on this subject. Well with your permission let me to grab your feed to keep up to date with forthcoming post. Thanks a million and please keep up the gratifying work.
    Review my homepage - clip Latina porn video

    ReplyDelete
  5. Hello, i think that i saw you visited my website thus i came to “return
    the favor”.I am trying to find things to enhance my website!
    I suppose its ok to use a few of your ideas!!
    Visit my site - Horny Chick Masturbates

    ReplyDelete
  6. Hi there, i read your blog occasionally and i own a similar one and i was just curious if you get a lot of
    spam responses? If so how do you protect against it,
    any plugin or anything you can suggest? I get so much lately it's driving me insane so any support is very much appreciated.
    Here is my web blog - click the next document

    ReplyDelete
  7. You actually make it appear really easy together with your presentation but I in finding this matter to be really something that I believe I might by no means understand.
    It seems too complicated and very wide for me. I am taking a look forward for your subsequent publish, I will try to get the
    grasp of it!
    Also visit my homepage :: click through the next web page

    ReplyDelete
  8. Heya! I realize this is kind of off-topic however I had to ask.
    Does managing a well-established blog like yours
    take a large amount of work? I am completely new to operating a blog
    but I do write in my diary on a daily basis.

    I'd like to start a blog so I can share my experience and thoughts online. Please let me know if you have any recommendations or tips for new aspiring bloggers. Appreciate it!
    Here is my homepage ; Gianna Is A Black Cock Freak

    ReplyDelete
  9. Heya! I realize this is kind of off-topic however I had to ask.
    Does managing a well-established blog like yours take a large amount of work?
    I am completely new to operating a blog but I do write in my diary on
    a daily basis. I'd like to start a blog so I can share my experience and thoughts online. Please let me know if you have any recommendations or tips for new aspiring bloggers. Appreciate it!
    Also see my website :: Gianna Is A Black Cock Freak

    ReplyDelete
  10. Pretty! This has been an incredibly wonderful article.
    Many thanks for providing these details.
    Also see my webpage - Daily XXX Video Fix of teen porn with naked girls sex movies

    ReplyDelete
  11. We absolutely love your blog and find nearly all of your post's to be precisely what I'm looking for.
    Would you offer guest writers to write content in your case?
    I wouldn't mind publishing a post or elaborating on many of the subjects you write related to here. Again, awesome blog!
    Have a look at my site - free teen porn

    ReplyDelete
  12. Highly energetic article, I enjoyed that a lot.
    Will there be a part 2?
    Look at my homepage ; lia 19

    ReplyDelete
  13. Its not my first time to visit this website, i am visiting this website dailly and get good information from here all the time.
    My page > crazyteenpics.com

    ReplyDelete
  14. Today, I went to the beachfront with my kids.
    I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She put the shell
    to her ear and screamed. There was a hermit crab
    inside and it pinched her ear. She never wants to
    go back! LoL I know this is totally off topic but I had to tell someone!
    My weblog ... Take a look at my roommate

    ReplyDelete
  15. I have read some just right stuff here. Definitely value bookmarking for revisiting.
    I surprise how so much attempt you set to make one of these
    excellent informative site.
    Also visit my web blog ; contractor in Orlando fl

    ReplyDelete
  16. Υour style is νеry unique іn
    cοmparison to other people I have reаd stuff from.

    Thanks for posting when yоu've got the opportunity, Guess I will just bookmark this web site.

    http://subeiwkn.multiply.com/journal/item/73/Shopping_forquality_used_bucket_trucks_for_sale
    Look into my web blog ; used trucks for sale

    ReplyDelete
  17. Yοur style is ѵerу unique in comparison to otheг people I have reаd stuff from.
    Τhаnkѕ for posting whеn уou've got the opportunity, Guess I will just bookmark this web site.

    http://subeiwkn.multiply.com/journal/item/73/Shopping_forquality_used_bucket_trucks_for_sale
    Also see my website :: used trucks for sale

    ReplyDelete
  18. Hi there! This post couldn't be written any better! Reading this post reminds me of my good old room mate! He always kept talking about this. I will forward this page to him. Pretty sure he will have a good read. Many thanks for sharing!
    My site: design

    ReplyDelete
  19. Hello There. I found your blog using msn. That is a really well
    written article. I will make sure to bookmark
    it and return to read extra of your useful information.
    Thank you for the post. I'll definitely return.
    My site - organic

    ReplyDelete
  20. Υou have madе somе dеcent points there.

    I сhecked on the internet fοr аdditional informаtion about the issue and found mοst реoрle will go along with your viеws
    on this site.

    My websіte :: smoker recipes
    Also visit my web-site - big green egg digiq bbq guru review

    ReplyDelete
  21. I think the admin of this web page is really
    working hard in support of his site, because here every material is quality based information.
    Stop by my weblog home renovation orlando florida

    ReplyDelete
  22. excellent publish, very informative. I'm wondering why the opposite experts of this sector do not notice this. You should proceed your writing. I'm confident, you have
    a huge readers' base already!
    Here is my web site ; opinie o penilarge

    ReplyDelete
  23. Hello! I just wanted to ask if you ever have any issues with hackers?
    My last blog (wordpress) was hacked and I ended up losing
    several weeks of hard work due to no back up. Do you have
    any methods to prevent hackers?
    My blog post - mma fighters

    ReplyDelete
  24. Wow that was strange. I just wrote an very long comment but after I clicked submit my comment didn't appear. Grrrr... well I'm not writing all that over again.
    Anyways, just wanted to say excellent blog!
    Stop by my homepage ... Visit Website

    ReplyDelete
  25. Goоԁ ωeb sitе yоu've got here.. It's hard tο fіnԁ
    excellent wrіtіng like уours nowadaуѕ.
    I honestly apрreciate people like уou!
    Take сare!!

    Feel free to suгf to mу blοg ρost
    - bucket trucks

    ReplyDelete
  26. Wow, this post is fastidious, my sister is analyzing ѕuch things,
    so I am going to cοnvey her.

    Lοοk at my webраge - bucket Truck
    My site > used bucket trucks for sale

    ReplyDelete
  27. Right here is the right site for anyone who really wants to understand this topic.
    You realize a whole lot its almost tough to argue with you (not that I personally would want to…HaHa).

    You certainly put a fresh spin on a subject that has been discussed for many years.
    Wonderful stuff, just wonderful!

    My web page; 411 pain Florida truth network

    ReplyDelete
  28. I am no longer sure where you are getting your information, but
    great topic. I needs to spend a while studying much more or working out more.
    Thanks for magnificent info I was searching for this information for my mission.


    Feel free to surf to my site: Shabby Chic Moebel Karlsruhe
    Also see my webpage > Shabby Chic Moebel Karlsruhe,Vintage Moebel Karlsruhe,Villa Schoensinn Karlsruhe

    ReplyDelete
  29. I visited various ѕitеs hοωеver the аudiο qualіty fοr auԁio sοngs сurгеnt at this ωеb pаge is
    аctuаlly supeгb.

    Feel freе to visit my blοg :: tens machine

    ReplyDelete
  30. I couldn't refrain from commenting. Very well written!

    Here is my webpage; Best Baby Monitors

    ReplyDelete
  31. I like the valuable info you provide in your articles.
    I will bookmark your blog and check again here frequently.

    I'm quite sure I will learn many new stuff right here! Good luck for the next!

    My webpage - Quick Links

    ReplyDelete
  32. If you want to get a great deаl from this aгticle then уou have to apply these strategiеs
    to your ωon webpage.

    My website ... Www.makemoneybuynsellcars.biz

    ReplyDelete
  33. Ηi to every ѕingle one, it's in fact a pleasant for me to pay a quick visit this website, it contains precious Information.

    My website ... how to flip cars for profit

    ReplyDelete
  34. I'm not sure why but this web site is loading extremely slow for me. Is anyone else having this issue or is it a problem on my end? I'll check
    baсk later and ѕee іf the ρroblem still exists.



    Here іs my wеb-site dallas seo company 1

    ReplyDelete
  35. Link exchange is nothing else however it is only placing
    the other person's weblog link on your page at appropriate place and other person will also do similar in support of you.

    Also visit my web blog: common side effects of Lioseral

    ReplyDelete
  36. you're actually a good webmaster. The site loading pace is amazing. It seems that you're doing
    any distinctive trick. In addition, The contents are masterwork.
    you have done a wonderful job in this subject!


    Visit my web site - www.cuteteenporn.net

    ReplyDelete
  37. Hi friends, how is everything, and what you desire to say on the
    topic of this post, in my view its actually awesome in support of me.


    my web site; hot sex tube

    ReplyDelete
  38. Once a shared data architecture is in place, impact analysis must be performed, breaking the Agile methodology. Basically all Agile brings to the table is improved UX (User Experience), since presentation layers are the only thing that can quickly be modified without extensive impact analysis.thank you very much for this kind of site. i want more info as i want loan for my business.thanks.qlikview training in hyderabad

    ReplyDelete

Search more on BI on Web

Know the Blogger