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