Intro
Building your first app
-
Section 2 Intro (2:10)
-
Loading our first dataset using the qlik associative engine. (10:44)
-
Checking our data and creating the data model (2:41)
-
What are dimensions and measures. (3:45)
-
Overview of the sheet (12:25)
-
Building our first dashboard - Part 1 (10:02)
-
Building our first dashboard - Part 2 (7:04)
-
Creating Master Measures & Drill Down Dimensions (10:01)
-
Creating KPI charts & filters (12:08)
-
Pimping our scatter plot with more features (8:35)
-
Creating a new sheet and building our dashboard with a new focus (9:25)
-
Creating a Tree Map and more features (6:24)
-
Creating a combo chart (9:03)
-
Adding maps to our dashboard (14:45)
Intro to the script editor
-
Section 3 Intro (1:58)
-
Intro to the script editor (12:11)
-
Loading data using the script editor (8:33)
-
What are synthetic keys? How to Solve them (6:38)
-
What are circular references? How to Solve them? (7:49)
-
Intro to Joins : How to Join tables (9:20)
-
Conditional data load using Where,Like, Match (8:53)
-
Intro to Set expressions Part 1 (10:15)
-
Set expressions - Part 2 (12:46)
-
Set Expressions Part 3: How to use variables in Set Expressions (7:29)
-
Concatenating multiple tables (7:04)
-
Putting it together in our KPI dashboard (14:51)
-
Dashboard contd.. (5:11)
-
Growth % & conditional coloring - Dashboard part 3 (6:30)
-
Creating and customizing a Pivot Table (7:35)
-
Extra chapter on set expression Identifiers. $ vs 1 vs 1-$ (6:32)
-
Adding Load messages to your script editor for easy debug (7:11)
-
How to create composite keys (5:13)
Amazon sales analytics
-
Section 4 Intro (2:05)
-
New section data load (10:58)
-
Data model transformation using Mapping function (9:16)
-
Inline load : How to enter manual data (3:12)
-
Data transformation using MapSubstring function (5:02)
-
Data segmentation using IF & Interval Match (13:36)
-
Resident Loads & Group By (6:56)
-
Data classification using Class & Match function (5:24)
-
Creating a basic Master Calendar (14:48)
-
Advanced Date Set expressions & calendar Flags (10:04)
-
Year on Year comparison Chart (3:32)
-
Adding Distribution charts to the Dashboard (5:30)
-
Intro to the Aggregate function (5:42)
-
Advanced calculations using AGGR, Rank & IF (11:18)
-
Advanced calculations using Aggr & First Sorted Value (7:56)
-
Intro to elemental functions Possible() & Exclude() (4:06)
-
Using the exclude function E() in our dashboard (10:11)
-
Using the Possible function P() in our dashboard (8:06)
-
Putting it all together in the dashboard Part - 1 (10:53)
-
Putting it all together in the dashboard- Part 2 (6:44)
-
Basics of Running Total and Running Percentage (8:49)
-
80/20 Pareto Analysis chart (10:32)
-
Pareto analysis or ABC analysis using Sorted AGGR function (15:32)
-
Completing our dashboard (6:27)
-
Completing our dashboard Part -2 . Fine tuning our ABC analysis chart (7:46)
-
Spice up your tables by creating SparkLines (4:41)
Building apps using the Canonical Calendar
Interactive Dashboard analytics
-
Section 5 intro (1:42)
-
Intro to variables (6:49)
-
Using variables to load file paths (5:21)
-
Loading entire Measures using variables (4:10)
-
How to incorporate variables inside Set Expressions (4:58)
-
Simplifying Date functions using variables (6:14)
-
Variables inside a variable aka Variable inception YTD inside Variables. (14:46)
-
Variable input: Assign values to variables interactively in the dashboard (8:36)
-
Dashboard completion & Assigning field selections to variables (9:12)
-
How to create a What-IF Scenario analysis dashboard (10:55)
-
How to create a side by side comparative analysis charts using Alternate States (9:57)
Front End Magic: Start Up Analysis Dashboard
-
Section 6 Intro (1:23)
-
Loading start up data set (6:51)
-
Magic of buttons. How to automatize your dashboard (6:59)
-
Embed links to external websites directly in your dashboard (1:52)
-
How to hide & Show charts based on needs (7:40)
-
Building a cool, interactive target startup selector dashboard (15:08)
-
Bonus lesson: Creating an interactive user input dashboard with dynamic buttons (11:29)
Ad Hoc reports
Data loading through Excel
-
Automatically Bulk load excel/ csv files from a folder (6:15)
-
Bulk load data from multiple files by looping through files using a FOR Loop (8:34)
-
Load data from different sheets by Looping through sheet names (6:51)
-
Load data by Looping through incremental sheet numbers (4:56)
-
Debugging errors in bulk loads to make sure all files are loaded (5:02)
QlikSense Extras
Bonus Material
AI & QlikSense : Integrating ChatGPT into Qliksense
Thanks & Outro
