The Complete QlikView Boot Camp
4.6 (3,533 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
15,527 students enrolled

The Complete QlikView Boot Camp

Learn QlikView for Data Analytics - Designer & Developer step by step. Real-World Data Analytics. Real data included.
4.6 (3,533 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
15,530 students enrolled
Created by Paul Scotchford
Last updated 4/2020
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 15.5 hours on-demand video
  • 1 article
  • 4 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Handle interview questions with ease
  • Start developing solutions for your company as soon as you have finished this course
  • Receive an achievement based certificate. This is based on your test results so you can show the world your skill levels
  • Understand and apply Associative Data Modelling concepts
  • Learn about different Model Schema types
  • Learn to code Joins & understand how they work
  • Learn how the Associative Data Model is stored internally
  • Learn how to load and connect to different data sources (e.g. SQL, Web )
  • Code Scripts for ETL data processing
  • Learn to code calculations using Set Analysis
  • How to code What-If analysis
  • 14 Assignment projects for hands on practice, followed by Quizzes testing your knowledge
  • Learn charting best practices
  • Learn about advanced calculation functions like Aggr() , Rank() , IntervalMatch()
  • Create Charts such as Gauges, Pie, Bar, Combo, Line, Tornado, Heat Maps, Scatter
  • Learn performance tuning for charts and scripting
  • Add actions and conditions to charts and other objects
  • Apply many of your new skills to QlikSense e.g. Modelling, Set Analysis
  • Over 150 Quiz test questions for you to check your learning progress
  • Real world sample data available for download and analysis
  • Install QlikView 12 (and SQLServer express if you want to connect to sample SQL databases)
  • Want to learn from a rated Top-responding instructor ?
  • Keen to learn QlikView skills or enhance existing QlikView (and QlikSense) skills
  • Have a basic understanding of data concepts
  • Free software installation of QlikView and SQL Server (2014 or later) Express if you want to actually code for practice
  • If you plan to install the Qlik and SQL software then you should be using a Windows PC .

A warm welcome to you.

If you have found yourself in a situation where you need or want to learn QlikView for your job or a career move and do not have the budget to spend thousands for training or you are frustrated with disorganised video clips all over the internet, then this course is definitely for you.

This course is also available via Udemy For Business (UFB) .

Once you have completed this course you can hit the ground running at work when your team leaders , users, managers want you to deliver an analytics solution fast.

This course is packed with sample data that you can download , project assignments and quizzes for you to practice and test your new skills and what's more you don't need to do 2 separate courses for Designer or Developer it's all here in the one course and I am adding new content frequently which means you have life time access to a rich source of information and tuition that will never get out of date.

What's more, this course has been recorded in 1080p HD , HD Sound and features Closed Captions [CC].

Do you like what you see so far ?  

Then don't wait, enrol in this course and get a head start with the latest version(12) QlikView, and with a 30 day money back guarantee , nothing to lose, right ?

I am looking forward to helping you gain new skills during this course.


Data Analyst and Visualisation Engineer

Who this course is for:
  • Anyone that wants to learn QlikView from scratch and get productive at work quickly
  • Supplement your learning towards certification
  • Analytics Prоfеѕѕiоnаlѕ
  • Developers looking to supplement what they already know about QlikView
  • BI/ETL/DW Professionals
  • Prоjесt Managers
  • Job seekers looking to answer tough interview questions (e.g Describe the Symbol Table Types ?)
  • Tеѕting Prоfеѕѕiоnаlѕ
  • Buѕinеѕѕ аnd Rероrting рrоfеѕѕiоnаlѕ
  • Grаduаtеѕ building a career in data Visualisation & Anаlуѕiѕ
  • Business Analysts
  • QlikSense Developers and Users (supplement your skills with QlikView skills such as Set Analysis)
Course content
Expand all 114 lectures 15:16:12
+ Your QlikView Journey Begins Here
8 lectures 58:35

Course structure information and general UI guidance e.g. Screen Resolution, Closed Captions etc

Preview 01:48

This presentation will step you through the download and install for QlikView personal edition

Download And Install QlikView Personal Edition Software

Download and Install SQL Server Express (Free Software) , this is optional but highly recommended if you want to use real data in building your QlikView applications.

Download And Install SQL Server Express

How to download a SQLServer database backup file from Dropbox and restore to the SQLServer instance.

How To Get Your Project Data From Dropbox

A quick overview of the QlikView desktop (IDE - Integrated Development Environment)

Navigating The QlikView Desktop

Jump right in and start getting a feel for the tool-set using built in wizards ...

You will learn how to (and more)  ...

  1. Create a sheet
  2. Create a simple data load script    (Wizard)
  3. A chart with a simple aggregation  (Wizard)
  4. View the model

Create Document Content Using Wizards

Your chance to test your knowledge so far be creating your own QlikView document (Solution is included in lecture after a short break)

Mission Assignment #1 If You Choose To Accept It
Test Yourself
5 questions
+ Data Modelling In QlikView
9 lectures 01:26:20
Introduction to the Associative Model
The Snowflake Schema

Your chance to test your knowledge so far be creating your own QlikView document (Solution is included in lecture after a short break)

Mission Assignment #2 If You Choose To Accept It

The appearance of the Synthetic Key means you have a flawed model design, so let's examine why and how to fix it.

The Synthetic Key And Your Model

Why are Loops in the Model BAD ?

Circular Reference (Loops) Break Your Model

Identify candidate keys in the model that can be used as Link Table keys. 

Link Table(s) In Your Model - Part 1

Introducing Resident loads to populate the Link Table and how to change the model metadata

Link Tables(s) In Your Model - Part 2

Your chance to test your knowledge so far be creating your own QlikView document (Solution is included in lecture after a short break)

Preview 10:32
Test Yourself
5 questions
+ Coding Joins In The Script
6 lectures 47:46
The Inner Join
The Left Join
The Right Join
The Outer Join
Mission Assignment #4 If You Choose To Accept It
Mission #4 Solution Explanation

Recap of this section, what have you remembered ?

Test Yourself
5 questions
+ Scripting The ETL (Extract, Transform, Load)
12 lectures 01:42:35

Part 1 of Extracting data from a SQL Database and logging the process

ETL-1 SQL And The Inline Load (Part 1)
ETL-1 SQL And The Inline Load (Part 2)
ETL-1 SQL And The Inline Load (Part 3)
ETL-1 SQL And The Inline Load (Part 4)
ETL-2 Loading From Disparate Data Sources (Part 1)
ETL-2 Loading From Disparate Data Sources (Part 2)
ETL-3 The Incremental Load (Part 1)
ETL-3 The Incremental Load (Part 2)

What is and why do we use Slowly changing dimensions (virtually everywhere)

ETL-4 The Slowly Changing Dimension (SCD)
Mission #5 Solution Explanation

Check your ETL knowledge

Test Yourself
13 questions
+ Develop Your First Dashboard
10 lectures 01:26:05
Getting Started

A overview of the commonly used aggregations in QlikView, this is only a demonstration and we get into more detail on aggregations as we proceed forward, for now you can just sit back and watch the lecture without worrying about code.

Basic Aggregations Overview
Adding Filters & Current Selections Object
The Combo Chart & Calculated Dimensions
The Combo Chart & Object Cloning
Dimension Limiting & Aggregation Scope
The Pivot Table
Mission #6 If You Choose To Accept It
Mission #6 Solution Explanation

What do you remember about our first foray into solution development

Test Yourself
14 questions
+ Preparation For Your Enterprise Solution Development
4 lectures 39:10

Certain chart types are best used for specific visualisation requirements. 

Visualisation Best Practices
Initial Data Model Load Incl. Mapping Load
Initial Data Model Load Incl. Concatenated Load
Initial Data Model Load Incl. Reduced Data Load

Are you clear about Mapping,Concatenated and Reduced data loads ?

Test Yourself
11 questions
+ The KPI
5 lectures 27:04
A Conversation Around Metrics & KPI's

Start coding simple KPI's

Coding A Simple KPI
Coding a KPI With A Calculation
Mission Assignment #7 If You Choose To Accept It
Mission #7 Solution Explanation

Are you happy you understand KPI's ?

Test Yourself
6 questions
+ Explore And Develop Charts
11 lectures 01:36:19
The Straight Table And The Mini Chart
The Straight Table With Drill Down & Cyclic Groups
The Line Chart With Dual Axes
The Bar Chart & Classed Data
The Bar Chart Becomes A Combo Chart
The Gauge Chart
The Butterfly Chart (aka Tornado Chart) Part 1
The Butterfly Chart (aka Tornado Chart) Part 2
The Scatter Chart
Mission Assignment #8 If You Choose To Accept It
Mission #8 Solution Explanation

Are you happy with you understanding of charts

Test Yourself
13 questions
+ Implement An SCD Type 2 In Our Solution
4 lectures 26:10
The IntervalMatch() Function
Exploiting The Container Object
Mission #9 Solution Explanation

Did you understand the points from this section ?

A Quick Quiz
5 questions
+ Understand And Code Set Analysis
9 lectures 01:19:24
What Is Set Analysis ?
Coding KPI's (Part 1)
Coding KPI's (Part 2)
Dates, Set Analysis and Charting
Date Spans In Set Analysis e.g. MTD with MonthStart()
Date Spans In Set Analysis & The Dual() Function
Embedding Multiple Functions Inside Set Analysis
Mission Assignment #10 If You Choose To Accept It
Mission #10 Solution Explanation

Did you get through Set Analysis easily ?

Test Yourself
11 questions