Data Modeling for Qlik Sense

Registration for Data Modeling for Qlik Sense
1,050.00 € 1050.0 EUR
Qty

General info

This is a two-day training course. Select the desired start date at the top right of the screen for practical information regarding the training (location, price, registration, etc.).

Course overview

Data Modeling for Qlik Sense is a technical course for you to learn to develop a coherent data model in Qlik Sense by loading and transforming multiple data sources. With information, tools, techniques, and exercises, this course includes topics dealing with: maintaining data connections, transforming source data, architecting data models, optimizing for performance, and application development on Qlik Sense Enterprise.


Who should attend this training

This course is intended for more technical people , typical from IT departments or technical business users.


Course Objectives

At the end of this course you are able to:

  • Create a data model in Qlik Sense
  • Use the Data Load Editor and the Data Manager
  • Create and maintain data connections
  • Resolve data structure issues and script errors
  • Transform data for better performance
  • Discuss synthetic keys and circular references
  • Add dimensions and measures to the master library
  • Add visualizations to test your datamodel with Qlik Sense


Prerequisites

We recommend that attendees of this course have a basic knowledge of SQL and VB or Java script. 


Course Content

Day 1

  • Connection to Database: ODBC, OLEDB, Excel, XML, include files
  • Importing data to Qlik Sense using Data Manager (visual preparation of a data model)
  • First steps of importing data and creating a Qlik Data model via the Script Editor


Day 2

  • Joining, Applymap, Resident, Concatenation etc techniques
  • Optimizing Data model
  • QVD files
  • QVD in practice aka ‘the big exercise
  • Security
  • Linktable, date island, Interval match, Aggregation
Event Dates
Tuesday
May 30, 2023
Europe/Brussels
Location

The Campus

The Campus
Veldkant 33A
2550 Kontich
Belgium
+32 472 58 74 86
hello@thecampus.be
Get the direction
GENERAL INFO

This training will be held in English unless all attendees speak Dutch.

SHARE

Find out what people see and say about this event, and join the conversation.