Get in Touch
 Duration 35 hours

Course Outline

Data Warehousing Fundamentals

  • Purpose, key components, and architectural overview of warehouses
  • Data marts, enterprise warehouses, and lakehouse methodologies
  • Core differences between OLTP and OLAP, and separating workloads

Dimensional Modeling

  • Understanding facts, dimensions, and grain
  • Comparison of star schema versus snowflake schema
  • Managing various types of Slowly Changing Dimensions

ETL and ELT Workflows

  • Strategies for extracting data from OLTP systems and APIs
  • Data transformation, cleansing, and conformance
  • Loading patterns, orchestration, and handling dependencies

Data Quality and Metadata Governance

  • Data profiling techniques and validation rules
  • Aligning master and reference data
  • Tracking lineage, maintaining catalogs, and documentation

Analytics and Performance Optimisation

  • Concepts of cubing, aggregation, and materialized views
  • Using partitioning, clustering, and indexing for analytical gains
  • Workload management, caching strategies, and query tuning

Security and Governance

  • Implementing access control, roles, and row-level security
  • Addressing compliance needs and auditing processes
  • Practices for backup, recovery, and system reliability

Modern Architectures

  • Cloud-based data warehouses and their elastic capabilities
  • Streaming ingestion for near real-time analytics
  • Cost optimisation strategies and continuous monitoring

Capstone Project: From Source to Star Schema

  • Modeling a business process into facts and dimensions
  • Creating an end-to-end ETL or ELT workflow
  • Deploying dashboards and validating key metrics

Summary and Path Forward

Requirements

  • Solid grasp of relational databases and SQL
  • Prior experience in data analysis or reporting
  • Basic knowledge of cloud-based or on-premises data platforms

Target Audience

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

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 7250 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (3)

Upcoming Courses

Related Categories