Qlikview Tutorial for Beginners

Facebooktwitterredditpinterestlinkedinmailby feather

Introduction to QlikView

QlikView is a popular business discovery platform. It is one of the powerful software for visually analyzing the relationships between data. Data can be read from various sources like files and relational databases. It uses data integration on one QlikView analysis document by combining data from different sources.

As compared to the traditional BI platforms, QlikView is very unique. It is a data analysis tool which maintains the relationship between the data and the relationship can be seen using colors. The data which are not related can also be seen. List boxes can be used for direct and indirect searching.

In-memory data processing is the main feature of QlikView, as it gives the superfast result to the users. The calculation is done by reducing data size to 10% from the original size. Users and developers cannot manage the relationship between data of QlikView applications. All the management is done automatically.

History of QlikView

Originally Qlik was known as QlikTech. In 1993, at Lund, Sweden, it was founded as a software company in business intelligence. The PC-based desktop tool was called QuikView.

Quik stands for “Quality, Understanding, Interaction, and Knowledge”.

Initially, this software was sold only in Sweden. First institutional investors were Swedish VC Industrifonden who join the company in 1993.

In 1999, there were only 35 employees.

In 2000 Hultman become CEO and Björk became CFO.

In 2003 there were about 70 employees. The company focuses on the area of Business Intelligence.

In 2005, the single-user desktop tool was replaced with a server-based web tool.

In 2007,Björk became CEO.

In 2011 the company had a market capitalization over $2 billion.

In 2013, the company opened an office in Western Australia.

In 2015, the company opened an office in Ottawa, Ontario to expand its R&D operations.

In 2018, Qlikwas used by the British police to “predict crime”.

Architecture of QlikView

The architecture of QlikView consists of a front end and back end. The front end is used for visualizing the processed data and the back end is used to provide security.

Front End

It is used for viewing all the QlikView documents. It has a QlikView server for accessing BI reports which are used by Business users.

Using front end, business users interact with data and make a conclusion about the data. The file extension for user documents is .qvw. It can be stored as a standalone document in windows OS.

The QlikView server in the front end manages communication between the user and the QlikView backend system.

Back End

It consists of QlikView desktop and QlikView publisher.

The QlikView desktop is a Windows environment. It is used for loading and transformation of data from the source. GUI layout can be created using drag and drop feature.

.qvw extension is used for storing files in QlikView desktop. These files are passed in the front end. .qvw files can be modified, which store data-in files known as .qvd files. .qvd files are binary files which only contain data not the GUI component.

The QlikView publisher provides distribution service, which distributes the .qvw documents in QlikView servers and users. It has all the authorization and access privileges. Using the connection strings which is defined in the .qvw files, it can directly load data from the data sources.

Difference between QlikView and Tableau

Comparison criteria QlikView Tableau
Implementation time Very Fast Fast
Scalability Limited by RAM Good
Support for Big Data Good Very Good
Visual Drilldown Excellent Good

Features of QlikView

  1. Data Association is maintained automatically

QlikView can easily recognize the relationship of each data which is present in the dataset.

  1. Data is held in memory for multiple users, for a super-fast user experience

The structure, data and calculations of a report are all done in the memory (RAM) of the server.

  1. Aggregations are calculated on the fly as needed

As the data is in memory, calculations are done on the fly. There is No need for storing pre-calculated values.

  1. Data is compressed to 10% of its original size

Essential bits of data in memory are required for any analysis. That is why it compresses the original data to a very small size.

  1. Can do Direct and Indirect searches

Advantages of QlikView

  1. Dynamic BI Ecosystem

It provides a dynamic Business Intelligence ecosystem for the user.

  1. Data Interpretation & Analysis

Its visual and dynamic applications help in quick data interpretation and analysis.

  1. Data Sharing

Data can be shared between Business users for analyzing.

  1. Self-Service Tool

QlikView is a self-service BI tool.

  1. Low Maintenance

The software doesn’t need much maintenance or technical supervision.

  1. Speed

QlikView speed in data delivery is not slow even if multiple user requesting data.

  1. QIX Engine

The QIX engine of Qlikview instantly responds to every click made by the user and changes colour.

  1. Cheap Cost

QlikView is very cost effective.

Disadvantage of QlikView

  1. Real-time Data Analysis

It proves to be time wasting many times.

  1. Less Ram Limit

QlikView can load heavy data but the RAM of a computer has a limit to it.

  1. Difficult Application Development

The end user application development is difficult because it demands technical expertise.

  1. Embedding

Embedding Qlikview with other software difficult as it has a very distinct appearance.

  1. Poor and unsatisfactory customer support
  2. Work on Old Functions

QlikView has become old in the sense of the tools and interfaces it offers to the customers.

Reference:
https://data-flair.training/blogs/qlikview-tutorial/

Facebooktwitterredditpinterestlinkedinmailby feather