QLIKVIEW Business Intelligence

Qlikview Business Intelligence

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:
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
Container object
Setting menu and other tool bars

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
Types of joins
Types of keep
Mapping tables
Let and set commands
Date functions
Incremental and resident load
Different function in scripting

Optimization of QV application
Performance tuning

Server QMC and Publisher (Administration) and access point.