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