Introduction to Qlikview

What is Qlikview?

Qlikview is a business intelligence reporting tool which is currently new in the market. It is simple software which is used for visually analyzing the relationship between data. It was founded by QlikTech which is a Radnor (Pennsylvania) based software company founded in 1993. The first version of Qlikview was released on 2005 which as Qlikview 7.0

Qlikview has more than 15,000 customers in 100 countries. They have more than 650 employees across 22 offices in 24 countries.

Why Qlikview?

• Create a flexible end user interface to an information ware house
• Get snapshots of data relations
• Make presentation based on your data
• Create dynamic graphical charts and tables
• Perform statistical analysis
• Link descriptions and multimedia to your data
• Build your own expert systems
• Create new tables, merging information from several sources
• Build your own business intelligence system

What are the silent features of Qlikview?

• Data association is maintained automatically
• Data is held in memory
• Direct and Indirect searches can be done
• Data is compressed to 10% of its original size
• Visual relationship using colors

Architecture of Qlikview

Qlikview is patented technology, so we need to understand how QlikView works. Qlikview architecture consists two parts:

•               Front End
•        Back End

Front End:

The Front End is where end user interact with the QlikView documents and data. It contains the Qlikview Server which is used by developers and business users to access the BI reports. The user documents seen on front End are QVW, .meta and .shared documents which is also be stored in the windows OS as a standalone document. All the communication between Client server and user is handled either HTTP or via Qlikview server. In front End Qlikview server is responsible for client security. 

Back End (Including Infrastructure Resources)

In Back End all QlikView source documents is created by Qlikview developer. These sources files contains scripts within QVW files through which we can load data from different sources such as Data warehouses, Excel, SAP, Salesforces.com etc. Qlikview backend consists of two parts:

•           Qlikview Desktop
•          Qlikview publisher

 Qlikview Desktop

Qlikview Desktop is a windows-based desktop tools that is used by Analyst, Developers to extract and transform data from different sources. The files created by Qlikview desktop are stored with an extension .qvw and these files are passed on to the Qlikview server. These files are also used to create graphical user interface. 

 Qlikview Publisher (QVS)

Qlikview publisher is used to distribute the Qlikview file(.qvw) to the Qlikview servers and users.It also does the direct  loading of data from different data sources (oledb/odbc, xml, xls) reduces the QlikView application and distributes to a QVS.

Qlikview uses an associative in memory technology that provides facility to users to analyze and process data very quickly. It stored the unique entries once in memory and then everything else are pointers to the parent data.

At the beginning when we load data into QlikView, Qlikview will load a Qlikview document from hard disk and then place the entire dataset into RAM. That’s why Main memory is the primary storage location for all data to be analyzed by QlikView. 

How to Get Qlikview ?

Qlikview can be easily downloaded from here Download Qlikview

You just need to fill the form and submit the application. Afer that you need yo accept the aggrement and click on Download button. Qlikview personal edition is automatically downloaded and then ou need to perform some simple steps to install this software in windows.