The Qlik Sense Data Analyst Weekend Boot Camp

Master Qlik Sense for data analysis, data visualisation & dashboard design, advanced analytics e.g. K-Means, Forecasting

What you'll learn

Showcase your skills with 3 full-scale course projects (with step-by-step solutions)

Explore powerful advanced data analysis & visualization techniques e.g. Linear Regression, K-Means etc

Design, implement the same apps used by professional data analysts and data scientists

Learn from a #1 best-selling instructor and professional Qlik Sense developer

Build professional-quality business intelligence dashboards from scratch

Practice your skills with the many , many practice assignments through the course

How to load data ready to transform into useful visualisations for your users

Requirements

Qlik Sense Desktop (Download links included - Free to use)

This course is designed for PC/Windows users (currently it is not available for Mac)

No functional programming experience required but if you have some it's a bonus, but I'll teach you anyway!

Description

Are you a data analyst looking to enhance your skills Qlik Sense or looking to up-skill your current knowledge ?Are you new to Qlik Sense data analytics and really need to learn more than just the basics ?The Qlik Sense Data Analyst Weekend Boot Camp is designed just for you! This intensive, hands-on course will get you up to speed with Qlik Sense in only two days.Course Highlights:Creating Apps: Learn how to build and manage Qlik Sense applications from scratch.Loading Data: Loading prepared data and creating data using AI as guidance.Designing Appropriate Charts: Master the art of creating insightful and visually appealing charts and dashboards.Understand the Associative Model: Dive deep into Qlik Sense's unique associative model to uncover hidden insights.Writing Set Expressions: (Inner and Outer) Enhance your analytical capabilities with advanced set expression techniques.Hands on with Advanced functions: such as Correlation, K-Means, STL, as well as Simple Linear Regression thus adding value to your skills.Practice assignments: challenges for you to learn withYou get to build 3 apps to help you transition from beginner to advanced developerHelp Desk Analytics (Initial Skills Build Stage)Interpret User RequirementsLoad data from excel via the data managerRepair data via the data managerDesign and create a dashboard with informative visual objectsWrite calculation logic and then transition to set expression based calculationsHow to create and maintain Master Items for reusabilityAll about variables and $ ExpansionStyling your visualisations for best impactUse ChatGPT to analyze a chart to provide insightGlobal Retail Sales (Maturing Skills Build Stage)Interpret User RequirementsLoad data using the data load script editorScripting using AIDrill down and cyclic dimensionsGeo Analytics (Multi Layered)Content ContainersAdvanced Set Expression coding (Total, Aggr(), RangeSum() etc. etc.)Correlation, STL, K-Means ClusteringSet modifiers using set functions { P(), E() } for calculating e.g. Customer ChurnAnd a lot moreData Forecasting (Advanced Skills Build Stage)Load data using the data load script editor, futurize the calendarUnderstand the theory of Simple Linear RegressionCode regression expressions for Slope, Intercept and R²Implement and review the visualisationsJoin me for a weekend of Qlik Sense training, you'll be glad you did and get immediate, lifetime access to:16 hours of high-quality video30+ homework practice assignments & solutionsDownloadable course project (Software, Data and Qlik Sense App) filesExpert Q&A support 30-day money-back guarantee

Overview

Section 1: Introduction to Qlik Sense

Lecture 1 Getting Started

Lecture 2 Download, Install and Unlock Qlik Sense Desktop

Lecture 3 A Sneak Peek at Qlik Sense Features

Lecture 4 What is the HUB ?

Section 2: Build a Help Desk Performance App in under 3 hours

Lecture 5 Welcome to this section. This is what we will develop !

Lecture 6 User Requirements Specification for Development

Lecture 7 Create and Explore a New App

Lecture 8 No Code Data Load

Lecture 9 Leverage AI When the SME is not Available

Lecture 10 How to Add a Computed Field to Your Data

Lecture 11 Practice Assignment 2.1

