Qlik Developer Training Workshop

BME Solutions - One Day Training in Qlik Developer

Qlik Developer Overview

Introduction

This one day workshop consists of hands on exercises providing knowledge on Qlikview scripting and data source integration. It aims to give attendees a good start in developing applications in QlikView. It covers data modelling, loading data, connecting to databases and an introduction to the Qlikview scripting language. The emphasis will be on applications containing Student Data.

Topics covered

Attendees will perform instructor-led exercises that cover the following elements of Qlikview

Data Formats
Script Editor
Loading Data
Database Loads
Connect
Select
Excel Wizard
Naming Tables
Join Tables
Renaming Fields
Where Statement
Where Exists
Synthetic Keys
Creating Composite Fields
Star and Snowflake Schemas
Combining Data
Concatenate

Noconcatenate
Join
Data Transformation
String Manipulation
Date Functions
If Statement
In Line Tables
Apply Map and Mapping tables
Lookup
Debugger
Resident Load
Drop Table and Field
Interval Match
QVD Files
Create a QVD
Load from a QVD
QVD Optimization

Prerequisties

The Qlik Application Design workshop. A basic working knowledge of databases and SQL would be advantageous.