QlikView Certification Training

✔ 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

✔ Data structures in QlikView (AQL).
✔ Sample Application walkthrough of QlikView
✔ Architecture and components of QV
✔ In-memory BI /OLAP
✔ Loading data from multiple data sources:
✔ 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

✔ 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,and graph
✔ Multidimensional, gauges,multi-box
✔ Calculations and expressions
✔ Reporting formats
✔ Server setup
✔ Publisher
✔ Alerts
✔ Bookmark