Lecture 12 The Qlik Associative Model - Concept

Lecture 13 What is the Selection Model ?

Lecture 14 Creating our Dashboard Sheet

Lecture 15 The Drill Down Dimension

Lecture 16 Adding Filter Panes

Lecture 17 Getting Started with Measures

Lecture 18 Applying Logic to the Measure with If()

Lecture 19 Styling the KPI

Lecture 20 Practice Assignment 2.2

Lecture 21 KPI's to Count Unique Rows Only

Lecture 22 Practice Assignment 2.3

Lecture 23 Your first chart is a Scatter Plot - Dimensions and Measures

Lecture 24 Your first chart is a Scatter Plot - Add Visual Ques to Derive Instant Insight

Lecture 25 Using AI to Reveal Insight in the Scatter Plot

Lecture 26 Putting a Pie Chart to Good Use

Lecture 27 Practice Assignment 2.4

Lecture 28 Using a Bar Chart for Categorical Comparisons

Lecture 29 Introduction to Time Based Trends via a Line Chart

Lecture 30 Highlight Bad Dimension Data via the Data Manager

Lecture 31 Visualization Tips and Tricks - Part 1/2

Lecture 32 Visualization Tips and Tricks - Part 2/2

Section 3: Optimizing KPIs - Replacing If() Functions with Set Analysis

Lecture 33 Welcome to this section. This is what we will develop !

Lecture 34 Introducing Set Analysis: A Powerful Tool for Qlik Sense Developers

Lecture 35 The Inner and Outer Set Expression Structure (Syntax)

Lecture 36 Replace if() with Inner Set Expressions

Lecture 37 Replace Inner Set Expression with Outer Set Expressions

Lecture 38 Master Measures used in Expressions

Lecture 39 Master Expression and Visualizations Combined

Lecture 40 Practice Assignment 3.1

Section 4: Understanding Qlik Sense Variables and $ Sign Expansion

Lecture 41 Variables in Qlik Sense

Lecture 42 Working with Variables

Lecture 43 Practice Assignment 4.1

Section 5: Define the Sales Analytics Project Scope

Lecture 44 Presenting the Design Requirements

Lecture 45 What is Our Data Source ?

Section 6: Loading Tier 3 Data Into The Model

Lecture 46 Welcome to this section. This is what we will develop !

Lecture 47 Understanding the Star Schema

Lecture 48 Understanding the Snowflake Schema

Lecture 49 Using the Data Load Editor to Import Data - Part 1/3

Lecture 50 Using the Data Load Editor to Import Data - Part 2/3

Lecture 51 Using the Data Load Editor to Import Data - Part 3/3

Lecture 52 The Data Model Summary

Lecture 53 Use AI to generate a Master Calendar - The Need

Lecture 54 Use AI to generate a Master Calendar - Qualifying Date Ranges

Lecture 55 Use AI to generate a Master Calendar - Using the Generated Code

Lecture 56 The Master Calendar Generation is Immediately Beneficial

Lecture 57 Practice Assignment 6.1

Section 7: Omni Channel Revenue Dashboard

Lecture 58 Welcome to this section. This is what we will develop !

Lecture 59 Functional Specification - Revenue Dashboard

Lecture 60 Setting up the Dashboard Sheet Style

Lecture 61 Create a Calendar Drill Down Dimension

Lecture 62 Practice Assignment 7.1

Lecture 63 Sales Channel 1 Revenue Master Measure

Lecture 64 Sales Channel 1 Profit Master Measure

Lecture 65 Sales Channel 1 Revenue KPI

Lecture 66 Practice Assignment 7.2

Lecture 67 Finalizing the Omni Channel Dashboard Sheet

Section 8: Summary Dashboard - Comparative KPI cluster

Lecture 68 Welcome to this section. This is what we will develop !

Lecture 69 Functional Specification - KPI Cluster

Lecture 70 Date Type Consideration

