Qlikview Training Chennai

Module 1

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

Module 2

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– ROLAP/MOLAP/HOLAP

QlikView data structures

Data structures in QlikView (AQL)

Sample Application Walkthrough of QlikView

Architecture and Components of QV Inmemory BI /OLAP

Module 3

Loading Data from Multiple Datasources

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

Big Data Analytics

Connecting of Qlikview with Bigdata hadoop

Module 5

Advanced Scripting

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

Module 4

Sheet Basics

Sheet Objects

Text,list,chart,graph-Multidimensional,gauges,multibox

Calculation and expressions

Reporting formats

Server setup

Publisher

Alerts

Bookmark

Back