EIEIOTECHNOVATION
← Training programmes

EIEIO / DATA SCIENCE

Data Modeling with Qlik Sense

Course outline

3 days
Discuss this programme →

Duration

3 days

Course Overview

This course will guide you through the deployment architecture and the enterprise platform, ensuring a robust understanding of various deployment scenarios. You'll gain insights into data mining, dimensions, measures, and how relational database management systems interact with Qlik Sense's unique data source formats.

Learn how to manage data effectively using Qlik Sense's data manager and understand the differences between database and Qlik Sense data structures. The course emphasizes on data associations within Qlik Sense and equips you with practical skills in data modeling.

Part I : Identify Requirements for Data Models

  • Curriculum Overview
  • Determining the business objectives
  • Identify the data requirements - Part 1
  • Double check the data requirements
  • The Tiered Architecture
  • Exercise: Tier review and your choice

Qlik Sense Features

  • The Qlik Associative Model
  • On Demand Application Generation - ODAG
  • Qlik Sense Variables
  • Alternate States
  • Security features
  • Meeting the customer needs
  • Define the security requirements
  • Presenting a solution proposal to the customer

Part II - Design Data Models

  • Curriculum Overview
  • Qlik Sense Terminologies
  • Qlik Sense Windows architecture overview
  • Qlik Sense Multi-Node Architecture Overview
  • Qlik Sense - A scalable architecture
  • The Star Schema
  • Exercise - Build a Star Schema
  • The Snowflake schema
  • Exercise - Build a Snowflake Schema
  • How to model our solution data
  • Exercise - An associative thought experiment
  • The Master Calendar

Part III - Build Data Models

  • Curriculum Overview
  • Introduction to the data load editor
  • Exercise - Load a dimension
  • Download and Install SQL Server
  • Restore the eCommerce_ODS database
  • Load a dimension from SQL Server
  • Exercise - Load a SQL Server fact table
  • Load a fact table from MS Access
  • Load multiple dimensions from MS Access
  • Exercise - Load a MS Access dimension and fact table
  • Finalising the Data Extract layer
  • Exercise - Finalising the Data Extract layer
  • Script regular statements
  • Working with Qlik Sense variables
  • Exercise - Setting a variable
  • Script prefixes
  • Understanding table joins - INNER
  • Understanding table joins - LEFT
  • Understanding table joins - RIGHT
  • Understanding table joins - OUTER
  • Exercise - Code a join
  • Script control statements
  • The Incremental Load - Part 1 (Start Baseline)
  • The Incremental Load - Part 2 (InLine)
  • The Incremental Load - Part 3 (Temp Tables)
  • The Incremental Load - Part 4 (Resident - Peek)
  • The Incremental Load - Part 5 (Baseline wrap)
  • The Incremental Load - Baseline Debug
  • The Incremental Load - Part 7 (Inc Time)
  • The Incremental Load - Final
  • Exercise - Coding Challenge
  • Dealing with orthogonal list data
  • Exercise - Adding additional list data to the model
  • The Slowly Changing Dimension - Intro
  • The Slowly Changing Dimension - Coding
  • Exercise - Coding a SCD
  • Coding the Master Calendar - The method used
  • Coding the Master Calendar - The Code
  • Segment, Aggregate, Mapping Load - Scenario
  • Segmentation, Mapping Load, In Script Aggregation - Code
  • Exercise - Segmentation, Mapping Load, In Script Aggregation
  • Tier Review - Development progress
  • The Tier 4 Self Service Model
  • Exercise Challenge - Add to the model

Programme scope, delivery arrangements and suitability are confirmed during enquiry.