Qlik Sense Data Modelling

Course Fee -  Est S$12,000 for 10 pax Course duration: 3 days

On-demand
09:30 am - 05:30 pm
600 North Bridge Road #12-05, Parkview Square, Singapore 188778

Course Description

This is a technical course designed to equip participants with the skills needed to craft a robust data model in Qlik Sense, firmly rooted in industry-leading practices. Combining demonstrations and hands-on exercises, the training delves into topics such as data transformation, data model architecture, and advanced application development within the Qlik Sense Enterprise environment.

Prerequisites

  • Participants should have prior experience with Qlik Sense and be familiar with its basic concepts.
  • Participants are required to bring their own internet-enabled laptop (Windows or macOS).

Target Audience

  • Data Architects; Business Analysts
Register

Course Outline

Topic 1 : Introduction to Data Load Editor

The Data Load Editor is an integral part of the data preparation process in Qlik Sense and is typically used by data analysts, developers, and administrators to perform tasks such as data extraction, transformation, and cleansing.

Topic 2 : Loading and transforming data using Data Load Editor

Learn to connect to multiple data sources and transform the data using Qlik powerful scripting language.

Topic 3 : Data modelling best practices

Learn to define the structure of the data model, including data tables, fields, and relationships between tables. Learn how to architect a robust data model, steering clear of common pitfalls like synthetic keys and circular references that can lead to suboptimal results.

Topic 4 : Advanced scripting techniques

Learn to work with QVD, apply mapping tables, perform table concatenation/joins to streamline data integration and enhance data enrichment.

Topic 5 : Set Analysis

Learn to use set analysis to create dynamic and customized data analyses and visualizations.

Topic 6 : Debugging

Learn to verify that code behaves as expected and to troubleshoot issues before deployment.

Topic 7 : Security

Learn to maintain data security and ensure that users only access the data they are authorized to see.

Topic 8 : Advanced Visualization Design

Learn to create sophisticated charts by incorporating custom sorting techniques and personalized dimension value coloring. Explore the flexibility of user-selectable dimension limitations and delve into the realm of charts with alternate states. Learn to apply theme to maintain a consistent branding across all Qlik Sense applications, and unlock a plethora of advanced features to elevate your data visualization skills to new heights.

On-Premise Training

Organizations may request to have the training conducted on their premises instead of Sift’s office.  To do so, here are the prerequisites: 

  • Room and projector availability.
  • Students must bring their own internet-enabled laptop (Windows or macOS).
  • Each student will be provided with a Qlik Sense Professional license for use on SIFT’s Qlik Sense Enterprise Server in the cloud (Client-Managed version). Therefore, it is imperative to have a designated room equipped with public-facing WIFI to enable students to access the cloud-based resources.

Enquire / Register for this training course.

( Qlik Sense Data Modelling )

    Contact Person’s Information

    Participant’s Information

    Note: If you are registering only for yourself, enter your details for both 'Contact Person' and 'Participant'.