DATA MODELLING FOR QLIK SENSE PART 1-P210320IBS

DATA MODELLING FOR QLIK SENSE PART 1-P210320IBS

Funded
Course Duration
15.0 hr(s)
Mode of Assessment

Written and Practical

Who Should Attend

Anyone who wants to build a structured data model for self-service analytics

What's In It for Me

Learn to develop a coherent data model in Qlik Sense by loading and transforming multiple data sources.

Course Overview

This two days course will provide the necessary skills to develop a coherent data model in Qlik Sense by loading and transforming multiple data sources. With information, tools, techniques, and exercises, this course includes topics dealing with: data connections, cleansing and transforming source data and resolving data model issues

Course Schedule

Next available schedule

Course Objectives

  • Create a data model in Qlik Sense

  • Data Sources and Data Mining

  • Dimensions & Measures

  • Use the data load editor and Data Manager

  • Create and maintain data connections

  • Resolve data structure issues

  • Transform data for better performance

  • Discuss synthetic keys and circular references

  • Introduction to Data Security

Pre-requisites

  • Creating Visualizations with Qlik Sense (advantageous)
  • Database and SQL query knowledge

Course Outline

Module 1: Modelling Data With Qlik Sense

Qlik Sense Deployment architecture

  • Qlik Sense app
  • Qlik Sense Enterprise platform
  • Deployment scenarios

Data sources and data structures

  • Introduction to Data Mining

  • Introduction to Dimensions & Measures
  • Data Relational database management systems (RDBMS)
  • Qlik Sense data source formats
  • Data manager
  • Database vs. Qlik Sense data structures

  • Data associations in Qlik Sense
  • Qlik Sense data modelling

Qlik Sense Platform and Qlik Sense App

  • Qlik Sense Hub
  • App Overview

Create a new app

  • Creating a new app
  • Drag & drop data load

Data load editor and script sections

  • Data load editor environment
  • Script sections

Module 2: Sourcing & Loading Data

Data Connections

Select and load

  • Extracting data from a database

Add calculated fields to a table

  • Creating new fields

Data model viewer

Loading data from files

Module 3: Resolving Common Modelling Issues

Synthetic keys

  • What are synthetic keys and synthetic tables
  • Why do synthetic keys need to be avoided?
  • Resolve a synthetic key issue

Basic data transformation

  • Load statement syntax
  • Renaming a field
  • Counting table records
  • Key fields
  • Record counting: Count vs Sum

Circular references

  • Circular references
  • Loosely coupled tables

Module 4: Generating Data

Adding Calculated Fields to a Table

Limiting and generating data

  • The Where clause
  • Resident load

Scripting considerations

  • More about synthetic keys
  • Composite keys

Master calendar

  • Master calendar
  • Date and time in Qlik Sense
  • Flags

Module 5: Data Confidentiality

  • Introduction to Data Security

Certificate Obtained and Conferred by

Candidate who successfully completed the course with 

  1. 100% attendance 
  2. Pass the assessment (Pass rate: 70%) will be Awarded NTUC LearningHub Certificate of Completion 

Additional Details

Medium of Instruction and Trainer

Medium of Instruction: English

Trainer: Trainee ratio is 1:20

Price

For Classes commencing between 1st July 2021 to 31st Dec 2021

 

Individual Sponsored Trainee

Company Sponsored Trainee

 

before GST

with GST

before GST

with GST

 

Full Course Fee (For International Students)

$2,000.00

$2,140.00

$2,000.00

 $2,140.00

 

For Singapore Citizens and PRs
 (after 90% funding)

$74.00

$214.00

$200,00

$340.00

 

For Singapore Citizens aged 40 years and above
 (after 90% funding)

$74.00

 

$214.00

 

$200,00

$340.00

 

 

For Classes commencing between 1st Jan 2022 to 30th Jun 2022

 

Individual Sponsored Trainee

Company Sponsored Trainee

 

before GST

with GST

before GST

with GST

 

Full Course Fee (For International Students)

 $2,000.00

$2,140.00

 $2,000.00

 $2,140.00

 

For Singapore Citizens and PRs
 (after 80% funding)

$288.00

$428.00

$400.00

$540.00

 

For Singapore Citizens aged 40 years and above
 (after 90% funding)

 $74.00

$214.00

 $200.00

$340.00

 

 

Funding Eligibility Criteria:

Individual Sponsored Trainee

Company Sponsored Trainee

  • Singapore Citizens or Singapore Permanent Residents physically based in Singapore
  • Trainee must achieve 100% attendance and pass all relevant assessments
  • NTUC LearningHub reserves the right to claw back the funded amount from trainee if he/she did not fulfil the eligibility criteria
  • Singapore Citizens or Singapore Permanent Residents physically based in Singapore
  • Trainee must achieve 100% attendance and pass all relevant assessments
  • Sponsoring company must be
    • Singapore-based financial Institutions regulated by MAS (licensed or exempt from licensing by MAS)
    • FinTech firms certified by Singapore FinTech Association
  • NTUC LearningHub reserves the right to claw back the funded amount from the employer if trainee did not fulfil the eligibility criteria
  • Eligible company-sponsored trainees will be able to clock CPD hours upon successful course completion

 

Remarks:

Individual Sponsored Trainee

Company Sponsored Trainee

SkillsFuture Credit:

  • Eligible Singapore Citizens can use their SkillsFuture Credit to offset course fee payable after funding

 

UTAP:

  • NTUC Members can enjoy up to 50% funding (capped at $250 per year) under Union Training Assistance Programme (UTAP)

Training Allowance Grant (TAG):

  • $10/hr of eligible training and assessment hours
  • Applicable for classes commencing between 1st Jul 2021 to 30th Jun 2022 (both dates inclusive)
  • TAG will only be disbursed to the eligible sponsoring companies upon the participants’ successful completion including fulfilling 100% attendance requirement and passing the assessments.

 

Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees.

What Others Also Enrolled In