O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Mastering Qlik Sense

Video Description

Debug common issues and optimize your data model to achieve the best performance for your Qlik Sense app

About This Video

  • Get acquainted with the basic as well as advanced Business Intelligence capabilities of Qlik Sense
  • Develop Qlik Sense models (using data in various formats) that run on-premise as well as on the cloud
  • Administer your Qlik Sense applications for maximum performance and reliability

In Detail

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.

The scripts for this course are available on Github at - https://github.com/PacktPublishing/Mastering-Qlik-Sense-v-

Downloading the example code for this course: You can download the example code files for all Packt video courses you have purchased from your account at http://www.PacktPub.com. If you purchased this course elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.

Table of Contents

  1. Chapter 1 : Qlik Sense: Going Beyond Essentials
    1. The Course Overview 00:03:40
    2. What’s New in Qlik Sense? 00:07:41
    3. Understanding the Schemas 00:05:01
    4. Our Objective: The Data Model 00:01:32
  2. Chapter 2 : Loading data in Qlik Sense
    1. Introduction to Data Load Editor 00:04:19
    2. Loading Data in Qlik Sense 00:06:57
    3. What is Data Transformation? 00:05:46
  3. Chapter 3 : Synthetic Keys: Common Issues and Solutions
    1. Loading Dimension Tables 00:09:09
    2. Synthetic Keys: Problems Arising from Them 00:03:49
    3. Synthetic Keys: Choosing a Solution That Works for You 00:06:15
    4. Synthetic Keys: Impact on Your Dashboard 00:05:26
  4. Chapter 4 : Debugging Common Issues around Circular References
    1. Loading Data: Database Example 00:02:18
    2. Loading Data from Other Data Files 00:07:53
    3. What Impact Does Circular Reference Have? 00:02:18
    4. Resolving Circular References 00:15:17
    5. Impact of the Circular References on the Dashboard 00:02:22
  5. Chapter 5 : Doing More with Your data
    1. Using the Where Clause to Filter Data 00:04:25
    2. Using Resident Load to Manipulate Data 00:03:17
    3. Using Where Exists for comparisons 00:09:22
    4. Adding Counters When Needed 00:05:13
  6. Chapter 6 : Using Mapping Tables and Preceding Load
    1. Mapping Load 00:09:01
    2. Preceding Load 00:10:57
  7. Chapter 7 : Optimizing Data Model with Joins
    1. Introduction of Joins 00:05:23
    2. Using Joins 00:05:12
    3. Concatenation in Qlik Sense 00:04:31
    4. Auto- Concatenation in Qlik Sense 00:05:12
    5. Forced Concatenation in Qlik Sense 00:06:21
  8. Chapter 8 : Class Function and Link Tables
    1. Grouping Data Using Class Function 00:03:07
    2. How To Use the Class Function 00:05:21
    3. Link Tables in Qlik Sense 00:07:56
  9. Chapter 9 : Making the Most of Master Calendar
    1. Master Calendar 00:02:40
    2. Master Calendar MinMaxDate 00:08:04
    3. Master Calendar – Final Script 00:04:23
    4. Master Calendar – Dashboard Example 00:03:02
  10. Chapter 10 : Applying Set Analysis and Section Access
    1. Introduction To Set Analysis 00:06:54
    2. How Does Set Analysis Work 00:04:40
    3. Section Access 00:04:05
    4. Section Access Script 00:04:51
    5. Moving on From Here... 00:01:54