The Advanced QlikSense Masterclass

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Curriculum

Lecture 3: Qlik Sense Desktop Installation

Lecture 4: Qlik Sense Desktop Installation

Lecture 5: Unlock Qlik Sense Desktop – Part II

Lecture 6: Folder Structure and Sample Data Files

Lecture 7: Course Approach

Chapter 2: Qlik Associative Engine(QIX) Deep Dive

Lecture 1: The Qlik Associative Engine (QIX) Overview

Lecture 2: Symbol and Data Tables

Lecture 3: Development Best Practices

Lecture 4: Design Best Practices

Chapter 3: Incremental Loads

Lecture 1: Incremental Load Overview

Lecture 2: Incremental Load Process Architecture

Lecture 3: Incremental Load – Inserts: Conceptual Overview

Lecture 4: Incremental Load – Inserts: Part I

Lecture 5: Incremental Load – Inserts: Part II

Lecture 6: Incremental Load – Inserts: Part III

Lecture 7: Incremental Load – Inserts & Updates – Conceptual Overview

Lecture 8: Incremental Load – Inserts & Updates

Lecture 9: Challenge – Incremental Load – Inserts & Updates

Lecture 10: Solution – Incremental Load – Inserts & Updates

Chapter 4: Link Tables

Lecture 1: Link Table Overview

Lecture 2: Link Table – QVF File

Lecture 3: Creating Link Table – Part I

Lecture 4: Creating Link Table – Part II

Lecture 5: Challenge – Link Table

Lecture 6: Solution – Link Table

Chapter 5: Advanced Functions

Lecture 1: Aggr() Function

Lecture 2: Challenge – Aggr() Function

Lecture 3: Solution – Aggr() Function

Lecture 4: CONCAT() Function

Lecture 5: Challenge – CONCAT() Function

Lecture 6: Solution – CONCAT() Function

Lecture 7: FirsSortedValue() Function – Conceptual Overview

Lecture 8: FirsSortedValue() Function

Lecture 9: Challenge – FirstSortedValue() Function

Lecture 10: Solution – FirstSortedValue() Function

Chapter 6: Advanced Set Analysis

Lecture 1: Set Analysis Overview

Lecture 2: Dollar-Sign Expansion

Lecture 3: Challenge – Dollar-Sign Expansion

Lecture 4: Solution – Dollar-Sign Expansion

Lecture 5: Set Analysis with Aggr and Concat functions

Lecture 6: Important Operators

Lecture 7: Field Comparison

Lecture 8: Challenge – Set Modifier with an Expression

Lecture 9: Solution – Set Modifier with an Expression

Chapter 7: Alternate States

Lecture 1: Alternate States Overview

Lecture 2: Challenge – Alternate States

Lecture 3: Solution – Alternate States

Chapter 8: Qlik Sense Security

Lecture 1: Security Fundamentals

Lecture 2: Security – User Access Workflow

Lecture 3: Impersonation

Lecture 4: Security Rule – Stream Level Access

Lecture 5: Security Rule – App Level Access by Role

Lecture 6: Security Rule – Sheet Level Access

Chapter 9: On Demand App Generation(ODAG)

Lecture 1: Introduction

Lecture 2: ODAG Example

Chapter 10: Tips & Tricks

Lecture 1: Subset Ratio

Lecture 2: Optimized QVD Load

Lecture 3: How to Load Data from a SharePoint List

Lecture 4: Table Concatenation & Date Fields

Lecture 5: Peek() vs Previous()

Lecture 6: Nested Parameterized Variables

Lecture 7: For Loops

Lecture 8: New Set Analysis Syntax