Get in Touch

Course Outline

Foundations of Data Warehousing

  • The purpose, components, and architecture of warehouses.
  • Data marts, enterprise warehouses, and lakehouse patterns.
  • Fundamental differences between OLTP and OLAP, and workload separation.

Dimensional Modelling

  • Facts, dimensions, and defining grain.
  • Comparing star schema versus snowflake schema approaches.
  • Managing Slowly Changing Dimensions (SCD) types and handling.

ETL and ELT Processes

  • Strategies for extracting data from OLTP systems and APIs.
  • Transformation techniques, data cleansing, and conformance.
  • Loading patterns, orchestration, and managing dependencies.

Data Quality and Metadata Management

  • Data profiling and establishing validation rules.
  • Aligning master and reference data.
  • Lineage tracking, data catalogues, and documentation.

Analytics and Performance

  • Concepts of cubing, aggregates, and materialised views.
  • Partitioning, clustering, and indexing strategies for analytics.
  • Workload management, caching mechanisms, and query tuning.

Security and Governance

  • Access control, role definition, and row-level security.
  • Compliance requirements and auditing practices.
  • Backup, recovery, and reliability protocols.

Modern Architectures

  • Cloud data warehouses and elastic scaling.
  • Streaming ingestion and near real-time analytics capabilities.
  • Cost optimisation strategies and monitoring.

Capstone: From Source to Star Schema

  • Modelling a business process into facts and dimensions.
  • Constructing an end-to-end ETL or ELT workflow.
  • Publishing dashboards and validating key metrics.

Summary and Next Steps

Requirements

  • A working understanding of relational databases and SQL.
  • Practical experience in data analysis or reporting.
  • Foundational knowledge of cloud-based or on-premises data platforms.

Intended Audience

  • Data analysts looking to transition into data warehousing.
  • BI developers and ETL engineers.
  • Data architects and team leads.
 35 Hours

Number of participants


Price per participant

Testimonials (2)

Provisional Upcoming Courses (Require 5+ participants)

Related Categories