The different QlikView clients
QlikView Server
QlikView Publisher

Connection to relational databases
SQL queries
Integration of Excel files
Integration of other data sources: Flat files, Remote data, XML feeds, etc.

Workshop: Data loading

Introduction
Optimization of data models
Focus on temporal functions
Use of variables
Dealing with integration errors
Integration of text files
Integration of static data

Workshop: Language

Overview
Using the Table Viewer
Simplify Synthetic Keys
Resolve Circular References
Rules for Associative Relationships
Join and Concatenate Tables
Document the Model (Comments and Tags)

Lab: Using data models

Manage evolutionary values ​​(interval match)
Calculations with entered data (budget example)
Set operators (set analysis)

Workshop: Advanced functions

Verification and optimization of relationships
Performance tuning
Scenarios of data integration in incremental mode

Workshop: Performance validation

Managing access rights to applications
Finalizing a first Qlikview application

Workshop: Security