Certificate in QlikSense Analytics Development

Testing your understanding of terms used in Analytics

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.

Testing your general QS introductory knowledge

Test your understanding of dimensions and measures

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)

Test your knowledge on data loading

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

Test your knowledge of the Pivot table functionality

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.

Test what else you discovered in this chapter

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.

Test your knowledge of expressions

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.

Testing your interpretations

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

Test your expertise so far

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.

Test your map and general knowledge

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.

Load the new data and learn how to fix synthetic keys 

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

Test your basic model and data integrity knowledge

Explore creating sheet objects such as Straight Tables and drill down dimensions

Coding measures within KPI objects

Combo charts and Set Analysis 

Test your knowledge of dimensionality and recall

Conversation around Set Modifiers

Hands on coding Set Analysis for you to practice on

Practice makes perfect with some lateral thinking

Test your basic Set Analysis knowledge

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.

Test your knowledge on data loads

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.

Test your knowledge of banding

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.

Test your knowledge on more data topics

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.

Test what you learned in Advanced counting

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

Adding maps to the final dashboard sheet.

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.

What is a star and snowflake schema ? Here we explore the model methodology used in QlikSense (indeed this is the same as QlikView)

Test your data modelling competence

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

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.

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

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

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

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

Test what you know about the Pareto we built

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.

Snap to it

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

How to use the debug feature in QlikSense.

Test your knowledge of using variables

Using variables to compute dates.

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.

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

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

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

Double check your knowledge did not miss anything

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 share your story with others.

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

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

Test your knowledge on enhancing the user experience

Reducing your calendar data requirements dynamically.

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

Test your knowledge around the Calendar

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

Test your knowledge on the value of app extensions and some past subject matter

A hot topic today in BI&A is data governance, here you will be introduced how to provide and implement it.

Do you have a basic idea of the principals of Governance

Earlier in Section 5 we uncovered a data anomaly and you were tasked with debugging it, here is the answer to the problem.

Did you get down to the culprit causing the null row displays ?

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)

Test your knowledge about creating a mashup