QlikView Training Module

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.
  • Duration

    40 Hours

    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

    You have gone through all the training and reading material, since you decided to choose your career. This might have given you initial understanding about the procedures and techniques and you are even able to pass your certification as well ...

    Best - SAP training center in London.