Certificate of QlikSense analytics development

Scenario based QlikSense development training using real business data
4.5 (86 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.
439 students enrolled
$40
Take This Course
  • Lectures 74
  • Contents Video: 13.5 hours
    Other: 1 min
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 6/2015 English

Course Description

Certificate of QlikSense data visualization and analytics application development

This course is now priced to the new UDEMY price tier, enjoy the value you will receive in the course, your ROI will be many times what you paid, and while you are at it, scroll to the bottom of the page to see my other course, it covers SQL for data analytics, I teach you how to write the SQL that makes the data analyst's job easier.

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.

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

I am always available to help you and answer your questions, even when you have completed the course.

Regards 

Paul

What are the requirements?

  • Interested in analytics and data visualisation
  • Keen to escape excel
  • Download QlikSense (I show you in the course) as you will develop apps during the course

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction to the course
03:33

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

04:56

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.

11 questions

Test your knowledge of the Business Plan

02:19

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

06:47

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

Section 2: The Language
05:59

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

13 questions

Testing your understanding of terms used in Analytics

Section 3: Budgeting and KPI (goal) setting
11:34

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.

14:14

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

14 questions

Testing your general QS introductory knowledge

03:59

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.

9 questions

Test your understanding of dimensions and measures

01:36

A very quick look as to how to create your first App in QlikSense, yes its very easy.

18:26

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)

15 questions

Test your knowledge on data loading

15:59

What is a pivot table, how to create one to review our loaded data.

10 questions

Test your knowledge of the Pivot table functionality

11:33

Explore combo and line charts, and learn about expression sorts.

03:59

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

06:11

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

11:07

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

15 questions

Test what else you discovered in this chapter

Section 4: Tracking your sales performance
11:40

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.

13:18

Create a new sheet with filters and a pivot table to review our new Sales data.

Learn about table options and formatting.

19:59

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

17 questions

Test your knowledge of expressions

12:38

Let's start to build a GP Analysis sheet and practice your conditional expressions to display interesting values on KPI objects.

12:20

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

18:02

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

16 questions

Testing your interpretations

12:43

Present the audience with more information and formatting on a pivot table.

10:02

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

13 questions

Test your expertise so far

04:53

How to setup for using maps to visualize the global Sales performance, here we touch on the "Data load editor" to create a GeoKey.

12:06

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

12 questions

Test your map and general knowledge

Section 5: Stock Performance
10:43

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.

17:47

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

15:56

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.

19:48

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.

16 questions

Test your basic model and data integrity knowledge

11:19

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.

18:17

Creating a calculated dimension in prep to set limitations.

14 questions

Test your knowledge of dimensionality and recall

12:22

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

11:12

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

14 questions

Test your basic Set Analysis knowledge

Section 6: Online customer sales analysis
07:49

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.

8 questions

Test your knowledge on data loads

17:15

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.

08:07

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

7 questions

Test your knowledge of banding

11:28

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"

11:51

Digging more into the code for this table.

20 questions

Test your knowledge on more data topics

15:46

Back to visualizations now and lets build a sheet for the discretisations and we'll also apply conditional formatting.

14:56

Advanced counting using Sum, Aggr() function and TOTAL.

The lecture goes into detail how to create a count of customer registrations by month.

08:02

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

7 questions

Test what you learned in Advanced counting

11:04

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

12:14

Adding maps to the final dashboard sheet.

Section 7: Payroll, Pareto analysis
07:12

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.

10:46

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)

15 questions

Test your data modelling competence

18:42

Build up a detailed Payroll data analysis sheet. More on conditional formatting and hiding sensitive data elements from display.

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

09:49

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

05:14

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

05:34

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

07:59

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

15 questions

Test what you know about the Pareto we built

Section 8: P & L and variables
13:22

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.

3 questions

Snap to it

15:47

Explore what variables are and how to create and use them in QlikSense.

How to use the debug feature in QlikSense.

12 questions

Test your knowledge of using variables

12:40

Using variables to compute dates.

11:05

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.

13:49

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

17:13

Let's play with using colour expressions in variables and explore multi line expressions created in the load editor for a variable

12:56

How do you embed a delimited expression into a variable , this is common in Set Analysis based variables.

12 questions

Double check your knowledge did not miss anything

Section 9: Tips and Tricks (Bonus lectures)
12:27

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 your story
12:48
08:51

How to share your story with others.

12:03

Explore the different ways to export data from QlikSense.

08:32

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

12:15

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

16 questions

Test your knowledge on enhancing the user experience

12:15

Reducing your calendar data requirements dynamically.

11:08

I demonstrate using raw scripting in the data load editor for generating your own calendar from scratch.

10 questions

Test your knowledge around the Calendar

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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

Ready to start learning?
Take This Course