Curriculum For This Course
Video tutorials list
-
Introduction
Video Name Time 1. Introduction 02:24 -
Qlik Sense Introduction
Video Name Time 1. Qlik Sense Architecture 01:45 2. Qlik Sense Tour 02:59 -
Environment Setup
Video Name Time 1. Qlik Sense Desktop Installation 01:56 2. Course Folder Structure 01:18 -
Introduction to Qlik Sense Scripting
Video Name Time 1. Data Load Editor 03:26 2. Connect, Extract, Load 05:02 3. Load Fact Tables 05:46 4. Challenge - Load Fact Table 01:07 5. Solution - Load Fact Table 01:50 6. Basic Transformations 03:17 7. Challenge - Basic Transformations 00:43 8. Solution - Basic Transformations 02:01 9. Script Debugging 03:57 -
Synthetic Keys
Video Name Time 1. Synthetic Keys Basics 03:22 2. Loading Dimension Tables 03:04 3. Challenge - Synthetic Key 02:30 4. Solution - Synthetic Key 02:17 5. Data Model Viewer 04:51 -
Adding Flat Files
Video Name Time 1. Load Excel Files 03:38 2. Challenge - Load Suppliers Table 01:12 3. Solution - Load Suppliers Table 01:24 4. Challenge - Qualify Statement 03:20 5. Solution - Qualify Statement 01:51 6. Variables 06:51 7. Challenge - Variables 01:21 8. Solution - Variables 01:43 9. Include Files 04:35 10. Challenge - Include Files 00:45 11. Solution - Include Files 01:10 -
Dealing with Data Model Challenges - Part I
Video Name Time 1. Using Record Counters 03:21 2. Challenge - Record Counters 01:15 3. Solution - Record Counters 04:10 4. WHERE Clause 03:39 5. Resident Load 06:44 6. WHERE EXISTS Clause 05:22 7. Challenge - WHERE EXISTS 01:38 8. Solution - WHERE EXISTS 02:43 -
Master Calendar
Video Name Time 1. Master Calendar Fundamentals 03:22 2. FieldValue Function and Flags 04:28 3. Create a Master Calendar 09:20 -
Mapping Tables
Video Name Time 1. Mapping Load Fundamentals 03:47 2. Add Mapping Tables 05:34 3. Challenge - Mapping Table 00:37 4. Solution - Mapping Table 03:42 5. Challenge - Preceding Load 03:21 6. Solution - Preceding Load 02:01 -
Data Model Optimization
Video Name Time 1. Joins Deep Dive 06:03 2. Challenge - Join tables 04:30 3. Solution - Join tables 01:55 4. Concatenation 04:23 5. Implicit and Forced Concatenation 05:51 6. Challenge - Concatenate 00:50 7. Solution - Concatenate 02:40 8. Consolidate Fact Tables 02:03 -
Dealing with Data Model Challenges - Part II
Video Name Time 1. Circular Reference 01:39 2. Cross table 03:41 3. Add Cross table 02:56 4. Link table 04:30 5. Create a Link Table 09:56 6. Class function 03:08 7. Solution - Class Function 02:23 8. Interval Match 08:45 -
All about QVD Files
Video Name Time 1. QVD Fundamentals 06:29 2. Creating QVD Files 06:17 3. Optimized QVD Load 05:49 -
Set Analysis
Video Name Time 1. Set Analysis Fundamentals 12:00 2. Create a Chart with Set Expression 05:45 3. Challenge - Set Modifier 01:02 4. Solution - Set Modifier 03:22 5. Aggr() 07:04 6. Challenge - Set Analysis with Aggr() 00:51 7. Solution - Set Analysis with Aggr() 03:48 8. FirstSortedValue Function 03:50 9. Challenge – FirstSortedValue 11:25 10. Solution – FirstSortedValue 02:15 -
Access
Video Name Time 1. Introduction 01:54 2. Chapter Goals 10:36 3. Layers of Security 07:13 4. ABAC vs RBAC 03:02 5. Authentication vs Authorization 03:43 6. Why Section Access? 05:01 7. Section Access Basics 10:09 8. Section Access - App Authorization 08:32 9. Troubleshooting App Lockdown 11:25 10. Section Access - Data Authorization 11:00 -
On Demand App Generation (ODAG)
Video Name Time 1. Introduction to On Demand App Generation 06:48 2. On Demand App Generation Example 09:07 -
Tips & Tricks
Video Name Time 1. Optimized QVD Load 02:37 2. How to Load Data from a SharePoint List 04:22
Add Comment