Get in Touch
 Duration 35 hours

Course Outline

Core Principles of Data Warehousing

  • Objectives, key components, and architectural structures
  • Data marts, enterprise warehouses, and lakehouse patterns
  • Fundamentals of OLTP vs OLAP and workload segregation

Dimensional Modeling Techniques

  • Facts, dimensions, and defining grain
  • Comparing star and snowflake schema designs
  • Managing Slowly Changing Dimensions (SCD) types

ETL and ELT Methodologies

  • Data extraction strategies from OLTP systems and APIs
  • Transformation processes, data cleaning, and conformance
  • Loading patterns, workflow orchestration, and dependency handling

Data Quality and Metadata Stewardship

  • Data profiling techniques and validation rules
  • Aligning master and reference data
  • Data lineage, cataloging, and documentation practices

Analytical Performance Optimization

  • Cubing concepts, aggregate management, and materialized views
  • Partitioning, clustering, and indexing strategies for analytics
  • Workload management, caching mechanisms, and query tuning

Security and Governance Frameworks

  • Access controls, role definitions, and row-level security
  • Compliance requirements and audit trails
  • Backup procedures, recovery strategies, and reliability standards

Contemporary Architectures

  • Cloud-based data warehouses and elastic scaling
  • Streaming data ingestion and near real-time analytics
  • Cost management and performance monitoring

Capstone Project: From Source to Star Schema

  • Translating business processes into factual and dimensional models
  • Constructing a complete end-to-end ETL or ELT workflow
  • Deploying dashboards and validating key metrics

Recap and Future Directions

Requirements

  • Solid understanding of relational databases and SQL
  • Practical experience in data analysis or reporting
  • Fundamental knowledge of cloud or on-premises data platforms

Target Audience

  • Data analysts moving into data warehousing roles
  • BI developers and ETL engineers
  • Data architects and technical team leads

Number of participants


Price per participant (excl. VAT)

Testimonials (3)

Upcoming Courses

Related Categories