Session : 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
Session : 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
Session : 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
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.