Toggle All Modules
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.
Data Warehouse Concepts:
Introduction of Data Warehouse
Need arise of DWH
OLTP V/S DWH
OLTP V/s OLAP
Data Warehouse /Data Marts Architecture
Dimensions (Simple and Confirm)
Fact (Simple, fact less, coverage, confirm)
Warehouse Implementation Methods
SNOW FLAKE SCHEMA
Difference between STAR and SNOW FLAKE Schema.
Other terminologies Cleansing, Purging etc.
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
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:
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
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)
Calculation and expressions
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.