Qlik Sense

from Wikipedia, the free encyclopedia
This article or the following section is not adequately provided with supporting documents ( e.g. individual evidence ). Information without sufficient evidence could be removed soon. Please help Wikipedia by researching the information and including good evidence.
Qlik Sense
Basic data

developer QlikTech
Publishing year 2014
Current  version February 2019 Patch 1
(03/27/2019)
operating system Microsoft Windows, web-based
programming language HTML, JavaScript
category Business intelligence software
License Free full version for private users, proprietary license for business users
https://www.qlik.com

In addition to QlikView , Qlik Sense is one of the main products of QlikTech (often Qlik for short ) and belongs to the category of business intelligence tools.

Functions

As a web-based dashboarding tool , it offers the option of creating analysis dashboards . As pre-systems and data sources, a. Classic ERP systems such as SAP R / 3 and SAP BW, relational databases , text and Excel files and web services can be used and linked with corresponding visualizations. This should enable key figures and process visualizations independent of the previous system.

A free full version is available for download under the name Qlik Sense Personal Edition by QlikTech on the company website.

The current version is the February 2019 release.

Technology and differentiation from other tools

Qlik Sense works with an in-memory technology in which all data and calculations are stored and carried out directly in the main memory.

With the April 2018 release, the Cognitive Engine became available, a machine learning- based concept that suggests visualizations and key figures to the user based on the background data.

The associative model vs. The hierarchical model

The associative data model forms the basis of all analyzes. In practice, this means for the user that analyzes do not have to follow a given direction.

Schematic representations of different data models. The nodes of the graph represent the internal tables of the data model and the edges between the nodes represent the connections between key fields of the respective tables. Left : The associative model. Connections between data sources are not directed and can be established from any node via the respective edges to another node. Right : the hierarchical model. Subnodes can only be reached from the root node above. Connections from one subnode to another subnode of the same hierarchical level are not possible

A typical sales analysis path can be mapped in the hierarchical model as follows:

Continent → Country → City → Branch → Employees → Product group → Sales of the employee per product group

The analysis path ends here. By selecting a specific employee, it is impossible for another employee to compare a specific product group with this same product group. The hierarchical path must be traversed again up to the node of the employee and selected for another employee.

An analysis path in the associative model can be mapped as follows.

Continent ↔ country ↔ city ↔ branch ↔ employee 1 ↔ product group 1 ↔ sales employee 1 per product group 1

↑ ↓ ↑ ↓

Employee 2 ↔ product group 1 ↔ sales employee 2 per product group 1

The analysis path does not end after receipt of the sales of employee 1 , since a backward association via the node of the employees to the sales of employee 2 still exists.

A simple use case would be:

The sales of all product categories under one employee meet a certain target value and should be defined as a reference value for all employees. In the hierarchical model, all m product categories would now have to be run through for all n employees in order to compare the corresponding sales revenues with the reference value. In the associative model, all sales of an employee per product category are indirectly linked to all other employee nodes, which in turn are linked to the corresponding sales revenues. This means that only 1 analysis run is necessary to map all sales.

Web links

Individual evidence

  1. ^ The underlying technology of QlikView | DBMS 2: DataBase Management System Services. Retrieved September 13, 2018 .
  2. ↑ What's new in Qlik Sense April 2018? - Qlik Sense. Retrieved September 13, 2018 .