Data Modelling

Course Content
CHAPTER 1 Data Warehouse Basics
 An introduction to Data Warehousing
 Purpose of Data Warehouse
 Data Warehouse Architecture
 Operational Data Store
 OLTP Vs Warehouse Applications
 Data Marts
 Data marts Vs Data Warehouses
 Data Warehouse Life cycle
CHAPTER 2 Data Modeling
 Introduction of Data Modeling
 Different Phases of Data Modelling
CHAPTER 3 Multi-Dimensional Modeling
 What Is a Dimension in Data Modeling
 What are Facts?
 Multi-Dimensional Model
 Hierarchies, Data Modeling – OLAP
 Data Modeling – MOLAP
 Data Modeling – ROLAP
 Data Modeling – HOLAP
 Cubes and its Functions
 Star Schema
 Fact Table
 Dimensional Tables
 Snowflake Schema
 Fact less Fact Table
 Confirmed Dimensions
CHAPTER 4 Data Modelling Tools
 Introduction to Erwin
 Forward Engineering
 Reverse Engineering
 Update Model
 Alter database
 Complete compare 

149826204