Name: The Complete QlikView Boot Camp
Rating: 4.7 (7316 reviews)

Udemy Business

Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Created byPaul Scotchford

Last updated 3/2026

English

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)

Course content

16 sections • 115 lectures • 15h 4m total length

Course Introduction1:48
What's in this course ? A lot !
Download And Install QlikView Personal Edition Software (See resources link)3:18
This presentation will step you through the download and install for QlikView personal edition
The software is contained in the resources dropdown list, just click the link to download QlikView installation software.
Download And Install SQL Server Express6:22
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.
Get Your Data from Dropbox and Restore the Insurance Database8:13
How to download a SQLServer database backup file from Dropbox and restore to the SQLServer instance.
Features Available During Lecture Playback4:35
Discover playback features for this course, including Q&A, notes, announcements, reminders, and resources, plus video controls, captions, transcripts, and a beta AI assistant.
Navigating The QlikView Desktop10:28
A quick overview of the QlikView desktop (IDE - Integrated Development Environment)
Create Document Content Using Wizards11:27
Jump right in and start getting a feel for the tool-set using built in wizards ...

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

Create a sheet
Create a simple data load script (Wizard)
A chart with a simple aggregation (Wizard)
View the model
Homework Assignment 1.19:42
Your chance to test your knowledge so far be creating your own QlikView document (Solution is included in lecture after a short break)
Test Yourself

Introduction to the Associative Model10:29
Explore the Qlik associative data model, its dynamic associations and color cues, contrast it with relational modeling, and model data with the kicks engine toward star or snowflake schemas.
The Star Schema9:55
Master the star schema, a model with a fact table and one or more dimension tables, where measures describe events and dimensions define attributes such as products and calendar.
The Snowflake Schema7:20
Explore how the snowflake schema connects a postal code dimension to a surrogate key within a star schema, enabling richer member locations and streamlined reporting in QlikView.
Homework Assignment 2.17:49
Your chance to test your knowledge so far be creating your own QlikView document (Solution is included in lecture after a short break)
The Synthetic Key And Your Model11:45
The appearance of the Synthetic Key means you have a flawed model design, so let's examine why and how to fix it.
Circular Reference (Loops) Break Your Model9:53
Why are Loops in the Model BAD ?
Link Table(s) In Your Model - Part 18:18
Identify candidate keys in the model that can be used as Link Table keys.
Link Tables(s) In Your Model - Part 28:50
Introducing Resident loads to populate the Link Table and how to change the model metadata
Homework Assignment 2.210:23
Your chance to test your knowledge so far be creating your own QlikView document (Solution is included in lecture after a short break)
Test Yourself

The Inner Join8:37
Explore how to load two tables in QlikView to form a 1-to-1 relationship on member key, filtering nonmatching records and reducing the data set.
The Left Join8:31
Demonstrates a left join between the member table and employer contributions to show all members and any contributions, enabling profiling analytics of contributors versus noncontributors.
The Right Join7:43
Discover how a right join reveals orphans by returning all rows from unpaid claims and matching member data, with nulls where no member exists, highlighting data governance.
The Outer Join7:58
Learn how outer joins profile messy enterprise data by combining user data with member cover data, surfacing matches and missing values in QlikView.
Homework Assignment 3.15:21
Restore the e-commerce database, then build left join and inner join in QlikView to observe product, supplier, customer, and geolocation data, reloading and displaying results in tables.
Homework Assignment 3.1 Solution7:38
Connect to sql server in the load editor, load products and suppliers, apply a left join, then build a customer location dataset with an inner join to geolocation for etl.
Test Yourself

