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).
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.