datawarehousing

CH 01 - Data Warehousing Concepts

· What are DW and BI? Differences.
· Introduction to (DW) Data Warehouse.
· Introduction to (BI) Business Intelligence.
· RDBMS – Concepts – Structures and Indexing.
· Need for a Warehouse ?
· Advantages and disadvantages of Warehousing.
· OLTP & OLAP Databases
· Dimensions and Facts.
· Data Marts – Need, Advantages and Differences between Warehouse.
· ODS -Need, Advantages and Differences between Warehouses.
· Data Models and Design Operators.
· Drill up & Drill Down and Slicing & Dicing of data.
· DMR, ROLAP, MOLAP and HOLAP.
· Data Mining, Data Cleansing and Data Integrating.
· ETL – Extract, Transform and Load Process.


CH 02 - Architecture of Data Warehouse


· Data Warehouse Life Cycle – Architecture
· Characteristics of a Data Warehouse
· OLAP Databases and Differences
· Dimension Tables, Fact Tables (Attributes & Measures)


CH 03 - Types of Dimensions and Fact Tables


· Slowly Changing Dimensions
· Surrogate Key
· Degenerate Dimension
· Conformed Dimension
· Time Dimension
· Fact Less Fact tables


CH 04 - Dimensional Modeling Layouts


· Dimension and Fact Tables
· Star Schema
· Snow Flake Schema
· Multi-Star Schema
· Multi- Snow Flake Schema


CH 05 - Data Warehouse Modeling Techniques

· Normalization and De-Normalisation.
· Multi-Dimensional Modelling.
· DFD - Data Flow Diagrams.
· E-R - Entity Relationship Diagrams.
· Relational Modeling and Dimensional Modeling .
· Designing Star Schema, SnowFlake Schema and Multi-Star Schema.


CH 06 - Data Load Types


· Load Jobs
· Full Initial Load
· Incremental Loading