QLIKVIEW

QLIKVIEW

Overview:
QLIKVIEW is software QLIKVIEW is a Business Intelligence (BI) data discovery product for creating guided analytics applications and dashboards tailor-made for business challenges It is mainly used for building dashboards(reporting) and data visualizations using the organization’s data,

Training Objectives Of QLIKVIEW
Being one of the advanced courses to achieve high accuracy to do smart work, QLIKVIEW Course helps many management level Understand Data Interpretation to make suitable visualizations To learn reporting through the smart Qlik view technology

Target Students / Prerequisites:
To be able to learn and excel in Qlik view course, fundamental SQL knowledge is very much needed.

Course Contents:
Introduction
What are Traditional BI and In Memory BI?
Introduction to QLIKVIEW
Difference between Traditional BI tools and QLIKVIEW

QLIKVIEW Basic concepts
How to start the QLIKVIEW
Dashboard and Analysis
QLIKVIEW environment
QLIKVIEW Data Loading
How to load data
Different ways of loading the data
Loading from excel, DB
Inline load, resident load and preceding load

DB concepts
Primary key and foreign keys
Synthetic keys
Dimension table and Facts table
Star and Snow flake schema

QLIKVIEW Architecture
QLIKVIEW Design Concepts
Document properties
Sheet properties
Different Sheet Objects
List box and its properties
Multi box
Table box
Text object
Button object
Input box
Statistics box
Bookmark
Container object
Setting menu and other tool bars

Charts
Creation of charts
Single and multidimensional charts
Chart properties
Common functions in charts
Fast change property
Dynamic coloring and Custom sorting

QLIKVIEW Data files
QVD file format
Creating QVDs
Use of QVD files
Internal memory of QVD

Pivot Table and straight tables
Advanced Scripting
Set Analysis and indirect set analysis
What-if analysis
Concatenation
Types of joins
Types of keep
Mapping tables
Let and set commands
Date functions
Incremental and resident load
Different function in scripting
MTD and YTD

Security
Optimization of QV application
Performance tuning

Server QMC and Publisher (Administration) and access point.

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.