Qlikview

Course Overview:

This Training will help you become an expert in Data Visualization with QlikView. Along the course, you will be transforming data into interactive charts and graphs using QlikView features like dashboards, system table, incremental load and object formatting.

Course Content:

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

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.

Quick Enroll