A – Modeling for Data Warehouses and Datamarts

Business Intelligence and Data Warehousing
What Is Data Modeling & why is it important
Data Modeling Basics
Data Warehouse and Datamart Architectures
Data Modeling for the Data Warehouse and Datamarts
Multidimensional Modeling
Datamart models
Modeling Epilogue

B – Extract Transform Load Processes

Requirements For Data Warehousing
ETL Tool versus Hand Coding
ETL Data Structures
Extracting
Cleaning and Conforming
Delivering Dimension Tables
Delivering Fact Tables
Implementation and operations
Metadata
Coding Naming Standards
Responsibilities ? DW Team
Real Time Streaming ETL Systems
The Future of Data Warehousing

C ?Tools

ETL ? ELT Tools
Sample Applications