Qlikview Training

Qlikview Syllabus

 

Introduction

What is Business Intelligence?

  • What is the Business intelligence tool in It Industry?
  • Why Choose QlikView

First Steps

Data Warehouse Concepts

  • Introduction of Data Warehouse
  • Need arise of DWH
  • OLTP V/S DWH
  • OLTP V/s OLAP
  • Data Warehouse /Data Marts Architecture
  • Staging/without Staging
  • Dimensions (Simple and Confirm)
  • Fact (Simple, fact less, coverage, confirm)
  • Warehouse Implementation Methods
  • STAR SCHEMA
  • SNOW FLAKE SCHEMA
  • Difference between STAR and SNOW FLAKE Schema.
  • Other terminologies Cleansing, Purging etc.
  • Database Modeling
  • Designing Methods
  • Logical Designing
  • Physical Designing
  • Introduction of Dimension Modeling
  • Difference between ER-Modeling and Dimension Modeling
  • Implementation of Dimension Model
  • Forward Engineering and Reverse Engineering
  • Introduction of various Database Components
  • OLAP ?OLAP/MOLAP/HOLAP

QlikView data structures:

  • Loading data from different sources in QlikView.
  • Introduction to QVD and how does it work?
  • What is Table Viewer?
  • Data structures in QlikView (AQL).
  • Sample Application walkthrough of QlikView
  • Architecture and components of QV
  • In-memory BI /OLAP
  • Loading data from multiple data sources:
  • Script editing
  • Menu Commands and Syntax
  • Handling DATA SOURCE FILES
  • The QWT (Access File example) primary data source
  • The QWT (Access File example with QVD Conversion) secondary data files
  • Script generation
  • Creating a connection to the database
  • Reading tables into QlikView

Objects and Properties

  • Sheet object and Tab with their properties
  • List Box, Multi-Box, Current Selection Box, Search Box
  • Chart Objects and their properties
  • Use of Object Container
  • Expression writing and read about basic functions

Data Transformation

  • Loading Cross Table, Loading Inline Table
  • Loading data from already stored data in QlikView (Resident Load)
  • Joins, Concatenation of tables
  • Use of Mapping Tables
  • Synthetic Keys and ways to remove it
  • Incremental Load in QlikView
  • Partial Load

Advance Visualization techniques

  • Conditional Formatting In QlikView
  • Gauge Chart, Thermometer and Waterfall chart
  • Enable dimension and expression
  • Adhoc Reporting in QlikView
  • Cyclic and drill groups

ADVANCED SCRIPTING:

  • Set Analysis
  • Build expression using variables (Dollar expansion
  • Condition on a field in a table
  • Aggregating Data in Script (Resident Load and Group Function, Order By etc)
  • Joining tables (Left, Right, Inner, Outer Joins)
  • Concatenation
  • Sheet Basics:
  • Sheet Objects
  • Text,list,chart,graph
  • Multidimensional,gauges,multibox
  • Calculation and expressions
  • Reporting formats
  • Server setup
  • Publisher
  • Alerts
  • Bookmark
  • Hidden Script
  • Section Access
Quick Enroll