Certificate in Qlik Sense Analytics Development
4.3 (2,979 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.
12,637 students enrolled

Certificate in Qlik Sense Analytics Development

Scenario based Qlik Sense App development training using real business data examples for visual data analysis
4.3 (2,979 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.
12,637 students enrolled
Created by Paul Scotchford
Last updated 7/2020
English [Auto]
Current price: $121.99 Original price: $174.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 13 hours on-demand video
  • 11 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
  • Take the first steps to becoming a data visualisation engineer
  • Fully downloadable content for offline viewing (Copyright applies)
  • Identify KPI's,metrics and dimensions from your business requirements
  • Design and build data visualisations and enhance them with extensions
  • Understand the associative model and how to load data to it
  • Resolve data integrity and modelling issues
  • Code expressions for metrics and dimensions
  • Source code for all apps used in course creation
  • Will have hands on experience
  • Develop and share apps in the cloud (for free)
  • Want to learn from a rated Top-responding instructor (Yes, I answer Q&A within 24 hours or less!) ?
  • Keen to learn new and enhance your skills
  • Basic understanding of data concepts
  • Keen to escape excel confusion and small data
  • Free software installation of QlikView and SQL Server Express if you want to actually code for practice
  • Don't have a Win PC, no problem, develop in the cloud

This course is also available on Udemy For Business  

Certificate in Qlik Sense data visualisation and analytics application development

Data Scientists,Data Analysts are hot career choices today, but we still need an efficient and timely method to visualise what we have discovered in the morass of data within our enterprise. 

Thankfully we have the Qlik suite of products to help us with this and my all time favourite is QlikSense, I liked it so much, I took a leave of absence for 3 months to develop this course (and it is continually updated to stay current). 

If you want a hands on approach to learning Qlik Sense and a certificate that showcases your technical skill then this is the only course to take.

Qlik Sense is the next generation of QlikView.

Qlik Sense is overtaking so many of it's peers because of it's underlying 'associative data model' technology and absolute ease of discovery for insightful decision making and story telling

I am sure that once you have completed this course you will not want to revert to the old clunky ways of surfacing your analytics like you did with those products from the older monolithic vendors that will always impose their ways to suppress your work flow and creativity.

This course of study is designed to transition your skills into a deep understanding of Qlik Sense application development.

The skills that you learn in this course is 100% transferable to QlikSense Enterprise and Qlik Sense Cloud.

Looking forward to seeing you in the course.


Data Analyst and Visualisation Engineer

Who this course is for:
  • Anyone that wants to learn QlikSense 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 QlikSense
  • BI/ETL/DW Professionals
  • Prоjесt Managers
  • Job seekers looking to answer tough interview questions
  • 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
  • QlikView Developers and Users
  • Data Scientists looking for alternate visualisations
Course content
Expand all 77 lectures 13:15:05
+ Course Objectives
4 lectures 27:16

What will you learn in this course ? stay tuned I will explain in this video.

Preview 03:33

Please take note regarding how to control video quality at the beginning of this lecture, all lessons are 1080p and require you to select Auto (see bottom right corner of the player, click the gear wheel) to view in 1080p if you experience problems please report these to Udemy as they are the supporters of the HSL/Adaptive streaming tech..

Lessons can be viewed at 720p as well.

As the course immerses you into a real world Enterprise with accompanying data, and if you have not covered some business basics previously, this lecture will help provide a basic overview of why enterprises have a Business Plan, especially for setting goals and targets (KPI's) to achieve during the business journey.

Our startup needs a business plan, but what is it meant to do ?

Test your knowledge of the Business Plan

Business Planning
11 questions

A few points to know about QlikSense before we download the software.

Preview 02:28

How to download (Latest version Qlik Sense) , install and register your QlikSense free trial

Download , Install & Register Qlik Sense
+ The Language
1 lecture 06:09

Learn what Metrics and KPI's are and how to be SMART about them.

Metrics and KPI's what are they ?

Testing your understanding of terms used in Analytics

The language
13 questions
+ Budgeting and KPI (goal) setting
10 lectures 01:52:15

QlikSense has created some new folders for you, lets explore them and discover where to download the data for this section. I will walk you through the data structures too.

Please locate the resources button to download the materials you need for the lectures in this section.

Where to find everything ?

A quick tour of the QlikSense Hub, this is the nerve centre of your apps 

Preview 12:14

Testing your general QS introductory knowledge

Qlik Sense overview
14 questions

A brief discussion about Dimensions and Measures as we use these throughout the course.

At this point you can quickly skip to Modelling 101 in Lecture 45 to cover more on data modelling of the QlikSense model schema, but it may be worth waiting as the lectures are building you up to that point.

Preview 04:09

Test your understanding of dimensions and measures

Dimensions and measures
9 questions

A very quick look as to how to create your first App in QlikSense, yes its very easy.

Create your first application (App)

This is your first experience to loading data into QlikSense.

With a brief overview of the data model and how tables are associated. (Rev for QlikSense 2.2.3 Feb16)

The first data load

Test your knowledge on data loading

Import and load data
15 questions

What is a pivot table, how to create one to review our loaded data.

Create a Pivot table

Test your knowledge of the Pivot table functionality

Using the pivot table for data review
10 questions

Explore combo and line charts, and learn about expression sorts.

Creating charts and expression sorts

Using the #1KPI object to display our budget targets.

How to create and use a KPI object

Learn to create and use filters, filters are used during your journey of data discovery.

Year and month filter objects

Review what we learned in Section 3, with a brief look at calculation expressions.

Review the section and personalize the App

Test what else you discovered in this chapter

Overall review of this chapter
15 questions
+ Some Data Science For Sales Performance
9 lectures 01:42:17

Please locate the resources button to download the materials you need for the lectures in this section.

Here I will explain the new data and the loading of it, with a review of the model.

Loading new sales data to the model

Create a new sheet with filters and a pivot table to review our new Sales data.

Learn about table options and formatting.

Review and check the sales data

Learn about Master Items, Conditional expressions and more as you build up the Sales Performance sheet.

Learn about Master Items and start using count()

Test your knowledge of expressions

Basic expressions for calculating measures
17 questions

Let's start to build a GP Analysis sheet and practice your conditional expressions to display interesting values on KPI objects.

Changing the scope using conditional expressions

Adding value to the GP Analysis sheet by calculating variances etc, and more about Master Items.

More advanced expressions to calculate a variance

Add some pertinant charting to the GP Analysis sheet with a scatter plot and treemap.

How to Visualise Correlation

Testing your interpretations

Lateral thinking
16 questions

Present the audience with more information and formatting on a pivot table.

Adding more features to the Pivot table

Test your expertise so far

Think you're an expert yet ?
13 questions

How to setup for using maps to visualize the global Sales performance, here we touch on the "Data load editor" to create a GeoKey.

Geo Analysis (Part 1)

Let's play with some mapping now that we have set up the model.

Geo Analysis (Part 2)

Test your map and general knowledge

Maps and other items
12 questions
+ Inventory Analytics
10 lectures 01:34:36

Please locate the resources button to download the materials you need for the lectures in this section.

I will detail the new data structures and introduce you to a compound key for the newly added fact table.

A conversation about the data we shall use for this section

Load the new data and learn how to fix synthetic keys 

Loading data and how to fix synthetic keys and circular references

How to fix Circular References, these really need to be avoided in your model

Loading data and how to fix circular references

Test your basic model and data integrity knowledge

What have you learned about data so far
16 questions

Explore creating sheet objects such as Straight Tables and drill down dimensions

Creating a straight table and hierarchical drill down dimensions

Coding measures within KPI objects

Creating KPI objects and coding measures

Combo charts and Set Analysis 

Creating combo charts and a conversation about coding Set Analysis

Test your knowledge of dimensionality and recall

Dimensions and other ideas
7 questions

Getting your head around Set Analysis - It's so powerful

Preview 12:16

Conversation around Set Modifiers

A continuation of our coding Set Analysis conversation

Hands on coding Set Analysis for you to practice on

Coding Set Analysis for measures (Part 1)

Practice makes perfect with some lateral thinking

Coding Set Analysis for measures (Final)

Test your basic Set Analysis knowledge

Check your Set Analysis status
14 questions
+ Online Customer Sales Analytics
10 lectures 01:56:57

In this series of lectures we will be using new data that spans 2 years (TY/LY) for analysis,

Please locate the resources button to download the materials you need for the lectures in this section.

I will discuss the new data structures and tables in here.

Overview the tons of new stuff in this section

Test your knowledge on data loads

Brace yourself, things are getting more advanced
8 questions

Load and review our data, but how do we merge multiple year files together, here you will learn more about interacting with the "Data load editor" with some cool short cuts and optimisations for data loading.

Make a new model and merge like file structures

Learn how to discretise data using the Class() function and a flags method.

How to discretize data for analysis (Market Segmentation)

Test your knowledge of banding

What of banding,discretization,bucketization
7 questions

How to create a data table from existing model data that will become a disassociated table (Why is this not good but can be useful ? )

Here you will learn more about interacting with the "Data load editor"

Understand what Resident loads are

Digging more into the code for this table.

What is the Lookup() function ?

Test your knowledge on more data topics

Data islands and loads
20 questions

Back to visualizations now and lets build a sheet for the discretisations and we'll also apply conditional formatting.

Start creating our visualizations with discretized data (Market Segmentation)

Advanced counting using Sum, Aggr() function and TOTAL.

The lecture goes into detail how to create a count of customer registrations by month.

Using Sum(), Aggr() and TOTAL for advanced counting explained

Using advanced counting on your sheet and discuss the testing process for this.

Surface and test the advanced counting

Test what you learned in Advanced counting

Advanced counting
7 questions

Lets review what we have learned in this section and visualize this on a dashboard sheet.

Bringing it all together on a dashboard sheet

Adding maps to the final dashboard sheet.

Enhance the dashboard sheet with mapping
+ Payroll Analytics and Pareto analysis
9 lectures 01:20:39

Please locate the resources button to download the materials you need for the lectures in this section.

I will discuss the new data structures and tables in here.

Introducing Payroll with some cool new functions

What is a star and snowflake schema ? Here we explore the model methodology used in QlikSense (indeed this is the same as QlikView)

Data modelling 101 in Qlik Sense

Test your data modelling competence

Data modelling 101
15 questions

Build up a detailed Payroll data analysis sheet. More on conditional formatting and hiding sensitive data elements from display.

Create a data analysis review sheet (Pt 1)
Create a data analysis review sheet (Pt 2)

80/20 analysis is used quite extensively in Retail (Sales,Inventory,Payroll and so on) , how do we do it in QlikSense ?

Let's look at RowNo(), Above() and RangeSum() the building blocks to this example.

Combining functions the RowNo(), Above() and RangeSum() for 80/20 analysis

Let's use the functions from Lecture 49 and explore Pareto analysis (80/20 analysis).

How to do 80/20 analysis (Pt 1)

Explore pivot table conversion to a combo chart for Pareto analysis.

How to do 80/20 analysis (Pt 2)

Convert the combo chart to a scatter chart, but observe an interesting feature.

How to do 80/20 analysis (Pt 3)

Review what we have learned in this section and visualize this on a dashboard sheet.

Bringing it all together

Test what you know about the Pareto we built

Final for section
15 questions
+ Profit and Loss including the magic of variables
8 lectures 01:41:41

In this series of lectures we will be using new data for General Ledger analysis.

Please locate the resources button to download the materials you need for the lectures in this section.

I will discuss the new data structures and tables in here.

Lets explore another example of a compound key

Snap to it

Keys quickly
3 questions

Explore what variables are and how to create and use them in QlikSense.

How to use the debug feature in QlikSense.

Preview 07:29
What is a variable and how do we use them in QlikSense (Part 2) ?

Test your knowledge of using variables

The magic of variables
12 questions

Using variables to compute dates.

Setting variables with date functions

This lesson teaches you how you can use variables within Set Analysis and other places, which is pretty handy as you don't have to constantly recode the same calcs over and over.

Using variables in Set Analysis

Start using variables in your dashboard sheet and understand $ Expansion.

Replacing simple expressions with expression variables

Let's play with using colour expressions in variables and explore multi line expressions created in the load editor for a variable

Embed conditional formatting expressions in variables

How do you embed a delimited expression into a variable , this is common in Set Analysis based variables.

How to code string delimiters in a variable ?

Double check your knowledge did not miss anything

Double check
12 questions
+ Tips and Tricks (Bonus lectures)
15 lectures 02:32:15

Let's explore Bookmarks and Story telling.

Please locate the resources button to download the materials you need for the lectures in this section.

How to create a bookmark and start on your story
How to create your story

How to share your story with others.

How to share your story with others

Explore the different ways to export data from QlikSense.

Exporting data from QlikSense

Connect to a SQLServer database and scrape data from web sites.

Connect and extract data from a SQL Server database

Learn how to connect to a web page and extract the data from it.

Connect to and extract data from a web page

Test your knowledge on enhancing the user experience

On tips and other aspects
16 questions

Reducing your calendar data requirements dynamically.

Preview 12:19

I demonstrate using raw scripting in the data load editor for generating your own calendar from scratch.

Using a script to load a raw calendar

Test your knowledge around the Calendar

Lets date
10 questions

How to integrate d3 visualizations (Extensions) and create word cloud for use on your sheet.

How to integrate d3 visualisations
How to add a word cloud to your sheet
How to link to other sheets in the App, and how to link to external URLs.
Linking to sheets and external URL's

Test your knowledge on the value of app extensions and some past subject matter

App extensions
7 questions

A hot topic today in BI&A is data governance, here you will be introduced how to provide and implement it.

Preview 10:49
How do I implement governance ?

Do you have a basic idea of the principals of Governance

10 questions

Earlier in Section 5 we uncovered a data anomaly and you were tasked with debugging it, here is the answer to the problem.

The answer to the inventory problem

Did you get down to the culprit causing the null row displays ?

The inventory anomaly
1 question

I will show how super easy it is to create mashups using objects from your apps to present on a new web page to really impress your users, team and manager(s). (Rev for QlikSense 2.2.3 Feb16)

How to create mashups in QlikSense

Test your knowledge about creating a mashup

17 questions