MODULE-1: INTRODUCTION TO QLIKVIEW

·         Associative Concepts

·         Difference Between QlikView and other BI tools

·         Architecture of QlikView

·         Components of  QlikView

·         Roles Involved

·         QlikView Development Environment

 MODULE-2: QLIKVIEW INSTALLATION

·         ​Software Installation

·         Setup & Configuration

·         Creating QlikView Application

 MODULE-3:  WORKING WITH QLIKVIEW DESIGNER

·         Layout Design

·         Sheets and Sheet Objects

·         Document Properties

·         User Preferences

·         Queries in QlikView

MODULE-4:  WORKING WITH SHEET OBJECTS

·         List Boxes and Statistics Boxes

·         Bar Charts and Pie Charts

·         Pivot Tables

·         Multi Boxes, Tables Boxes and Input Boxes

·         Button, Text Object and Line/Arrow Objects

·         Sliders, Current Selection Objects and Book Mark Objects

MODULE-5:  WORKING WITH SCRIPT EDITOR

·         Creating a New Document

·         Variables

·         Set and Let Statements

·         Loading Data using Text Files

·         Loading Data using XL files

·         Loading Data from other formats

MODULE-6:  WORKING WITH RELATIONAL  DATABASES

·         Connecting to Relational Database using ODBC

·         Loading Data using Database File

·         Data Association from Many Tables

·         Table Viewer

·         Concatenate Tables

·         Link Tables

·         Linking External Information to Document

MODULE-7:  WORKING WITH QVD FILES

·         Creating QVD Files

·         Loading Data from QVD Files

·         Loading Data using Multiple QVD Files

·         Resident Data Load

·         Relative Paths

MODULE-8:  ADVANCED FEATURES

·         More about Associations

·         Set Analysis

·         In Line Data Loading into Existing or New Tables

·         Creating Filed Groups

·         Creating Cross Tables

·         Handling of Numeric Data

·         Adding URL to Dimension

·         Incremental Data Loading into QVD files

·         QlikView Functions

MODULE-9:  MORE ADVANCED FEATURES

·         QlikView Security

·         Access Control Database

·         Source/Version Control

·         Introduction to QlikView Publisher

·         Introduction to QlikView Server

MODULE-10: DEVELOPMENT OF QLIKVIEW REPORTS

·         Create Reports from existing objects

·         Create Reports from the beginning

·         Copy / Import Reports

MODULE-11: DEVELOPMENT OF BUSINESS INTELLIGENCE PROJECT

·         Star Schema Model

·         Design and Develop Sample Data Warehouse

·         Load Data into QlikView

·         Design and Develop Sample Dashboard, Charts and other QlikView Objects

Classes: 20 Hours

Lab Sessions: 20 Hours

Duration: 4 Weeks

Course FEE: $450