What IS ETL Exactly ?4:13
Learn the ETL process: extract, transform, and load within an enterprise server environment, building scripts that generate QVD files for QlikView and Qlik Sense, with data conformance and security considerations.
ETL-1 SQL And The Inline Load (Part 1)13:41
Part 1 of Extracting data from a SQL Database and logging the process
ETL-1 SQL And The Inline Load (Part 2)10:15
Create and load a log file that tracks the ETL stats
ETL-1 SQL And The Inline Load (Part 3)7:52
Introducing the Script Debugger Tool
ETL-1 SQL And The Inline Load (Part 4)9:08
Examining the concept of $Expansion
ETL-2 Loading From Disparate Data Sources (Part 1)12:28
Get familiar with the Binary Load feature
ETL-2 Loading From Disparate Data Sources (Part 2)7:12
Web Page scraper and other data loads
ETL-3 The Incremental Load (Part 1)10:42
Learn how to perform incremental loads in QlikView by loading current QVD data, extracting the max order date, and blending new data into the existing model.
ETL-3 The Incremental Load (Part 2)6:30
Explore incremental loads in QlikView, building and formatting z temp tables, merging online sales data into a fact table, and storing to QVD with logging for reliable ETL.
ETL-4 The Slowly Changing Dimension (SCD)10:47
What is and why do we use Slowly changing dimensions (virtually everywhere)
Homework Assignment 4.11:41
download the Google Analytics database from Dropbox and build a QVD file ready for consumption in the QlikView boot camp, using the site visits log from the ETL data source.
Homework Assignment 4.1 Solution5:58
Restoration of the Google Analytics Database & Extract to a QVD file ready for the start of development
Test Yourself

Introduction to What's Ahead11:16
What are we developing in this section.
Start loading the Google data here via the Load Script Editor
QlikView Basic Aggregations8:28
Note: There is no data for this lecture as this is a simple overview of what we will expand on in upcoming lectures!
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.
Create Filters and a Current Selections Box12:01
Highlight the user selections
The Combo Chart with Calculated Dimensions10:30
Expression sort , what's that ?
The Combo Chart with Object Cloning8:46
Copying charts via Cloning and colour coding chart metrics
Dimension Limiting with Aggregation Scope8:10
Limiting the number of rows for the dimension on a chart object and set the scope of the aggregation
Conditional Colour Coding8:50
Changing the colour of a metric based on a value (condition)
The Pivot Table8:30
An elegant table that also features colour coding without writing if() tests
Homework Assignment 5.12:18
Load the new browser tracking data into your QlikView model using the load script and build a block chart of browser usage frequency. Investigate concatenated load to fix the anomaly.
Homework Assignment 5.1 Solution7:00
Explore how to load and align browser stats with site visits in QlikView using concatenated load, creating a block chart of browser popularity by year and month.
Test Yourself

Data Visualization Best Practice13:04
Certain chart types are best used for specific visualization requirements.
It should be noted that if a user(s) has a specific chart request; we as devs should not dismiss their reason for the chart in favour of best practice!
Initial Data Model Load Incl. Mapping Load11:56
Load the data model ready for serious development work
Initial Data Model Load Incl. Concatenated Load6:52
Load and concatenate inventory data to online sales in QlikView, append-like to handle granularity, fix the date key, build a dim calendar, and trim calendar data to min/max order dates.
Initial Data Model Load Incl. Reduced Data Load6:34
How do you reduce the data set to align with another sets range ?
Test Yourself

All About Metrics & KPI's6:16
Discover the difference between metrics and KPIs and learn to set smart, measurable targets with a clear time scale, aligning analytics with business goals in qlikview.
How to Code a Simple KPI8:29
Start coding simple KPI's
Coding the KPI to Show Difference in Value4:25
Create a new KPI that shows the difference between two values providing valuable insight to the user
Enhance this with conditional colouring
Homework Assignment 7.11:20
Enhance the KPI by adding a header such as sales amount, bolding the text, applying a background color, and creating a new KPI for the percentage of target achieved.
Homework Assignment 7.1 Solution6:12
Solution demo plus a simple hack for formatting numbers
Test Yourself

