QLIKVIEW

QlikView Business Intelligence

Duration of       Hours 

HRS

Duration time may vary depends on course progress

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.

Course Content

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.

Have some Questions?

Call us at our care or drop quick contact box

Why with us?
  • Live Quality Training 

  • Live demonstration of of features and practicals.

  • 100% Assurance Placement Assistance

  • Effective Resume building

  • Internship Program for real exposure

  • Interview preparation with mock interview drills

  • Process of applying jobs at right places

  • Guidance of getting flexible, part time jobs

Our chanel partners : AlightPro | Career ITS

© Copyright © 2008 ProCareer Inc. All rights reserved.