QLICK VIEW

QlikView Training Syllabus

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
  •  SNOW FLAKE SCHEMA
  •  Difference between STAR and SNOW FLAKE 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:

  •  Data structures in QlikView (AQL).
  •  Sample Application walkthrough of QlikView
  •  Architecture and components of QV
  •  In-memory BI /OLAP
  •  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

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
  •  Sheet Basics:
  •  Sheet Objects
  •  Text,list,chart,graph
  •  Multidimensional,gauges,multi-box
  •  Calculation and expressions
  •  Reporting formats
  •  Server setup
  •  Publisher
  •  Alerts
  •  Bookmark

Trainer Profile of QlikView
Our Trainers provide complete freedom to the students, to explore the subject and learn based on real-time examples. Our trainers help the candidates in completing their projects and even prepare them for interview questions and answers. Candidates are free to ask any questions at any time.

  •  More than 7+ Years of Experience.
  •  Strong Theoretical & Practical Knowledge.
  •  Certified Professionals with High Grade.
  •  Well connected with Hiring HRs in multinational companies.
  •  Expert level Subject Knowledge and fully up-to-date on real-world industry applications.
  •  Trainers have Experienced on multiple real-time projects in their Industries.
  •  Our Trainers are working in multinational companies such as CTS, TCS, HCL Technologies, ZOHO, Birlasoft, IBM, Microsoft, HP, Scope, Philips Technologies etc