Certificate in QlikSense Analytics Development
4.3 (416 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,910 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
Bestselling
4.3 (416 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,910 students enrolled
Created by Paul Scotchford
Last updated 8/2017
English
Current price: $10 Original price: $45 Discount: 78% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 13 hours on-demand video
  • 5 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
Requirements
  • 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
Description

Course News (June 2017) : This course has been updated to be compatible with Qlik Sense V3.1 and V3.2 

Certificate in QlikSense 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 QlikSense and a certificate that showcases your technical skill then this is the only course to take.

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 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 QlikSense application development.

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

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
  • Data visualisation engineers and analysts
  • Business Intelligence specialists
Students Who Viewed This Course Also Viewed
Curriculum For This Course
77 Lectures
13:06:03
+
Course Objectives
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 ?
08:23

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

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

Preview 12: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.

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.

Preview 01:45

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

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
16:09

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

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

How to create and use a KPI object
12:12

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

Year and month filter objects
07:28

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

Review the section and personalize the App
17:42

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
16:23

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

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

Learn about Master Items and start using count()
14:56

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

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

More advanced expressions to calculate a variance
10:37

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

How to Visualise Correlation
10:12

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

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)
04:37

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

Geo Analysis (Part 2)
08:49

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

Load the new data and learn how to fix synthetic keys 

Loading data and how to fix synthetic keys and circular references
07:32

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

Loading data and how to fix circular references
09:02

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
09:24

Coding measures within KPI objects

Creating KPI objects and coding measures
08:29

Combo charts and Set Analysis 

Creating combo charts and a conversation about coding Set Analysis
10:32

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

Hands on coding Set Analysis for you to practice on

Coding Set Analysis for measures (Part 1)
10:45

Practice makes perfect with some lateral thinking

Coding Set Analysis for measures (Final)
10:14

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

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

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

How to discretize data for analysis (Market Segmentation)
06:54

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:37

Digging more into the code for this table.

What is the Lookup() function ?
12:11

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:55

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

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

Adding maps to the final dashboard sheet.

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

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 QlikSense
13:51

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)
07:37

Create a data analysis review sheet (Pt 2)
11:26

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:51

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

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

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

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

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

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

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

Bringing it all together
08:34

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

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 (Part 1) ?
07:29

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

Test your knowledge of using variables

The magic of variables
12 questions

Using variables to compute dates.

Setting variables with date functions
13:09

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

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

Replacing simple expressions with expression variables
13:57

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 to code string delimiters in a variable ?
13:06

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

How to create your story
12:46

How to share your story with others.

How to share your story with others
10:40

Explore the different ways to export data from QlikSense.

Preview 12:07

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

Connect and extract data from a SQL Server database
08:35

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

Connect to and extract data from a web page
10:45

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

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
09:35


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

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 data governance ?
10:49

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

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

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,665 Reviews
25,671 Students
3 Courses
Data Analyst and Qlik Development Specialist

Hello

Join me with me and over 24,000 of my students and benefit from my experience.

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.

Best

Paul