The Straight Table And The Mini Chart9:42
Enhance the straight table with miniature charts
Adding Drill Down & Cyclic Groups to the Straight Table8:58
Explore how to create drill-down and cyclic groups in QlikView, building a product category drill-down and enabling quick field flips for insightful visualization.
The Line Chart With Dual Axes10:08
This lecture demonstrates building a line chart with dual axes to plot sales and budget targets over time, including a sales percent to target line and readability tweaks.
The Bar Chart with Classed (Discretized) Data5:40
Explore bar chart construction and discretize data with the class function to create yearly income groups using a 15,000 interval, then analyze distinct customer counts by group.
Converting the Bar Chart to a Combo Chart8:09
Convert the bar chart to a combo chart that combines bars and lines. Add a percent sales share, switch to a dual axis, and validate calculations with a debug sheet.
How to Utilize a Gauge Chart12:01
Create a gauge chart to show progress toward a target in QlikView. Configure min and max, color segments, show labels, and display the percent difference.
How to Make a Butterfly Chart (aka Tornado Chart) Part 110:14
Making a non standard (et popular) chart from 2 bar charts
How to Make a Butterfly Chart (aka Tornado Chart) Part 210:47
Learn to build a butterfly chart in qlikview by flipping the gender expression to display female values, with popups and sorting by expression.
The Scatter Chart10:56
Learn to create scatter charts in QlikView to visualize distribution and correlation, including positive, negative, and no correlation, using income groups and margins with bubbles to reveal patterns.
Homework Assignment 8.13:35
A fair size project with great opportunity to refine your skills with script enhancement and chart creation
Homework Assignment 8.1 Solution7:25
Explore the homework assignment 8.1 solution by editing the data load editor, adding a kids at home class, and applying a margin analysis in QlikView with proper order of precedence.
Test Yourself

How the IntervalMatch() Function Helps With Time Series Data11:19
Slowly Changing Dimensions influenced by time
Exploiting The Container Object7:57
When your sheet has too many charts to show, we use a container object to allow the user to decide on the chart they want!
Homework Assignment 9.11:27
A Chance to practice adding different objects to a new sheet and calculation of a metric utilizing currency type
Homework Assignment 9.1 Solution4:50
Explore the solution to assignment 9.1, showing how to build list box and table box for currency name and history, and to calculate US dollars from end of day rates.
A Quick Quiz

Set Analysis an Overview (Primer)9:10
A concept overview to Set Analysis, the umbrella term used for the coding of Set Expressions in QlikView
Code a KPI Set Expression (Part 1)10:23
Explore set analysis to code a KPI for audio sales and compare set expressions with standard tests. Learn to override current selections with modifiers, aggregate using sum, and format dollars.
Code a KPI Set Expression (Part 2)10:00
We'll explore a very cool feature where we can access user actions e.g. Previous and Forward selections
Using Date Based Set Expressions In Charts11:19
The power of using Date search in Set Expressions
Spanning Date Ranges In Set Expressions Using Date Functions8:27
Using Date functions in set expressions to search for dynamic date ranges
Simple Set Expression for YTD Line Charts9:10
Using Dual() to set Number and String values in the same field simultaneously
Create a Set Expression to Compute Rolling 3 Month Sales14:22
How to create a set expression to dynamically rolls dates by 3 months based on the user selections
We will also work with multiple date functions in a single set expression
Homework Assignment 10.11:27
Build set analysis dashboards in QlikView to display all time sales that persist, year to date sales sensitive to year selections, and a previous year chart unaffected by months.
Homework Assignment 10.1 Solution3:29
Explore set analysis in QlikView by building metrics like all time sales and year to date sales, ignoring selections and computing previous year to date, with practical tips and troubleshooting.
Test Yourself

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
Some resources maybe located on Dropbox or GitHub due to file size constraints
If you plan to install the Qlik and SQL software then you should be using a Windows PC .

Description

Please note, some of the resources in this course are located on Dropbox or GitHub, hence you will need to use the supplied URL to download files e.g. Software

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.

Paul

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)

What you'll learn

Explore related topics

Course content

Your QlikView Journey Begins Here8 lectures • 56min

Data Modelling In QlikView9 lectures • 1hr 25min

Coding Joins In The Script6 lectures • 46min

Scripting The ETL (Extract, Transform, Load)12 lectures • 1hr 40min

Develop Your First Dashboard10 lectures • 1hr 26min

Preparation For Your Enterprise Solution Development4 lectures • 38min

The KPI5 lectures • 27min

Explore And Develop Charts11 lectures • 1hr 38min

Implement An SCD Type 2 In Our Solution4 lectures • 26min

Understand And Code Set Analysis9 lectures • 1hr 18min

Requirements

Description

Who this course is for: