Introduction
- Course Intro
- Course Curriculum Overview
- For HELP: Join Private Slack Channel
Github: Data Set, Challenges, Solution QVWs
- 2.1: Course Approach and Github
- 2.2: Approach - Challenges and Solutions
QlikView Data Modelling
- 3.0 Chapter Goals
- 3.1: Understanding Data Modelling (Part 1)
- 3.1: Understanding Data Modelling (Part 2)
- 3.1: Understanding Data Modelling (Part 3)
- 3.2: Conceptual Aside - Data Modelling
- 3.3: Types of Data Models
- 3.4: Conceptual Aside - Star Schema
- Data Modelling
- 3.5: Demo - Star Schema
- 3.6: Conceptual Aside - Snowflake Schema
- 3.7: Demo - Snowflake Schema
- 3.8: Concatenated Fact Tables
- 3:9: Demo - Concatenated Fact Table
- 3.10: Our Advice
- 3.11: Challenge - Simplify the Data Model
- 3.12: Solution - Simplify the Data Model
Mapping Load, ApplyMap and Map using
- 4.0: Chapter Goals
- 4.1: Understanding Mapping Load
- 4.2: Understanding ApplyMap( )
- 4.3: MapSubString( )
- 4.4: Map Using
- 4.5a: Challenge
- 4.5a: Solution
- 4.5b: Challenge
- 4.5b: Solution
- Mapping Load, ApplyMap and Map Using
Resident Load vs. Preceding Load
- 5:0: Chapter Goals
- 5:1: Understanding Script Execution
- 5.2: Understanding Resident Load
- 5.3: Understanding Preceding Load
- Script Execution, Resident load, Preceding Load
- 5.4: Further Reading (Cost of Preceding Load)
- 5.5: Difference between WHERE and HAVING clause
- 5.6: How to implement HAVING clause in QlikView
- 5.7: Challenge - Resident vs Preceding Load
- 5.8: Challenge - Source Files (QVW, QVS and QVD)
- 5.8: Solution - Resident vs Preceding Load
- Where and Having Clause
Synthetic Keys and Link Table
- 6.0: Chapter Goals
- 6.1: Introduction to Synthetic Keys and Link Table
- 6.2: Link Table Deep Dive
- 6.3: Creating Link Table - I
- 6.4: Creating Link Table - II
- 6.5: Challenge - Synthetic Table to Link Table
- 6.6: Solution - Synthetic Table to Link Table
- 6.7 Chapter Summary
- Quiz: Link Tables and Synthetic Keys
Incremental Reload
- 7.0: Chapter Goals
- 7.1: Understanding Incremental Reload
- 7.2: Incremental Reload Architecture
- 7.3 Incremental Reload: Inserts - Part I
- 7.3 Incremental Reload: Inserts - Part II
- 7.3 Incremental Reload: Inserts - Part III
- 7.3 Incremental Reload: Inserts - Part IV
- 7.4: Incremental Reload - Insert and Update - Part I
- 7.4: Incremental Reload - Insert and Update - Part II
- 7.5: Challenge Incremental load – Insert and Update
- 7.6: Solution - Incremental load – Insert and Update
- 7.7: Incremental Reload - Insert, Update and Delete - Part I
- 7.7: Incremental Reload - Insert, Update and Delete - Part II
- 7.8: Challenge - Incremental load – Insert, Update and Delete
- 7.9: Solution - Incremental load – Insert, Update and Delete
- 7.10: Chapter Summary
- Quiz: Incremental Reload
QlikView Joins Deep Dive
- 8.0: Chapter Goals
- 8.1: Associative Join and Explicit ANSI Style Joins
- 8.2: Outer Join
- 8.3: Inner Join
- 8.4: Left Join
- 8.5: Right Join
- 8.6: Cartesian Product
- QlikView Joins
Introduction to Master Calendar
- 9.0: Chapter Goals
- 9.1: Master Calendar Fundamentals
- 9.2: Steps to Create Master Calendar
- 9.3 Challenge - Master Calendar
- 9.4: Solution - Master Calendar
- 9.5 Chapter Summary
- Quiz: Master Calendar
Folder Structure, Script Configuration & Variable Naming Convention
- 10.0 Chapter Goals
- 10.1: Application Folder Structure
- 10.2 QlikView and Source Control
- 10.3: Script Tab Layout
- 10.4: Script Global Config File
- 10.5: Variable Naming Convention
