QlikView Training Course Content

1. Introduction to QlikView

What is BI?
Introduction to Visualization
Different BI Tools
What is QlikView?
Features and components of QlikView
Architecture
Installation & Navigation
Data Ingestion
Report Interface
QVS, QVW and .log files
Sheet Objects
Dimensions and Expressions
Presentation/ Layout / Sort tabs

Hands On/Demo:
Downloading and Installing QlikView
Creating a List Box

2. Scripting

Need of Scripting
What is Scripting?
Script Toolbar
Script Menu Commands
QlikView Variables (Set,Let) and Fields
Creating tabs in the script
Adding Sheet Objects
Inline table
Function in QlikView (Sum, Avg, Count, Date, etc)
Joins: Inner, Left, Right and Outer
Understanding Keep command

Hands On/Demo:
Edit Script
QlikView Operations: Concatenate, If statement
Create variables, Inline load, Functions and Joins

3. Data Model

QlikView Data File Types: QVD, QVX
System fields
Star schema
Synthetic Key Tables
Circular References & its causes
Ways to Resolve Synthetic Keys and Circular Reference
Using Qualify & unqualify
Link Table
Concatenation: Forced, Auto, No
Data Model optimization
Master Calendar

Hands On/Demo:
Star Schema, Synthetic key, Circular reference
Concatenation, Qualify & Unqualify

4. Data Transformation

Generating data in the QlikView Script
Different Type of Loads
Incremental load with QVD file
Column manipulation
Tables: Rotating, Straight and Pivot, Cross
Mapping Table
Security – Section Access and Control

Hands On/Demo:
Preceding load, Resident load & Incremental Load
Rotating, Pivot, Cross & Mapping Tables
Security with Section Access

5. Charts & Advanced Functions

Sheet Objects: Slider Text Box, Calendar Box, Current Selections Box
QlikView Advance Functions: Apply map, match, Peek, pick, lookup,exist, not exist, AGGR , rank, rangesum, class, date and date#, Valuelist
Chart object menu
Visualization Charts: Bar chart, line, combo, radar, scatter, grid, pie, funnel, block, gauge, mekko
Chart Formatting
Information density Subset Ratio and Perfect Key
Triggers
Alternate State
QlikView Management console: Server, Publisher

Hands On/Demo:
Advanced QV functions
QlikView visualization charts: Bar, line, Combo, Radar, Scatter, Pie, Grid, Funnel & Mekko
Chart Functions

6. Data Analysis

Set Analysis (Indirect Set Analysis, Identifiers, Modifiers & Operators)
What-if Analysis
Comparative Analysis
Dynamic Reporting or Ad-hoc Reporting.
Document Channing
How to select range of Dates
Information density Subset Ratio and Perfect Key
AND Mode
Document Analyzer
Exception Handling
Buffer load
Qlikview cals
Qlikview sap connector
Qlikview sales force connector
Macro
Geolocation
Web Connectors
Conditionally Enabling Dimensions

Hands On/Demo:
What-If Analysis, Comparative & Set Analysis

Getting the right solution based on the criteria curated by SoftPro9 Team