Qlik Sense is a “Data Visualization Tool” which has gained a lot of popularity in “Business Intelligence” Industry because of the available features, architecture, key capabilities, products, customer services and user-friendly approach (The operations could be performed easily and effectively using “Drag and Drop” approach). Before discussing Qlik Sense Data Model, just know What is Qlik Sense & its Applications.
This tool operates with the help of the QIX engine which allows users to link and associate data from varied data sources to carry out the selection and searching. The quality of the developed graph is better compared to other “data visualization tool”. In this article, we discuss how you can create the Qlik Sense Data Model with 4 easy steps.
The additional features of Qlik Sense are as follows:
- Qlik Sense provides Interactive Analysis of the associated data in it
- This tool even supports Interactive Sharing and Collaboration with other data
- The data associated with a tool is Safe because of the advanced security features
- The input data can even be shared with multiple devices by building connections
- It provides Augmented Visualization and smart search/explorations
Must Check: Ultimate Guide of Qlik Sense Operators
Creating Associations in Qlik Sense
The QIX Engine of Qlik Sense helps in analyzing and discovering data easily and effectively. It helps to develop an association between data tables. It helps to link various data fields with data values to develop a logical connection. We can do linking as per our choice and requirements.
The developed associated selected model helps to create an interactive graph for better data analysis.
There should be one or two common fields between two tables to create “Association” between them.
Must Check: Filter Pane in Qlik Sense – Complete Guide
Steps to Make Association in Qlik Sense
Create Qlik Sense Data Model / Make Association in Qlik Sense with the following steps:
Step 1: Load two tables into Qlik Sense
- In, Qlik Sense data could be loaded in the following ways:
With the help of Toolbar
This section represents the commands used by Data Load Editor:
- Global Menu
- Load Data
The “Load Data” would help to load data into “Qlik Sense”, display the “save data” and check the “Data Load Status” into App.
With the help of Data Connections
Under this section, you can save shortcuts to data sources you want to use. You can even decide the data you want to load
With the help of Text Editor
This option helps you to write and edit script code in Text Editor. This option contains commands such as Search and Replace, Help mode, Undo, and Redo. You can develop Syntax accordingly to load data and work on it.
With the help of Sections
You can divide your Script into two sections and execute the commands from Top to Bottom. You can Add Data, using the “Autogenerated Section” which contains script code to load data.
In this case, the two tables loaded into Qlik Sense are as follows:
Table 1: Product Records
Table 2: Order Details
Step 2: Add the third Table named “Sales Record”
- Open the App which contains the previous two tables
- Click on Edit Option from the toolbar of the sheet
- Open the Global Menu and Select Add Data option
- Select the Data File you want to load
- Click on “Add Data” Button
- Data would be loaded, and the added Table would be displayed as “Bubble” in Data Manager
Step 3: Creating “Association” between the Tables
- Under the Recommended Section on the Right Side of the Window, the data would represent the Recommended Association between any two tables as per the common field present in a data.
- Click and Hold one of the Recommended Table and drag it towards the other Table
- Release the Mouse button, Association would be created between the two Tables
- The Association could be represented with the help of a “Grey Bridge” made between the Bubbles (representing Tables)
- The Bar given beneath Association display pane shows button at the center having the name of common fields between two tables with a “green dot” (a sign of a good data structure)
Step 4: Three different types of Association based on “Colour”
- The “Red” Color is used to represent association or connection which is not recommended at all by System’s Logic
- The “Orange” Color is used to represent the connection or association which is moderately recommended by the System Logic
- The “Green” Color is used to represent the connection or association which is highly recommended by the System Logic
In this blog we learned about:
- Qlik Sense: A “data visualization” tool that is highly popular in the “Business Intelligence” Industry. The additional features such as architecture, key capabilities, customer services, and user-friendly approach make it highly popular.
- Association: It is a relation between the two “Tables” having one or two common fields between them
- We even learned about Creating Association in which we learned about operations such as
- Loading the data into Qlik Sense
- Adding the Third Table
- Creating Association between the Table
- Differentiating Association based upon “Color”
We even learned about the importance of “Well–structured data” because it helps in proper functioning and maintaining the behavior of data. It helps to maintain the storage and the processing speed of data