The Complete QlikView Boot Camp
4.5 (3,200 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.
14,363 students enrolled

The Complete QlikView Boot Camp

Learn QlikView for Data Analytics - Designer & Developer step by step. Real-World Data Analytics. Real data included.
Bestseller
4.5 (3,194 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.
14,354 students enrolled
Created by Paul Scotchford
Last updated 4/2020
English
English
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)
Requirements
  • 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 .
Description

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.

Best

Paul


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

Preview 04:02

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
07:24

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

How To Get Your Project Data From Dropbox
08:18

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

Navigating The QlikView Desktop
10:53

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
11:42

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
09:46
Test Yourself
5 questions
+ Data Modelling In QlikView
9 lectures 01:26:20
Introduction to the Associative Model
10:45
The Snowflake Schema
07:22

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
07:55

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
11:49

Why are Loops in the Model BAD ?

Circular Reference (Loops) Break Your Model
10:05

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

Link Table(s) In Your Model - Part 1
08:48

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

Link Tables(s) In Your Model - Part 2
08:55

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
08:40
The Left Join
08:36
The Right Join
07:48
The Outer Join
08:02
Mission Assignment #4 If You Choose To Accept It
06:49
Mission #4 Solution Explanation
07:51

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)
13:43
ETL-1 SQL And The Inline Load (Part 2)
10:17
ETL-1 SQL And The Inline Load (Part 3)
07:54
ETL-1 SQL And The Inline Load (Part 4)
09:14
ETL-2 Loading From Disparate Data Sources (Part 1)
13:08
ETL-2 Loading From Disparate Data Sources (Part 2)
07:15
ETL-3 The Incremental Load (Part 1)
10:44
ETL-3 The Incremental Load (Part 2)
06:31

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

ETL-4 The Slowly Changing Dimension (SCD)
10:52
Mission #5 Solution Explanation
06:06

Check your ETL knowledge

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

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
08:32
Adding Filters & Current Selections Object
12:03
The Combo Chart & Calculated Dimensions
10:33
The Combo Chart & Object Cloning
08:48
Dimension Limiting & Aggregation Scope
08:10
The Pivot Table
08:29
Mission #6 If You Choose To Accept It
02:32
Mission #6 Solution Explanation
07:01

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
13:04
Initial Data Model Load Incl. Mapping Load
12:26
Initial Data Model Load Incl. Concatenated Load
07:01
Initial Data Model Load Incl. Reduced Data Load
06:39

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
06:23

Start coding simple KPI's

Coding A Simple KPI
08:25
Coding a KPI With A Calculation
04:25
Mission Assignment #7 If You Choose To Accept It
01:38
Mission #7 Solution Explanation
06:13

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
09:36
The Straight Table With Drill Down & Cyclic Groups
08:58
The Line Chart With Dual Axes
10:09
The Bar Chart & Classed Data
05:41
The Bar Chart Becomes A Combo Chart
08:17
The Gauge Chart
12:02
The Butterfly Chart (aka Tornado Chart) Part 1
08:29
The Butterfly Chart (aka Tornado Chart) Part 2
10:50
The Scatter Chart
10:57
Mission Assignment #8 If You Choose To Accept It
03:54
Mission #8 Solution Explanation
07:26

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
11:25
Exploiting The Container Object
08:07
Mission #9 Solution Explanation
04:52

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 ?
09:10
Coding KPI's (Part 1)
10:23
Coding KPI's (Part 2)
10:00
Dates, Set Analysis and Charting
11:28
Date Spans In Set Analysis e.g. MTD with MonthStart()
08:29
Date Spans In Set Analysis & The Dual() Function
09:14
Embedding Multiple Functions Inside Set Analysis
14:21
Mission Assignment #10 If You Choose To Accept It
01:44
Mission #10 Solution Explanation
04:35

Did you get through Set Analysis easily ?

Test Yourself
11 questions