image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

Description

Please note, some reading/information resources within the course use external links e.g. Qlik Sense Help content
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.
Paul
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 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

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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Course Objectives *
5
1.1-Introduction and welcome
1.2-Our start-up needs a business plan, but what is it meant to do ?
1.3-Quiz Time
1.4-Tune your browser to get 1080p HD all of the time
1.5-Download , Install & Unlock Qlik Sense
2-The Language *
2
2.1-Metrics and KPI's what are they ?
2.2-Quiz Time
3-Budgeting and KPI (goal) setting *
15
3.1-Where to find everything
3.2-Introduction to navigating the Qlik Sense hub
3.3-Quiz Time
3.4-Dimensions and Measures, what are they?
3.5-Quiz Time
3.6-Create your first application (App)
3.7-The first data load
3.8-Quiz Time
3.9-Create a Pivot table
3.10-Quiz Time
3.11-Creating charts and expression sorts
3.12-How to create and use a KPI object
3.13-Introducing the filter pane
3.14-Recap of our app and the Selection Model
3.15-Quiz Time
4-Data Science for Sales Performance *
13
4.1-Loading new sales data to the model
4.2-Review and check the sales data
4.3-Learn about Master Items and start using count()
4.4-Quiz Time
4.5-Changing the scope using conditional expressions
4.6-More advanced expressions to calculate a variance
4.7-How to Visualise Correlation (Scatter Plot)
4.8-Quiz Time
4.9-Adding more features to the scatter plot
4.10-Quiz Time
4.11-Geo Analysis (Part 1)
4.12-Geo Analysis (Part 2)
4.13-Quiz Time
5-Inventory Analytics *
16
5.1-A conversation about the data we shall use for this section
5.2-Loading data and how to fix circular references
5.3-Loading data and how to fix synthetic keys and circular references
5.4-Quiz Time
5.5-Using straight tables for data validation (Inc Spark Lines)
5.6-Creating KPI objects and coding metrics
5.7-Creating KPI objects and coding metrics in Set Analysis (Expressions)
5.8-A conversation about coding Set Analysis - Part 1
5.9-A conversation about coding Set Analysis - Part 2
5.10-Quiz Time
5.11-A continuation of our coding Set Analysis conversation
5.12-Coding Set Analysis for other measures
5.13-How to avoid misleading the user in an expression
5.14-Coding Set Analysis for mapping (GeoAnalytics)
5.15-Coding Set Analysis for tabular display
5.16-Quiz Time
6-Online Customer Sales Analytics *
12
6.1-Overview the tons of new stuff in this section
6.2-Make a new model and merge like file structures
6.3-How to discretize data for analysis (Market Segmentation)
6.4-Understand what resident loads are
6.5-What is the Lookup() function ?
6.6-Quiz Time
6.7-Start creating our visualizations with discretized data (Market Segmentation)
6.8-Using Rank(), Sum(), Aggr() for advanced counting
6.9-Using element function e() for advanced counting
6.10-Using element function p() for advanced counting
6.11-Bringing it all together on a dashboard sheet
6.12-Quiz Time
7-Payroll Analytics and Pareto analysis *
11
7.1-Introducing Payroll with some cool new functions
7.2-Data modelling 101 in Qlik Sense
7.3-Create a data review sheet with a special type Pivot Table
7.4-Combining functions the RowNo(), Above() and RangeSum() for 80/20 analysis
7.5-Quiz Time
7.6-How to do 80/20 analysis (Pt 1)
7.7-How to do 80/20 analysis (Pt 2)
7.8-InLine load and Salary Distribution
7.9-Bringing it all together - Part 1
7.10-Bringing it all together - Part 2
7.11-Quiz Time
8-Profit performance including the magic of variables *
14
8.1-Section 8 Overview
8.2-Lets explore another example of a compound key
8.3-What is a variable and how do we use them in Qlik Sense ?
8.4-Defining variables and revealing them in the debug window
8.5-Build a bar chart using the canonical calendar & variables (Part 1)
8.6-Build a bar chart using the canonical calendar & variables (Part 2)
8.7-Quiz Time
8.8-Replacing chart expressions with expression variables
8.9-Setting variables with date functions in Set Expressions - Part 1
8.10-Setting variables with date functions in Set Expressions - Part 2
8.11-Write YTD/MTD dates in a variable
8.12-Visualise cumulative values from variables - Part 1
8.13-Visualise cumulative values from variables - Part 2
8.14-Quiz Time
9-Tips and Tricks (Common developer requirements) *
17
9.1-Section 9 Overview
9.2-How to create a bookmark and set default page
9.3-How to create your story - Part 1
9.4-How to create your story - Part 2
9.5-Store data from Qlik Sense into a QVD
9.6-Using web page data for charts
9.7-The Master Calendar - Part 1
9.8-The Master Calendar - Part 2
9.9-Quiz Time
9.10-How to use extensions from Qlik Garden
9.11-Linking to sheets and external URL's
9.12-Data Governance & the Metadata Dictionary - Part 1
9.13-Data Governance & the Metadata Dictionary - Part 2
9.14-Data Governance & the Metadata Dictionary - Part 3
9.15-How to create mashups in Qlik Sense - Part 1
9.16-How to create mashups in Qlik Sense - Part 2
9.17-Quiz Time
10-Retrieving your Achievement Certificate
1
10.1-Instructions to retrieve your graded certificate