Certificate in QlikSense Analytics Development
4.5 (309 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,515 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Certificate in QlikSense Analytics Development to your Wishlist.

Add to Wishlist

Certificate in QlikSense Analytics Development

Scenario based QlikSense app development training using real business data examples for visual data analysis!
4.5 (309 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,515 students enrolled
Created by Paul Scotchford
Last updated 5/2017
Learn Fest Sale
Current price: $10 Original price: $40 Discount: 75% off
11 hours left at this price!
30-Day Money-Back Guarantee
  • 13.5 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Take the first steps to becoming a data visualisation engineer
  • Fully downloadable content for offline viewing
  • 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
  • Write the expression code to implement your 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)
View Curriculum
  • Want to learn data analysis and data visualisation
  • Get on board with scalable data visualisation technology
  • Keen to escape excel confusion
  • Download QlikSense (I show you in the course) as you will develop apps during the course
  • Don't have a Win PC, no problem, develop in the cloud

Certificate in QlikSense data visualisation and analytics application development

Data Science and Analytics is the hot new career choice of today, but we still need an efficient and timely method to visualise what we have discovered in the morass of data in 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. 

If you want a hands on approach to learning QlikSense and a certificate that showcases your technical ability then this is the only course that offers this.

QlikSense is the next generation of QlikView.

QlikSense 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 certain 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 your work flow and creativity.

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

What you learn in this course is transferable to QlikSense Enterprise.



Who is the target audience?
  • Anyone can take this course
  • Anyone that wants an alternate to Excel
  • Anyone, business owners, aspiring data analysts, students, teachers, users
  • Data visualisation engineers and analysts
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 73 Lectures Collapse All 73 Lectures 13:27:35
Introduction to the course
4 Lectures 18:14

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

Step by Step guide to the download and install of the latest version of QlikkSense

Preview 03:50
The Language
1 Lecture 06:09

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

Preview 06:09

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 

Introduction to navigating the QlikSense hub

Testing your general QS introductory knowledge

QlikSense 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
Stock Performance
8 Lectures 01:57:24

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.

Start Learning About Associative Data Modeling

Load the new data and learn how to fix synthetic keys and circular references (data loop).

How to handle synthetic keys and circular references

Review the new data on a sheet and learn how to create a master item inside the model viewer. Lets start thinking about data integrity and how to check it.

I will also teach you to create a Hierarchical dimension for drill-down filtering.

Introducing the hierarchical dimension

Analyse stock level performance via a new sheet with more practice around conditional expressions. Now we will understand the use of Distinct when counting stock levels.

Lets look at counting data values

Test your basic model and data integrity knowledge

What have you learned about data so far
16 questions

Lets look at conditional formatting and then start to look at the Primary/Secondary axis on a chart and why we need to use these from time to time.

How to do conditional formatting

Creating a calculated dimension in prep to set limitations.

How to create a calculated dimension

Test your knowledge of dimensionality and recall

Dimensions and other ideas
14 questions

A quick look as to the effects of orphaned data, then getting started with Set Analysis.

Getting started with Set Analysis

Build up our knowledge by introducing date manipulation to Set Analysis.

Understand and use Set Analysis

Test your basic Set Analysis knowledge

Check your Set Analysis status
14 questions
Online customer sales analysis
10 Lectures 01:58:32

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, Pareto analysis
8 Lectures 01:15:58

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 the heck is a star and snowflake schema ? Here I shall explain the model methodology used in QlikSense (indeed this is the same as QlikView)

Data modelling 101 in QlikSense

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 sheet

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 47 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
P & L and variables
7 Lectures 01:36:52

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.

What is a variable and how do we use them in QlikSense ?

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 do I handle delimited strings in variables ?

Double check your knowledge did not miss anything

Double check
12 questions
Tips and Tricks (Bonus lectures)
15 Lectures 02:38:54

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.

Preview 12:03

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.

Using the Peek function to look at data

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.

What is governance ?

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
How to retrieve your Certificate
1 Lecture 00:00
About the Instructor
Paul Scotchford
4.5 Average rating
1,336 Reviews
21,758 Students
3 Courses
Data Analyst and Qlik Development Specialist


I have been a Data Analyst/Engineer for over 20 years specialising in SQL Data Analysis and Development.

I am also an experienced developer in data visualisation using QlikView and QlikSense and my work is predominantly in consulting and specialist analysis projects.

I do have a passion for sharing knowledge with anyone that is interested and wants to learn more about the field of Data Engineering, Visualisations and Quantitative Analysis.

Check out my best value low cost courses, cost should never be a barrier to learning. 

Keep in touch.