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