London Leadership Management Innovation llmi.uk
info@llmi.uk
Data Management and Business Intelligence · DMBI-025

Data Warehouse Design and Dimensional Modelling

5 daysClassroom
12Upcoming dates
5Cities
£2,250Fees from

Course overview

Why Attend

Data warehouses integrate data from many systems to support reporting and analytics. Good dimensional design makes data easy to understand, query and trust.

This LLMI course covers data warehouse concepts and architectures, dimensional modelling, facts and dimensions, slowly changing dimensions, ETL and ELT design, data quality, modern cloud warehouses and performance. Participants design a dimensional model for a business process.

Course Objectives

Explain data warehouse architectures

Apply dimensional modelling techniques

Design fact and dimension tables

Handle slowly changing dimensions

Design ETL and ELT processes

Optimise and govern warehouses

Target Audience

BI developers

Data engineers

Data architects

Database administrators

Business analysts

IT managers

Course Methodology

Design workshops

Modelling exercises

Case studies

Demonstrations

Group reviews

Course outline

Day 1: Data Warehouse Concepts
  • Purpose of warehouses
  • Architectures
  • Data marts
  • Cloud warehouses
  • Requirements
  • Exercise: Requirements analysis
Day 2: Dimensional Modelling
  • Business process modelling
  • Grain
  • Facts
  • Dimensions
  • Star and snowflake
  • Workshop: Dimensional model
Day 3: Advanced Dimensions
  • Slowly changing dimensions
  • Conformed dimensions
  • Hierarchies
  • Bridge tables
  • Exercise: SCD design
Day 4: Data Integration
  • ETL and ELT
  • Staging
  • Data quality
  • Orchestration
  • Lab: Integration design
Day 5: Performance and Governance
  • Indexing and partitioning
  • Aggregations
  • Metadata
  • Governance
  • Capstone: Warehouse design

Dates and fees

DatesCityFee
18 - 22 Jan 2027Paris, France£4,500
15 - 19 Feb 2027Frankfurt, Germany£3,250
15 - 19 Mar 2027Barcelona, Spain£3,850
19 - 23 Apr 2027Frankfurt, Germany£3,250
17 - 21 May 2027Rome, Italy£4,250
21 - 25 Jun 2027Kuala Lumpur, Malaysia£2,250
19 - 23 Jul 2027Barcelona, Spain£3,850
16 - 20 Aug 2027Paris, France£4,500
20 - 24 Sep 2027Frankfurt, Germany£3,250
18 - 22 Oct 2027Barcelona, Spain£3,850
15 - 19 Nov 2027Frankfurt, Germany£3,250
20 - 24 Dec 2027Rome, Italy£4,250
London Leadership Management InnovationRegister at llmi.uk/course/data-warehouse-design-and-dimensional-modelling