Certificate in QlikSense Analytics Development
4.5 (232 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,194 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 !
Bestselling
4.5 (232 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,194 students enrolled
Last updated 3/2017
English
Current price: $10 Original price: $40 Discount: 75% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 13.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
Construct the code to implement your metrics and dimensions
Source code for all apps used in course creation
Hands on experience
View Curriculum
Requirements
  • Have a keen interest in data analytics and data visualisation
  • Keen to escape excel hell
  • Download QlikSense (I show you in the course) as you will develop apps during the course
Description

Certificate in QlikSense data visualization 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 visualize 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 favorite is QlikSense, I liked it so much, I took a leave of absence and spent 3 months developing this course for all those that want a hands on approach to learning and a certificate that showcases your technical achievement as well.

QlikSense is the next generation of QlikView.

QlikSense is overtaking so many of it's peers mostly because of it's underlying 'associative data model' technology and absolute ease of discovery for insightful decision making and story telling, and I'm certain after doing 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 app development.

Best 

Paul

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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 74 Lectures Collapse All 74 Lectures 13:38:39
+
Introduction to the course
4 Lectures 17:36

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

Preview 03:33

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 ?
04:56

Test your knowledge of the Business Plan

Business Planning
11 questions

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

Getting started with QlikSense
02:20

Step by Step guide to the download and install process for Version 2.2.3 (Rev for QlikSense 2.2.3 Feb16)

Download and install QlikSense
06:47
+
The Language
1 Lecture 05:59

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

Metrics and KPI's what are they ?
05:59

Testing your understanding of terms used in Analytics

The language
13 questions
+
Budgeting and KPI (goal) setting
10 Lectures 01:38:38

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 ?
11:34

Quick tour of the QlikSense Hub, this is the nerve centre of your apps (Rev for QlikSense 2.2.3 Feb16)

Introduction to navigating the QlikSense hub
14:14

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.

Dimensions and Measures, what are they?
03:59

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)
01:36

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
18:26

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
15:59

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
11:33

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

How to create and use a KPI object
03:59

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

Year and month filter objects
06:11

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

Review the section and personalize the App
11:07

Test what else you discovered in this chapter

Overall review of this chapter
15 questions
+
Tracking your sales performance
10 Lectures 02:07:41

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
11:40

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
13:18

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

Learn about Master Items and start using count()
19:59

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
12:38

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

More advanced expressions to calculate a variance
12:20

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

How to do Scatter Plot and Tree Map charts
18:02

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
12:43

For practice, lets take a copy of the Store GP Analysis and create the equivalent for Online Sales GP Analysis.

Duplicate and tailor a sheet
10:02

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.

Preview 04:53

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

Ready to display maps for analysis
12:06

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.

Introducing a model change with an extra fact table
10:43

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

How to handle synthetic keys and circular references
17:47

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
15:56

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
19:48

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
11:19

Creating a calculated dimension in prep to set limitations.

How to create a calculated dimension
18:17

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
12:22

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

Understand and use Set Analysis
11:12

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
07:49

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
17:15

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

How to discretize data for analysis (Market Segmentation)
08:07

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
11:28

Digging more into the code for this table.

What is the Lookup() function ?
11:51

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)
15:46

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
14:56

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

Surface and test the advanced counting
08:02

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
11:04

Adding maps to the final dashboard sheet.

Enhance the dashboard sheet with mapping
12:14
+
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
07:12

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
10:46

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
18:42

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
10:42

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

How to do 80/20 analysis (Pt 1)
09:49

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

How to do 80/20 analysis (Pt 2)
05:14

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

How to do 80/20 analysis (Pt 3)
05:34

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

Bringing it all together
07:59

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
13:22

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 ?
15:47

Test your knowledge of using variables

The magic of variables
12 questions

Using variables to compute dates.

Setting variables with date functions
12:40

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
11:05

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

Replacing simple expressions with expression variables
13:49

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
17:13

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 ?
12:56

Double check your knowledge did not miss anything

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

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
12:27

How to create your story
12:48

How to share your story with others.

How to share your story with others
08:51

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
08:32

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

Connect to and extract data from a web page
12:15

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
12:15

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
11:08

Test your knowledge around the Calendar

Lets date
10 questions

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

How to integrate d3 visualisations
10:30

How to add a word cloud to your sheet
11:34

How to link to other sheets in the App, and how to link to external URLs.
Linking to sheets and external URL's
03:40

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 ?
10:43

How do I implement governance ?
14:36

Do you have a basic idea of the principals of Governance

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
02:20

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
15:17

Test your knowledge about creating a mashup

Mashups
17 questions
+
How to retrieve your Certificate
1 Lecture 00:00
About the Instructor
Paul Scotchford
4.5 Average rating
1,094 Reviews
18,905 Students
3 Courses
Data analyst

Hi there,

I am a Data Analyst, QlikView, QlikSense & SQL Developer that has worked with data since 2003 (when I started working with the Microsoft SQL stack) but moved into the QlikView environment in 2012 and commenced working with QlikSense in 2014 whilst it was still a beta release.

I still work with SQL as it is foundation to a substantial amount of my DA work.

Paul