Lecture 71 All Time Instore Sales Revenue KPI

Lecture 72 Practice Assignment 8.1

Lecture 73 Finesse the KPI Styling

Lecture 74 All Time Instore Profit

Lecture 75 Practice Assignment 8.2

Lecture 76 Introducing the Variable Input Control

Lecture 77 Switch KPI Metrics On/Off

Lecture 78 Practice Assignment 8.3

Lecture 79 This Year / Last Year Revenue KPI's

Lecture 80 Practice Assignment 8.4

Lecture 81 Today / Yesterday Revenue KPI's

Lecture 82 Practice Assignment 8.5

Lecture 83 Periodic Differences KPI

Lecture 84 Practice Assignment 8.6

Section 9: Summary Dashboard - GEO Analytics

Lecture 85 Welcome to this section. This is what we will develop !

Lecture 86 Functional Specification - The Map

Lecture 87 Practice Assignment 9.1

Lecture 88 Getting Started With Map Layers

Lecture 89 Add the Revenue Point Layer

Lecture 90 Solving the $0 Revenue Point Issue

Lecture 91 Layer Display can be Controlled

Lecture 92 Practice Assignment 9.2

Section 10: Summary Dashboard - Trending Measures

Lecture 93 Welcome to this section. This is what we will develop !

Lecture 94 Functional Specification - Sales/Profit Trend

Lecture 95 Sales Revenue /Sales Profit Line Chart

Lecture 96 Practice Assignment 10.1

Section 11: Summary Dashboard - Content Containers

Lecture 97 Welcome to this section. This is what we will develop !

Lecture 98 Functional Specification - Visualization Overlays

Lecture 99 Practice Assignment 11.1

Lecture 100 Introduction to Content Containers

Lecture 101 Switching On/Off Visualizations in a Container

Section 12: Summary Dashboard - Revenue Trend vs Age

Lecture 102 Welcome to this section. This is what we will develop !

Lecture 103 Functional Specification - Bar Chart and Correlation

Lecture 104 Will the Data Support the Requirement ?

Lecture 105 Practice Assignment 12.1

Lecture 106 Confirming Your Observation with a Correlation Score

Section 13: Summary Dashboard - A Cyclic Dimension is Now Required

Lecture 107 Practice Assignment Challenge 13.1

Lecture 108 Create a Cyclic Dimension

Section 14: Summary Dashboard - Ranking and Correlation Using Aggr()

Lecture 109 Welcome to this section. This is what we will develop !

Lecture 110 Functional Specification - Top 15 Best Sellers

Lecture 111 Ranking Product Sales Revenue by Dimension Limiting

Lecture 112 Understanding Aggregation Scope to Calculate Share

Lecture 113 The Purpose of the Aggr() Function

Lecture 114 Implementing Aggr() to Create the Top 15 Product List

Lecture 115 Circle Back to Correlation Using the Aggr() Function

Section 15: Summary Dashboard - Special Customer KPI's using Element Set Functions

Lecture 116 Welcome to this section. This is what we will develop !

Lecture 117 Functional Specification - Specialized KPI's

Lecture 118 Explicit Currency Exclusion as a Sales KPI

Lecture 119 Practice Assignment - 15.1

Lecture 120 Calculating New Customer Count KPI

Lecture 121 How Many Customers Did We Lose ? - Part 1

Lecture 122 How Many Customers Did We Lose ? - Part 2

Lecture 123 Practice Assignment Challenge 15.2

Lecture 124 What Does the Customer Churn % Look Like ?

Section 16: Summary Dashboard - Pie Charts in Action (Revenue, Discounts, and Demographics)

Lecture 125 Welcome to this section. This is what we will develop !

Lecture 126 Functional Specification - Pie Charts in Action

Lecture 127 A Case for Pie Charts or Not !

Lecture 128 Practice Assignment - 16.1

Lecture 129 Segmenting Revenue by Education & Product Category

