Training-DWH

• Introduction
  • Brief about the Data warehouse
  • What is a Data Warehouse?
  • Inmon Vs Kimball approach
  • Is Data Warehouse still relevant in the age of Big Data?
  • Why do we need a Data Warehouse?
  • Characteristics of a Data Warehouse
• What is Business Intelligence?
  • Uses of Business Intelligence
  • Tools used for (in) Business Intelligence
• Components of a Data Warehouse
  • Purpose of a Staging Area in Data Warehouse Architecture
  • What is ODS?
  • Features and Benefits of ODS
  • Differences between ODS,DWH, OLTP, OLAP, DSS
  • OLAP Overview
  • OLTP Vs OLAP
• What is a Data Mart?
  • Fundamental Difference between DWH and DM
  • Disadvantages of a Data Mart
• What is Data Modeling?
  • Conceptual Model
  • Logical Model to Physical Schema
  • Understanding the Cubes
• Data Modeling Techniques
  • Entity Relational Data Model
  • Dimensional Model
• What is Dimension Modelling?
  • What is a Dimension?
  • What is a Fact?
  • Additive Facts
  • Semi-Additive Facts
  • Non-Additive Facts
  • FactLess Facts
  • What is a Surrogate key?
  • Star Schema
  • Snow Flake Schema
  • Differences between Star Schema and Snow Flake Schema?
  • Conformed Dimension
• Slowly Changing Dimensions – Intro and Example Creation
  • Slowly Changing Dimensions – Type 1, 2 and 3
• DWH Indexes
  • What is an Index?
  • Bitmap Index
  • B-Tree index
• Data Integration and ETL
  • Introduction to SAP Data Services