What is SMART about metrics and KPIs ?

Where is everything and how do I get my sample apps and data ?

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

A brief discussion about Dimensions and Measures as we use these throughout the course.

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

This is your first experience to loading data into QlikSense.

With a brief overview of the data model and how tables are associated.

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

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

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

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

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

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.

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

Learn about table options and formatting.

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

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

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

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

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

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

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

New data and section overview

The circular reference means something has gone very wrong with your model design ! How to recognise and fix this.

Synth keys can be good but sometimes we don't really want them in the model unless by design, lets talk about it here

Spark lines in the straight table are very handy for quick insight

Coding measures within KPI objects

Combo charts and Set Analysis 

Getting your head around Set Analysis (Expressions) - It's so powerful and totally needed in your apps

Further to the previous lecture

More set expression coding

Practice makes perfect with some lateral thinking

A tip for ensuring the user sees exactly what is expected in the visualisation

Multi layered map with set expression(s)

Other Set Expression code work

In this series of lectures we will be using new data that spans 4 years for analysis

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.

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

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"

Digging more into the code for this table.

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

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

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

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

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

Adding maps to the final dashboard sheet.

Section overview

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

Please follow the instructions in the PDF to retrieve your Training Certificate