+91-80999 02123201-710-8393

Qlikview Online Training

Course Duration: 30 hours

QlikView Desktop - Version 11.0 SR2

Course Description:

This 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. It also covers how to view and read QlikView application and objects such as
sheets, list boxes, various charts and graphs. All the basic knowledge required to get started with QlikView.

It also focuses on the development side, learning about the script, best practices, loading data and how to deploy QlikView applications. It also covers data modeling and related issues such as database connectivity, advanced scripting and more complex data modeling issues.
Recommended Prerequisite Course(s): Data warehousing concepts, SQL.
Recommended Reading: The Data Warehouse Life Cycle Toolkit, by Ralph Kimball.

Course Outline:

1. USING QLIKVIEW 11.0 SR-2 PERSONAL EDITION

  1. Starting QlikView
  2. Basic Layout and Navigation

2. SHEETS AND SHEET OBJECTS

  1. Sheet Basics
  2. Sheet Objects (List Boxes, Charts, Sliders/Input Box, Containers, text boxes, table box etc)
  3. Exercise – Creating Your Workspace

3. LOADING DATA INTO QLIKVIEW

  1. Script editing
  2. Edit Script Toolbar
  3. Edit Script Menu Commands
  4. Statements Area

4. CREATING THE SCRIPT

  1. Script generation
  2. Creating a connection to the database
  3. Reading tables into QlikView

5. SCRIPTING CONSIDERATIONS and Data Modeling

  1. Synthetic key tables
  2. Circular references
  3. Causes of circular references
  4. Loosely Coupled Tables

6. LOADING DATA

  1. Loading from different data sources.
  2. Renaming fields using the Qualify statement

7. GENERATING DATA IN THE QLIKVIEW SCRIPT

  1. Resident Load
  2. Inline tables
  3. Auto generate tables
  4. MAPPING TABLES
  5. Mapping Quarters to the Orders table
  6. Month Year
  7. Cleaning up the table structure

9. QLIKVIEW DATA (QVD) FILES

10. QLIKVIEW SECURITIES

11. ADVANCED SCRIPTING

12. SET ANALYSES

13. COMPARATIVE ANALYSES

14. MOST OF THE UNKNOWN QLIKVIEW FUNCTIONS

15. ALERETS AND TRIGGERS

16. REPORTS FOR PDF

Address

#3-5-839/6, 104, 1st Floor, LR Plaza, Beside Bharat Petrol Pump, Hyderguda,
Hyderabad - 500 029

Phone     : 040- 6464 5154
Email      : info@careeronlinetrainings.com
Website : www.careeronlinetrainings.com

Skype ID : careeronlinetrainings

Testimonials

The course content was appropriate and useful. The online trainers were competent and useful. The best thing about the course was the young learner and learning Vs acquisition section.

The thing that the course needs improvement is the format of the assignment

Keerthi
Hyderabad.

I am Mushtak Shaik from Hyderabad. The course content was appropriate and useful. The online trainers were competent and useful.

The thing that the course needs improvement is the format of the assignment


Mushtak Shaik
Hyderabad.