Setting up our free QlikSense business account | Thinkmetrics Academy

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Qlik Master Class: Master Qlik Sense App development

Intro

Setting up our free QlikSense business account (2:00)
Intro to the Qlik Console (2:36)
How to navigate the Qlik Sense Hub (4:42)

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

Amazon Sales data contd.
When to use a canonical calendar (6:42)
Building the Canonical calendar (17:45)
MUST Watch!!! Caveat to using the Canonical Calendar. Be careful! (5:38)

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

Ad Hoc Reporting: User based input using dimension drop down list (12:54)
Bonus: Ad Hoc Reporting version 2: Create a user-selected table using variable drop-down list method (21:56)

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)

Data Cleaning

Data cleaning with a challenge. (9:13)
Bonus : Data Cleaning Tutorial (12:36)

QlikSense Extras

Bookmarks (5:18)
Story Telling using Qlik's inbuilt story mode (7:51)
QVD viewer. What are they and why you should use them. (6:27)
Change Qlik themes and default colors (2:51)
Resources to elevate your dashboards by using the right color scheme (5:20)

Bonus Material

Bonus Material: Extra lesson: Total vs {1} vs All (5:41)
Bonus lesson: Year on Year growth % tutorial (8:17)
Bonus practice: Dynamic value selection using buttons & sliders. Front end magic. (26:18)

AI & QlikSense : Integrating ChatGPT into Qliksense

Build the dataset - connect to ChatGPT and ask ChatGPT to analyze your data (54:43)

Thanks & Outro

Outro (2:02)
Get Access to the ThinkMetrics Discord Community

Teach online with

Setting up our free QlikSense business account

Complete and Continue

Discussion

0 comments