30 Hours Qlikview training from certified Qlikview Specialist.

Pre requisites for attending QlikView Training

1. Good SQL basics

OBJECTIVE of the Training:

1.      Industry style application development.

2.      Data modeling Including scenarios with multiple fact tables

3.      Different types of loads.

4.      Variables and dollar expansions

5.      Join methods

6.      Script level functions, Inter-record functions and chart level functions with appropriate examples

7.      Hierarchies (Drill down groups)

8.      Cyclic expressions

9.      Reload techniques

10.  Images in qlikview

11.  QVD Optimization techniques

12.  Section Access

13.  Publishing the document in server and access over web.

14.  Time-series

15.  Mock interviews

16.  Project work

Course Outline

Day 1 (1.5 Hours)

Installation and IDE

Starting QlikView
Basic Layout and Navigation
Sheet Basics
Sheet Objects
Creating Your Workspace

Day 2 (1.5 Hours)

Loading data into qlikview
Script editing
Statements Area
Script generation
Creating a connection to the database
Reading tables into QlikView

Day 3 (1.5 Hours)

Resident Load
Inline tables
Auto generate tables
Mapping load
Bundle load

Day 4 (1.5 Hours)
Variables
Variables in Qlikview
Dollar Expansion and Double dollar Expansion

Day 5 (1.5 hours)
Alternate states
Alternate states in comparison
Alternate states used in isolation

Day 6, 7 (3 Hours)
Modeling
Synthetic key tables
Circular references
Causes of circular references
Multiple fact tables and various ways to design it
Degenerate dimensions
Generic Key tables

Day 8 (1.5 Hours)
Time series with Qlikview, YTD/MTD/WTD/YTD LY/MTD LY/WTD LY

Day 9 (1.5 Hours)
Qlikview Security
Section access based on inline data.
Section access based external DB tables.
Hidden Script.
Section access based on NT User.
Data reduction based on the user.
Data Hiding based on the user.

Day 10 ( 1.5 Hours)
Qvd Files, usage with practical examples

Day 11 ( 1.5 Hours)
Set analysis
Set analysis with alternate states
Complex expressions with set analysis

Day 12 ( 1.5 Hours)
Various qlikview functions with practical examples

Day 13 ( 1.5 Hours)
VB Scripts

Day 14 ( 1.5 Hours)
Various loads in Qlikview.
Different types of Joins in Qlikview.

Day 15 ( 1.5 Hours)
Qlikview Extensions

Day 16 ( 1.5 Hours)
Qlikview Publisher

Day 17 ( 1.5 Hours)
Qlikview Licensing

Day 18 ( 1.5 Hours)
Qlikview Management Console

Day 18 ( 1.5 Hours)
Advanced Functions in qlikview

Day 20 ( 1.5 Hours)
Mock Interview

*Various charts and usage will be covered as part of the topics listed
Mock interviews conducted individually at your convenience
Reasonable On-job support

Please write to teachbiram@gmail.com for details on demo and course timings.