Advanced Qlik Sense: All you need to know for Data Science

Section 1: Course introduction

No datasets required for this section

Section 2: Geo analysis and Correlation

One of the CSV files for this section have been compressed to reduce its size – do ensure to unzip all files after download before continuing.

• Chicago_Crimes_2018.zip (Note: Unzip this file)
• Chicago Temps 2018.xlsx
• Chicago Daylight Hours.csv

Section 3: Basic scripting

We have three almost identical files for this section, each focusing on a different period.

• Sales.xlsx
• Sales – 2018_Jul_Sep.xlsx
• Sales – 2018_Apr_Jun.xlsx

Section 4: Joining and transforming data (through scripting)

For this section we will continue with the work from Section 3, and have two additional files:

• Customers.xlsx
• Region.txt

Section 5: Extensions, parameters and (more) set analysis

No standard data files this time round – in this section we will look at QVD files.

• NY_licence_applications.QVD

You will also need this following link during the course of the section:

• https://developer.qlik.com/garden/56728f52d1e497241ae697cb