Qlikview Training

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, factless, coverage, confirm)
• Warehouse Implementation Methods
• STAR SCHEMA
• SNOWFLAKE SCHEMA
• Difference between STAR and SNOWFLAKE 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,multi-box
• Calculation and expressions
• Reporting formats
• Server setup
• Publisher
• Alerts
• Bookmark
• Hidden Script
• Section Access