Course curriculum

  1. 01

    • Introduction

    • Introduction What is BI

    • Loading Data in Qlik Sense

    • Introduction Qlik Sense Workflow

    • Creating Our First Dashboard

    • Introduction Adding new Columns

    • Adding New Columns into Table

    • Introduction Sorting

    • Sorting in Table

    • Introduction Chart Interactions

    • Chart Interaction in Qlik Sense

    • Table Linkage

    • Creating Bookmarks

    • Introduction Variables

    • Creating Buttons
  2. 02

    • Introduction
  3. 03

    • Introduction Connecting data via Web Sources

    • Connecting Data via Web Sources

    • Qlik Sense Workflow - ETL Dashboard

    • ETL Layer - Extract

    • Introduction Transform

    • ETL Layer - Transform

    • ETL Layer - Load

    • Application Layer - Dashboard

    • Introduction Concatenate Clause

    • Script syntax and functions - Concatenate and Noconcatenate

    • Introduction Join Clause

    • Left Joins

    • Right Joins

    • Introduction Join Clause

    • Join

    • Fiscal Calendar

    • Introduction 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
  4. 04

    • 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
  5. 05

    • 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
  6. 06

    • Introduction - Snapshotting Data

    • Pseudocode - Snapshotting Data

    • Logic Demo - Snapshotting Data

    • Introduction - Data Repatching-converted

    • Pseudocode - Data Repatching

    • Demo - Data Repatching (Part 1)

    • Demo - Data Repatching (Part 2)
  7. 07

    • Conclusion