Introduction

What is Qlikview?

Why Qlikview?

Unique Features compared to Traditional BI Tools

Complete Dataware Housing Basics 

QLIKVIEW PRODUCTS:

Desktop

Server

Publisher

AccessPoint 

ROLES INVOLVED:

Developer

Designer

Administrator 

DEPLOYMENT PROCESS:

Standalone

Server

Publisher 

INTRODUCTION TO DATA AND SCRIPTING:

Relational Databases

Dimensional Data Structures

Comparing Data Models to QlikView Data Model

Data Structures in QlikView

Data Source Files

The QWT Primary Data Source

The QWT Secondary Data Files

Edit Script Explanation 

LOADING DATA FROM THE DATABASE:

Script Generation

Comments in the Script

Script Debugging 

STRUCTURING THE SCRIPT: 

Creating Tabs in the Script 

BASIC DATA MODEL AND TABLE VIEWER:

The Table Viewer

The System Table

Explanation of Document Properties 

BASIC DATA TRANSFORMATION: 

Load data from multiple data sources

Renaming a Field

Script Expressions

Loading an XML File

Renaming Fields Using the Qualify Statement

Key Fields

Loading Generic Tables

Including Images and Media content

Loading a Field into a Table Multiple Times

Using a Record Counter on Key Fields

Loading Cross Tables and Info Tables

Handling Null Values

Changing Date Formats

Changing Metadata

Complete discussion about concatenation

Resolving Synthetic Keys

Resolving Loops

Preparing QVD Files

Performing Incremental Loads

Optimization Techniques at Script Level