Audience
This course is for developers, data architects, consultants, or anyone wanting to learn how load and transform data, follow best practices, and resolve common issues when building data models with Qlik Sense.
Expectations
By the end of this course you will understand how to build performant data models with Qlik Sense.
Equipment
To attend the course you'll need to bring a laptop running Windows and with Qlik Sense Desktop installed.
Course Outline
This course covers the key concepts for creating your Qlik Sense data model. Learn how to load data from multiple sources, transform and manipulate the data, different data structures, and which best practices to follow for optimum performance.
The new concepts you'll be introduced to are -
Introduction to Qlik Sense
Data Modelling Concepts
Using the Data Load Editor and Data Model Viewer
Structuring to your script
Data Connections
Load Statements
Data Model Viewer
Concatenating Tables
Table Joins
Useful String Functions
Building a Calendar Table
Mapping Tables
Debugging your Script
Circular References & Synthetic Keys
Composite Keys
Using QVD files
Set Analysis