DATA MODELLING FOR QLIK SENSE PART 2-P210321VXO

DATA MODELLING FOR QLIK SENSE PART 2-P210321VXO

Funded
Course Duration
7.5 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

  • You will acquire deep skills to cleanse and transform source data, resolving data model issues and optimize performance.
  • Use Set Analysis to optimize query

Course Overview

This one day course will provide the necessary skills to optimize query with Set Analysis, resolving data model issues, optimization for performance, using QlikView Data Files (QVD) files, application development on Qlik Sense server

Course Schedule

Next available schedule

Course Objectives

  • Review Important Data Modelling Features of Qlik Sense
  • Synthetic keys and circular references
  • Mapping Tables & Joins
  • Set Analysis
  • Basic and advanced expression calculations
  • Development Considerations & Section Access

Pre-requisites

Course Outline

Module 1: Data Model Transformation

Discuss synthetic keys and circular references

Mapping tables

  • Mapping tables
  • Preceding Load on preceding Load

Joining tables

Concatenation

  • Preventing concatenation
  • Concatenation rules

Module 2: Additional Data Model & Interface Concepts  

Set analysis

  • Set analysis and set expressions
  • Set identifiers
  • Set modifiers
  • Set operators

Module 3: Development Considerations & Section Access

Performance considerations

  • Factors affecting the size of an app
  • Best practices for Qlik Sense app optimization
  • Development considerations

Managing security with Section Access

  • Section access
  • Dynamic data reduction
  • Best practices for Qlik Sense app optimization
  • Development considerations

Managing security with Section Access

  • Section access
  • Dynamic data reduction

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 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) $1,000.00 $1,070.00 $1,000.00 $1,070.00
For Singapore Citizens and PRs $144.00 $214.00 $200.00 $270.00
(after 80% funding)
For Singapore Citizens aged 40 years and above $37.00 $107.00 $100.00 $107.00
(after 90% funding)

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.

 

About IBF Certification

This course addresses the following Technical Skills and Competencies (TSCs) and proficiency level:

  • Data Mining and Modelling (Proficiency Level 3)

Participants are encouraged to access the IBF MySkills Portfolio (https://www.ibf.org.sg/programmes/Pages/MySkills-Portfolio.aspx) to track their training progress and skills acquisition against the Skills Framework for Financial Services. You can apply for IBF Certification after fulfilling the required number of Technical Skills and Competencies (TSCs) for the selected job role.

Find out more about IBF certification and the application process on https://www.ibf.org.sg/certification/Pages/Why-be-Certified.aspx

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