Introduction
  • Introduction
  • Course Curriculum Overview
  • The Course Approach
Qlik Sense Introduction
  • Qlik Sense Architecture
  • Qlik Sense Tour
Environment Setup
  • The Qlik Sense Desktop Installation
  • Unlock Qlik Sense Desktop - Part I
  • Unlock Qlik Sense Desktop - Part II
  • Course Folder Structure
Introduction to Qlik Sense Scripting
  • Data Load Editor
  • Connect, Extract, Load
  • Load Fact Tables
  • Challenge - Load Fact Table
  • Solution - Load Fact Table
  • Basic Transformations
  • Challenge - Basic Transformations
  • Solution - Basic Transformations
  • Script Debugging
  • Introduction to Qlik Sense Scripting
Synthetic Keys
  • Synthetic Keys Basics
  • Loading Dimension Tables
  • Challenge - Synthetic Key
  • Solution - Synthetic Key
  • Data Model Viewer
  • Synthetic Keys
Adding Flat Files
  • Load Excel Files
  • Challenge - Load Suppliers Table
  • Solution - Load Suppliers Table
  • Challenge - Qualify Statement
  • Solution - Qualify Statement
  • Variables
  • Challenge - Variables
  • Solution - Variables
  • Include Files
  • Challenge - Include Files
  • Solution - Include Files
  • Adding Flat Files
Dealing with Data Model Challenges - Part I
  • Using Record Counters
  • Challenge - Record Counters
  • Solution - Record Counters
  • WHERE Clause
  • Resident Load
  • WHERE EXISTS Clause
  • Challenge - WHERE EXISTS
  • Solution - WHERE EXISTS
  • Dealing with Data Model Challenges - Part I
Master Calendar
  • Master Calendar Fundamentals
  • FieldValue Function and Flags
  • Create a Master Calendar
  • Master Calendar
Mapping Tables
  • Mapping Load Fundamentals
  • Add Mapping Tables
  • Challenge - Mapping Table
  • Solution - Mapping Table
  • Challenge - Preceding Load
  • Solution - Preceding Load
  • Mapping Tables
Data Model Optimization
  • Joins Deep Dive
  • Challenge - Join tables
  • Solution - Join tables
  • Concatenation
  • Implicit and Forced Concatenation
  • Challenge - Concatenate
  • Solution - Concatenate
  • Consolidate Fact Tables
  • Data Model Optimization
Dealing with Data Model Challenges - Part II
  • Circular Reference
  • Cross table
  • Add Cross table
  • Link table
  • Create a Link Table
  • Class function
  • Solution - Class Function
  • Interval Match
  • Dealing with Data Model Challenges - Part II
All about QVD Files
  • QVD Fundamentals
  • Creating QVD Files
  • Optimized QVD Load
  • All About QVD Files
Set Analysis
  • Set Analysis Fundamentals
  • Create a Chart with Set Expression
  • Challenge - Set Modifier
  • Solution - Set Modifier
  • Aggr()
  • Challenge - Set Analysis with Aggr()
  • Solution - Set Analysis with Aggr()
  • FirstSortedValue Function