QlikView Data Modeller

Course Overview

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

Course Dates

 Select a date to enrol.
  • 1 Jul 2020
    Virtual , 10:00 - 17:00 (Central European Time)
    6 seats left

Have a question?

Get in touch, we're here to help.

H

Or call us

+44 7552 111329
+34 650 451 861