QlikView

Reading Time: 2 minutes

QlikView

    Module 1: 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

    Module 2: 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

    Module 3: 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