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
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
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
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
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
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
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.
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
Qvd Files, usage with practical examples
Day
11 ( 1.5 Hours)
Set analysis
Set analysis with alternate states
Complex expressions with set analysis
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
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.
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
Qlikview Extensions
Day 16 ( 1.5 Hours)
Qlikview Publisher
Day 17 ( 1.5 Hours)
Qlikview Licensing
Day
18 ( 1.5 Hours)
Qlikview Management Console
Qlikview Management Console
Day
18 ( 1.5 Hours)
Advanced Functions in qlikview
Advanced Functions in qlikview
Day
20 ( 1.5 Hours)
Mock Interview
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
Mock interviews conducted individually at your convenience
Reasonable On-job support
Please write to teachbiram@gmail.com for details on demo and course timings.
