Audience
This course is for developers, data architects, consultants, or anyone wanting to learn how load and transform data, follow best practices, and resolve common issues when building data models with QlikView.
Expectations
By the end of this course you will understand how to build performant data models with QlikView.
Equipment
To attend the course you'll need to bring a laptop running Windows and with QlikView Desktop installed.
Course Outline
This course covers the key concepts for creating your QlikView data model. Learn how to load data from multiple sources, transform and manipulate the data, different data structures, and which best practices to follow for optimum performance.
The new concepts you'll be introduced to are -
Introduction to QlikView
Data Modelling Concepts
Using the Script Editor
Structuring to your script
Load Statements
Table Viewer
Concatenating Tables
Table Joins
Useful String Functions
Building a Calendar Table
Mapping Tables
Debugging your Script
Circular References & Synthetic Keys
Composite Keys
Using QVD files
Set Analysis
Section Access