Mastering Qlik Sense Online Course

About the Course

You've probably done some beginner work on Qlik Sense, so you know how easy it is to work with the interface. However, there is always more than what we see on the Qlik Sense dashboard. Work done by developers in the extremity plays a very important role while making an appealing and well-performing dashboard.

If your data model is not designed appropriately, you will face issues not only with the performance of the app but also with the quality of its output.

In this course, we look at everything that goes into creating a data model to give you the most optimized performance, including how to load data from different data sources, fix synthetic keys, and other issues. Also included are topics such as creating link tables, the master calendar script, and applying set analysis to your data. Thus, you will master the art of creating dashboards that are not only visually appealing and accurate but also very informative and a BIG bonus to your team while making those tough decisions.

Course Curriculum

Qlik Sense: Going Beyond Essentials

• Course Overview
• What’s New in Qlik Sense?
• Understanding the Schemas
• Our Objective: The Data Model

Loading data in Qlik Sense

• Introduction to Data Load Editor
• Loading Data in Qlik Sense
• What is Data Transformation?

Synthetic Keys: Common Issues and Solutions

• Loading Dimension Tables
• Synthetic Keys: Problems Arising from Them
• Synthetic Keys: Choosing a Solution That Works for You
• Synthetic Keys: Impact on Your Dashboard

Debugging Common Issues around Circular References

• Loading Data: Database Example
• Loading Data from Other Data Files
• What Impact Does Circular Reference Have?
• Resolving Circular References
• Impact of the Circular References on the Dashboard

Doing More with Your data

• Using the Where Clause to Filter Data
• Using Resident Load to Manipulate Data
• Using Where Exists for comparisons
• Adding Counters When Needed

Using Mapping Tables and Preceding Load

• Mapping Load
• Preceding Load

Optimizing Data Model with Joins

• Introduction of Joins
• Using Joins
• Concatenation in Qlik Sense
• Auto- Concatenation in Qlik Sense
• Forced Concatenation in Qlik Sense

Class Function and Link Tables

• Grouping Data Using Class Function
• How To Use the Class Function
• Link Tables in Qlik Sense

Making the Most of Master Calendar

• Master Calendar
• Master Calendar MinMaxDate
• Master Calendar –Final Script
• Master Calendar – Dashboard Example

Applying Set Analysis and Section Access

• Introduction To Set Analysis
• How Does Set Analysis Work
• Section Access
• Section Access Script
• Moving on From Here...