QLIKVIEW
DESCRIPTION
Course Content
Introduction
QlikView Developer course structure is a mixture of demonstrations and hands on exercises of the many QlikView components. Topics covered in this course, include fundamental user interface layout and design best practices. QlikView Designer course focuses on QlikView application, objects such as sheets, listboxes and charts, working with scripts, best practices, loading data, deploying QlikView applications.
Total Duration
25 hrs.
Who should attend?
Developers, Designers & Power End-Users
Pre requisites for attending QlikView Training
1. Basic SQL Knowledge
OBJECTIVE of the Training:
1. Real time project Application development.
2. Hands on practice data modelling with Star Schema (Link table) and Snow Flake schema.
3. Script level functions and chart level functions knowledge.
4. Design techniques and short cuts about the less time.
5. Publishing the document in server and access over web.
Course Outline
Module -1 (7 Hours)
1. USING QLIKVIEW 11.0 SR-2 PERSONAL EDITION
1.1 Starting QlikView
1.2 Basic Layout and Navigation
2. SHEETS AND SHEET OBJECTS
2.1 Sheet Basics
2.2 Sheet Objects
2.3 Exercises: Creating Your Workspace
3. LOADING DATA INTO QLIKVIEW
3.1 Script editing
3.2 Edit Script Toolbar
3.3 Edit Script Menu Commands
3.4 Statements Area
4. CREATING THE SCRIPT
4.1 Script generation
4.2 Creating a connection to the database
4.3 Reading tables into QlikView
Module -2 (8 Hours)
5. SCRIPTING CONSIDERATIONS and Data Modelling
5.1 Reading the QWT MDB.
5.2 Synthetic key tables
5.3 Circular references
5.4 Causes of circular references
5.5 Loosely Coupled Tables
6. LOADING AN XML FILE
6.1 Loading a text file in XML Format
6.2 Renaming fields using the Qualify statement
7. ENERATING DATA IN THE QLIKVIEW SCRIPT
7.1 Resident Load
7.2 Inline tables
7.3 Auto generate tables
8. MAPPING TABLES
8.1 Mapping Quarters to the Orders table
8.2 Month Year
8.3 Cleaning up the table structure
Module -3 (10 Hours)
9. QLIKVIEW DATA (QVD) FILES
10. QLIKVIEW SECURITIES
11.ADVANCED SCRIPTING
12.SET ANALYSES
13.MOST OF THE UNKNOWN QLIKVIEW FUNCTIONS
14.ALERETS AND TRIGGERS
15. REPORTS FOR PDF
16. MISCELLANEOUS TOPICS