Lecture 130 Practice Assignment - 16.2

Section 17: Advanced Sales Analysis - Implementing the 80/20 Rule

Lecture 131 Welcome to this section. This is what we will develop !

Lecture 132 Functional Specification - Visualizing the 80/20 Rule

Lecture 133 Introducing Advanced Functions

Lecture 134 Chart Build Step 1 Base Combo Chart

Lecture 135 Chart Build Step 2 First Accumulation

Lecture 136 Chart Build Step 3 Final Accumulation - Part 1

Lecture 137 Chart Build Step 3 Final Accumulation - Part 2

Lecture 138 Practice Assignment Challenge 17.1

Lecture 139 Practice Assignment Challenge 17.1 - Demo

Section 18: Advanced Sales Analysis - K Means Clustering

Lecture 140 Welcome to this section. This is what we will develop !

Lecture 141 Functional Specification - Sales / Orders Distribution

Lecture 142 K-Means Clustering - 101

Lecture 143 Create the Baseline Scatter Plot Chart

Lecture 144 Implementing K-Means in the Chart

Lecture 145 Practice Assignment 18.1

Section 19: Advanced Sales Analysis - Order Value Distribution

Lecture 146 Welcome to this section. This is what we will develop !

Lecture 147 Functional Specification - Order Value Distribution

Lecture 148 Creating the Stacked Bar Chart

Lecture 149 Calculating Median in Qlik Sense & Why We Use It !

Lecture 150 Practice Assignment Challenge 19.1

Section 20: Advanced Sales Analysis - Revenue Flows and Relationships

Lecture 151 Welcome to this section. This is what we will develop !

Lecture 152 Functional Specification - Visualizing Revenue Flow

Lecture 153 Create and Colorize a Detailed Sankey Chart

Lecture 154 Practice Assignment 20.1

Section 21: Trend Analysis - Seasonality & Residual

Lecture 155 Welcome to this section. This is what we will develop !

Lecture 156 Functional Specification - Visualizing Seasonality

Lecture 157 Understanding the STL Chart and Functions 101

Lecture 158 Make an addition to the Master Calendar

Lecture 159 Trend , Seasonality & Residual Analysis Line Chart - Part 1

Lecture 160 Trend , Seasonality & Residual Analysis Line Chart - Part 2

Lecture 161 Selectable De-Cluttering the STL Chart

Lecture 162 Practice Assignment 21.1 - Part 1

Lecture 163 Practice Assignment 21.1 - Part 2

Section 22: Why You Should Use Canonical Calendar(s)

Lecture 164 Addressing the Multiple Date Problem

Lecture 165 Alternate State & Canonical Calendars in Action - Part 1

Lecture 166 Alternate State & Canonical Calendars in Action - Part 2

Lecture 167 Practice Assignment Challenge 22.1 - Spec

Lecture 168 Practice Assignment Challenge 22.1 - Solution

Section 23: Forecasting using Linear Regression

Lecture 169 Welcome to this section. This is what we will develop !

Lecture 170 Summary of Pre-Requisites

Lecture 171 Preparing the Fact Data

Lecture 172 Futurize the Master Calendar

Lecture 173 Simple Linear Regression 101

Lecture 174 How is the Regression Expression Coded ?

Lecture 175 Visualize the Forecast for Analysis

Lecture 176 How to Calculate R² (R-Squared)

Lecture 177 Practice Assignment Challenge 23.1

Section 24: Wrap up

Lecture 178 How to Retrieve Your Results Based Training Certificate

Anyone looking for a hands-on, project-based introduction to Qlik Sense,Data analysts and Excel users hoping to learn and develop skills in dashboard design, and business intelligence visualisations,Aspiring data professionals looking to master the best and most technically advanced business intelligence tool on the market,Students who want a comprehensive, engaging, and highly interactive approach to training with lots of practice assignments,Anyone looking to pursue a career in data analysis, analytics or business intelligence