Get in Touch
 Duration 35 hours

Course Outline

Fundamentals of Data Warehousing

  • The role, key components, and architecture of a data warehouse.
  • Data marts, enterprise warehouses, and the lakehouse pattern.
  • Core principles of OLTP versus OLAP and the separation of workloads.

Dimensional Modelling

  • Facts, dimensions, and defining grain.
  • Comparing star schemas against snowflake schemas.
  • Handling Slowly Changing Dimensions (SCD) and their various types.

ETL and ELT Workflows

  • Extraction strategies from OLTP systems and APIs.
  • Transformations, data cleansing, and conformance.
  • Load patterns, orchestration, and managing dependencies.

Data Quality and Metadata Management

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

Analytics and Performance Optimisation

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

Security and Governance

  • Access control, role-based permissions, and row-level security.
  • Compliance considerations and auditing practices.
  • Backup, recovery, and reliability protocols.

Modern Architectures

  • Cloud data warehouses and the benefits of elasticity.
  • Streaming ingestion for near real-time analytics.
  • Cost optimisation and performance monitoring.

Capstone Project: From Source to Star Schema

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

Summary and Recommended Next Steps

Requirements

  • A solid understanding of relational databases and SQL.
  • Practical experience in data analysis or reporting.
  • Familiarity with either 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.

  • Customised 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 £8000 + VAT*

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

Testimonials (3)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories