QlikView Training

Overview

QlikView is the most flexible Business Intelligence platform for turning data into knowledge. More than 24,000 organisations worldwide have enabled their users to easily consolidate, search, and visually analyse all their data for unprecedented business insight using QlikView’s simplicity.

Effective decision-making is based on having the right information available and easy accessible. Taking just minutes to learn, the automatic associations of QlikView create endless possibilities for making ad hoc queries without requiring tediously defined structures and hierarchies, as is typical in other data analysis tools. QlikView promotes unrestricted analysis of application data, helping users make time-saving and accurate decisions.

qlikview Training

    This Qlikview course is designed for all major roles on a DW/BI project, including Mainframe Developers, Software Testing Professional, Oracle SQL and PL/SQL Developers, project managers, business analysts, data modelers and database administrators, architects, and ETL or BI application designers/developers.

 

Course Outline

BI and 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, fact less, 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 –ROLAP/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,multibox
  • Calculation and expressions
  • Reporting formats
  • Server setup
  • Publisher
  • Alerts
  • Bookmark