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
- The future of Data warehousing
ETL Processes & Tools
- Requirements For Data Warehousing
- ETL Tool & Hand Coding
- Extracting
- Cleaning and Conforming
- Delivering Dimension Tables
- Delivering Fact Tables
- Implementation and operations
- Metadata
- Real Time Streaming ETL Systems
- Tools
- Sample Tools
Data Quality Solutions and DVS
- Why you need higher quality data?
- Data Quality Processes
- Data Consistency
- Data Validation Methods
- DVS introduction
- Sample Scenario Design
- POC for your firm