Follow Us:

QlikView Training in Chennai


Course Duration

40 Hours
Sign in with Facebook Sign in with Facebook

About QlikView

  • QlikView is a flagged product of QlikTech Company and can be classify it to the category of Business Intelligence tools of the future.
  • This creates so many possibilities for making ad hoc queries in a non hierarchial data structure.
  • Course Contents

    QlikView
      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 ?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,multibox
    • Calculation and expressions
    • Reporting formats
    • Server setup
    • Publisher
    • Alerts
    • Bookmark
    Register Now

    You will Learn How To :


    Course Benefits :

    Register Now

    Please use the form below to make your career excellent.