QlikSense Data Architect Masterclass

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Course Curriculum Overview

Lecture 3: The Course Approach

Chapter 2: Qlik Sense Introduction

Lecture 1: Qlik Sense Tour

Lecture 2: Qlik Sense Architecture

Chapter 3: Environment Setup

Lecture 1: The Qlik Sense Desktop Installation

Lecture 2: Unlock Qlik Sense Desktop – Part I

Lecture 3: Unlock Qlik Sense Desktop – Part II

Lecture 4: Course Folder Structure

Chapter 4: Introduction to Qlik Sense Scripting

Lecture 1: Data Load Editor

Lecture 2: Connect, Extract, Load

Lecture 3: Load Fact Tables

Lecture 4: Challenge – Load Fact Table

Lecture 5: Solution – Load Fact Table

Lecture 6: Basic Transformations

Lecture 7: Challenge – Basic Transformations

Lecture 8: Solution – Basic Transformations

Lecture 9: Script Debugging

Chapter 5: Synthetic Keys

Lecture 1: Synthetic Keys Basics

Lecture 2: Loading Dimension Tables

Lecture 3: Challenge – Synthetic Key

Lecture 4: Solution – Synthetic Key

Lecture 5: Data Model Viewer

Chapter 6: Adding Flat Files

Lecture 1: Load Excel Files

Lecture 2: Challenge – Load Suppliers Table

Lecture 3: Solution – Load Suppliers Table

Lecture 4: Challenge – Qualify Statement

Lecture 5: Solution – Qualify Statement

Lecture 6: Variables

Lecture 7: Challenge – Variables

Lecture 8: Solution – Variables

Lecture 9: Include Files

Lecture 10: Challenge – Include Files

Lecture 11: Solution – Include Files

Chapter 7: Dealing with Data Model Challenges – Part I

Lecture 1: Using Record Counters

Lecture 2: Challenge – Record Counters

Lecture 3: Solution – Record Counters

Lecture 4: WHERE Clause

Lecture 5: Resident Load

Lecture 6: WHERE EXISTS Clause

Lecture 7: Challenge – WHERE EXISTS

Lecture 8: Solution – WHERE EXISTS

Chapter 8: Master Calendar

Lecture 1: Master Calendar Fundamentals

Lecture 2: FieldValue Function and Flags

Lecture 3: Create a Master Calendar

Chapter 9: Mapping Tables

Lecture 1: Mapping Load Fundamentals

Lecture 2: Add Mapping Tables

Lecture 3: Challenge – Mapping Table

Lecture 4: Solution – Mapping Table

Lecture 5: Challenge – Preceding Load

Lecture 6: Solution – Preceding Load

Chapter 10: Data Model Optimization

Lecture 1: Joins Deep Dive

Lecture 2: Challenge – Join tables

Lecture 3: Solution – Join tables

Lecture 4: Concatenation

Lecture 5: Implicit and Forced Concatenation

Lecture 6: Challenge – Concatenate

Lecture 7: Solution – Concatenate

Lecture 8: Consolidate Fact Tables

Chapter 11: Dealing with Data Model Challenges – Part II

Lecture 1: Circular Reference

Lecture 2: Cross table

Lecture 3: Add Cross table

Lecture 4: Link table

Lecture 5: Create a Link Table

Lecture 6: Class function

Lecture 7: Solution – Class Function

Lecture 8: Interval Match

Chapter 12: All about QVD Files

Lecture 1: QVD Fundamentals

Lecture 2: Creating QVD Files

Lecture 3: Optimized QVD Load

Chapter 13: Set Analysis

Lecture 1: Set Analysis Fundamentals

Lecture 2: Create a Chart with Set Expression

Lecture 3: Challenge – Set Modifier

Lecture 4: Solution – Set Modifier

Lecture 5: Aggr()

Lecture 6: Challenge – Set Analysis with Aggr()

Lecture 7: Solution – Set Analysis with Aggr()

Lecture 8: FirstSortedValue Function