Certificate in Qlik Sense Analytics Development

Real world data scenarios for Qlik Sense app development
Certificate in Qlik Sense Analytics Development
File Size :
5.74 GB
Total length :
13h 52m



Paul Scotchford


Last update

Last updated 9/2022



Certificate in Qlik Sense Analytics Development

What you’ll learn

Business Intelligence & Analytics development
Skills needed to become a data analytics & visualisation engineer
Identify KPI’s,metrics and dimensions from your business requirements
Design and build data visualisations using key Qlik Sense features
Understand the associative data model and how to load data to it
Resolve data integrity and modelling issues like synth keys and circular references
Code expressions for metrics and dimensions, we learn set analysis coding too
Explore downloadable source code & data during your development work here

Certificate in Qlik Sense Analytics Development


A windows PC (or a Mac with Docker or VM installed) as Qlik Sense is a windows product
Keen to learn new concepts and develop your skills further
Basic understanding of data concepts
Keen to escape excel confusion
Don’t have a Win PC (or Mac), no problem, develop in the cloud using Qlik business trial


This course is also available on Udemy Business  Certificate in Qlik Sense Analytics Development (Fully updated October 2021)Data Scientists, Data Analysts are big career topics 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 Qlik Sense, 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 best course for you. 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 Qlik Sense Enterprise and Qlik Sense Cloud (SaaS).Looking forward to seeing you in the course.PaulData Analyst and Visualisation Engineer


Section 1: Course Objectives *

Lecture 1 Introduction and welcome

Lecture 2 Our start-up needs a business plan, but what is it meant to do ?

Lecture 3 Tune your browser to get 1080p HD all of the time

Lecture 4 Download , Install & Register Qlik Sense

Section 2: The Language *

Lecture 5 Metrics and KPI’s what are they ?

Section 3: Budgeting and KPI (goal) setting *

Lecture 6 Where to find everything

Lecture 7 Introduction to navigating the Qlik Sense hub

Lecture 8 Dimensions and Measures, what are they?

Lecture 9 Create your first application (App)

Lecture 10 The first data load

Lecture 11 Create a Pivot table

Lecture 12 Creating charts and expression sorts

Lecture 13 How to create and use a KPI object

Lecture 14 Introducing the filter pane

Lecture 15 Recap of our app and the Selection Model

Section 4: Data Science for Sales Performance *

Lecture 16 Loading new sales data to the model

Lecture 17 Review and check the sales data

Lecture 18 Learn about Master Items and start using count()

Lecture 19 Changing the scope using conditional expressions

Lecture 20 More advanced expressions to calculate a variance

Lecture 21 How to Visualise Correlation (Scatter Plot)

Lecture 22 Adding more features to the scatter plot

Lecture 23 Geo Analysis (Part 1)

Lecture 24 Geo Analysis (Part 2)

Section 5: Inventory Analytics *

Lecture 25 A conversation about the data we shall use for this section

Lecture 26 Loading data and how to fix circular references

Lecture 27 Loading data and how to fix synthetic keys and circular references

Lecture 28 Using straight tables for data validation (Inc Spark Lines)

Lecture 29 Creating KPI objects and coding metrics

Lecture 30 Creating KPI objects and coding metrics in Set Analysis (Expressions)

Lecture 31 A conversation about coding Set Analysis – Part 1

Lecture 32 A conversation about coding Set Analysis – Part 2

Lecture 33 A continuation of our coding Set Analysis conversation

Lecture 34 Coding Set Analysis for other measures

Lecture 35 How to avoid misleading the user in an expression

Lecture 36 Coding Set Analysis for mapping (GeoAnalytics)

Lecture 37 Coding Set Analysis for tabular display

Section 6: Online Customer Sales Analytics *

Lecture 38 Overview the tons of new stuff in this section

Lecture 39 Make a new model and merge like file structures

Lecture 40 How to discretize data for analysis (Market Segmentation)

Lecture 41 Understand what resident loads are

Lecture 42 What is the Lookup() function ?

Lecture 43 Start creating our visualizations with discretized data (Market Segmentation)

Lecture 44 Using Rank(), Sum(), Aggr() for advanced counting

Lecture 45 Using element function e() for advanced counting

Lecture 46 Using element function p() for advanced counting

Lecture 47 Bringing it all together on a dashboard sheet

Section 7: Payroll Analytics and Pareto analysis *

Lecture 48 Introducing Payroll with some cool new functions

Lecture 49 Data modelling 101 in Qlik Sense

Lecture 50 Create a data review sheet with a special type Pivot Table

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

Lecture 52 How to do 80/20 analysis (Pt 1)

Lecture 53 How to do 80/20 analysis (Pt 2)

Lecture 54 InLine load and Salary Distribution

Lecture 55 Bringing it all together – Part 1

Lecture 56 Bringing it all together – Part 2

Section 8: Profit performance including the magic of variables *

Lecture 57 Section 8 Overview

Lecture 58 Lets explore another example of a compound key

Lecture 59 What is a variable and how do we use them in Qlik Sense ?

Lecture 60 Defining variables and revealing them in the debug window

Lecture 61 Build a bar chart using the canonical calendar & variables (Part 1)

Lecture 62 Build a bar chart using the canonical calendar & variables (Part 2)

Lecture 63 Replacing chart expressions with expression variables

Lecture 64 Setting variables with date functions in Set Expressions – Part 1

Lecture 65 Setting variables with date functions in Set Expressions – Part 2

Lecture 66 Write YTD/MTD dates in a variable

Lecture 67 Visualise cumulative values from variables – Part 1

Lecture 68 Visualise cumulative values from variables – Part 2

Section 9: Tips and Tricks (Common developer requirements) *

Lecture 69 Section 9 Overview

Lecture 70 How to create a bookmark and set default page

Lecture 71 How to create your story – Part 1

Lecture 72 How to create your story – Part 2

Lecture 73 Store data from Qlik Sense into a QVD

Lecture 74 Using web page data for charts

Lecture 75 The Master Calendar – Part 1

Lecture 76 The Master Calendar – Part 2

Lecture 77 How to use extensions from Qlik Garden

Lecture 78 Linking to sheets and external URL’s

Lecture 79 Data Governance & the Metadata Dictionary – Part 1

Lecture 80 Data Governance & the Metadata Dictionary – Part 2

Lecture 81 Data Governance & the Metadata Dictionary – Part 3

Lecture 82 How to create mashups in Qlik Sense – Part 1

Lecture 83 How to create mashups in Qlik Sense – Part 2

Section 10: Retrieving your Achievement Certificate

Lecture 84 Instructions to retrieve your graded certificate

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 Qlik Sense,BI/ETL/DW Professionals,Prоjесt Managers,Job seekers looking to answer tough interview questions (tons of quizzes to help you with this),Buѕinеѕѕ аnd Rероrting рrоfеѕѕiоnаlѕ,Grаduаtеѕ building a career in data Visualisation & Anаlуѕiѕ,QlikView Developers and Users looking to update to Qlik Sense,Data Scientists looking for alternate visualisations besides ‘R’, Python, SAS etc

Course Information:

Udemy | English | 13h 52m | 5.74 GB
Created by: Paul Scotchford

You Can See More Courses in the Business >> Greetings from CourseDown.com

New Courses

Scroll to Top