Courses
Data Modelling - Level 2

Data Modelling - Level 2

Use string & date functions, mapping tables, QVD files & the debugger. Resolve circular references & synthetic keys.

This course is for anyone that understands the basics of creating a load script and wants to take it to the next level.

To complete this course, you'll need to have Qlik Sense Desktop installed.

Approx 4 hours

Lessons

1 - String Functions
Learn more about some of the useful string functions that Qlik Sense has to offer
U
2 - Dates & Date Functions
Introduction to Dates and some of the more common Date functions
U
3 - Script Variables
A look at how to create and use variables in a Qlik script
U
4 - Creating a Calendar Table
Learn the common approach to building a calendar table, based on the date range in the data
U
5 - Mapping Tables
Create mapping tables, understand their behaviour, and how to use them
U
6 - Debug Panel
Explore the Debug Panel and learn how its features can help you solve script issues
U
7 - Circular References & Synthetic Keys
Understand why circular references and synthetic keys occur, and how to remove them
U
8 - Composite Keys & AutoNumber
Use composite keys to solve multiple links between tables, and add AutoNumber to help performance
U
9 - QVD Files
Use QVD files to import and export data much faster from the Qlik Sense data model
U