Duration
2 days
Overview
In the Intermediate session, you will be exposed to the load script where we load our data into Qlik Sense. And also did some of the basic transformations. Once we have all the tables transformed and saved into QVD formats, we will load all the QVDs back into the load script. And finally, we will load the data model into our final application, which is the dashboard layer. Next, we will go into the Sheets to expose ourselves to visualization expressions, how to create buttons, and also the idea of having master dimension, master expressions, and master visualizations in the dashboard. For the Advanced session, we will guide you on how to build our load scripts with Master Calendar and Fiscal Calendar, YTD tables, and so on.
Course Outline
Intermediate Qlik Sense
- Introduction: Connecting data via Web Sources
- Connecting data using Web Connectors - Google Drive
- Qlik Sense Workflow - ETL > Dashboard
- ETL Layer - Extract
- Introduction: Transform
- ETL Layer - Transform
- ETL Layer - Load
- Application Layer - Dashboard
Concatenate Clause
- Script syntax and functions - Concatenate and Noconcatenate
- Introduction: Join Clause
- Left Joins
- Right Joins
- Introduction: Join Clause
- Join
- Fiscal Calendar
Dashboard Design
- Visualizations : Set Analysis
- Introduction to Color Code
- Visualizations : Color Code
- Master Items - Dimension
- Master Items - Measure
- Master Items - Visualization
- MTD and YTD buttons
Advanced Class
- Load Script: Cross Table
- Load Script: Group By
- Load Script: Order By
- Load Script: YTD Fact table
- Load Script: Master Calendar
- Load Script: Fiscal Calendar
- Load Script: Link Table
- Load Script: Star Schema
- Visualizations: 100% Chart
- Visualizations: Aggr
- Visualizations: Rank
- Visualizations: Toggle
- Visualizations: Pagination
Sharing
- Introduction - QTD
- Creating Inline Data - QTD
- Constructing Expression - QTD
- ApplyMap Function
- ApplyMap vs Join
- Apply Map - What we Can do with values Not Mapped?
- What happpen if we are joining Columns of Different DataTypes?
- Dashboard Optimization - Text vs Num
Logic Sharing
- Introduction - Snapshotting Data
- Pseudocode - Snapshotting Data
- Logic Demo - Snapshotting Data
- Introduction - Data Repatching
- Pseudocode - Data Repatching
- Demo - Data Repatching (Part 1)
- Demo - Data Repatching (Part 2)
Programme scope, delivery arrangements and suitability are confirmed during enquiry.