Professional training in London and 13 international cities info@llmi.uk +443300011190
Enquire

Professional training course · DMBI-025

Data Warehouse Design and Dimensional Modelling

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…

  • 5 daysClassroom or online
  • 12Upcoming dates
  • 5Cities
  • £2,250Fees from
View dates & register Get quotation Download PDF
Data Warehouse Design and Dimensional Modelling
Next classroom session Paris 18 - 22 Jan 2027 · £3,250 Also available Frankfurt 15 - 19 Feb 2027 · £3,250

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

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

Schedule

Dates and fees

12 upcoming dates in 5 cities. Fees are per delegate; bring colleagues and every seat is discounted. Every date can also be joined live online for £1,280.

All dates as PDF
January 2027
18JAN 18 - 22 Jan 2027Mon to Fri · 5 daysNext session
France flag ParisFrance · Classroom
£3,250per delegate2+ people: £2,600 each
Register
February 2027
15FEB 15 - 19 Feb 2027Mon to Fri · 5 days
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register
March 2027
15MAR 15 - 19 Mar 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
April 2027
19APR 19 - 23 Apr 2027Mon to Fri · 5 days
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register
May 2027
17MAY 17 - 21 May 2027Mon to Fri · 5 days
Italy flag RomeItaly · Classroom
£4,250per delegate2+ people: £3,400 each
Register
June 2027
21JUN 21 - 25 Jun 2027Mon to Fri · 5 days
Malaysia flag Kuala LumpurMalaysia · Classroom
£2,250per delegate2+ people: £1,800 each
Register
July 2027
19JUL 19 - 23 Jul 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
August 2027
16AUG 16 - 20 Aug 2027Mon to Fri · 5 days
France flag ParisFrance · Classroom
£3,250per delegate2+ people: £2,600 each
Register
September 2027
20SEP 20 - 24 Sep 2027Mon to Fri · 5 days
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register
October 2027
18OCT 18 - 22 Oct 2027Mon to Fri · 5 days
Spain flag BarcelonaSpain · Classroom
£3,850per delegate2+ people: £3,080 each
Register
November 2027
15NOV 15 - 19 Nov 2027Mon to Fri · 5 days
Germany flag FrankfurtGermany · Classroom
£3,250per delegate2+ people: £2,600 each
Register
December 2027
20DEC 20 - 24 Dec 2027Mon to Fri · 5 days
Italy flag RomeItaly · Classroom
£4,250per delegate2+ people: £3,400 each
Register

Questions

Frequently asked questions

How long is the Data Warehouse Design and Dimensional Modelling course?

The course runs over 5 days of classroom training, usually Monday to Friday.

When is the next Data Warehouse Design and Dimensional Modelling course?

The next public date is 18 - 22 Jan 2027 in Paris. There are 12 upcoming dates in total.

Where is this course held?

Upcoming sessions run in Paris, Frankfurt, Barcelona, Rome, Kuala Lumpur.

Can I take Data Warehouse Design and Dimensional Modelling online?

Yes. Every date can also be joined live online in a virtual classroom with the trainer, for £1,280 per participant. Choose "Live online" in the dates table when you register.

How much does the course cost?

Fees start from £2,250 per delegate, depending on the city. Fees include tuition and course materials.

Do participants receive a certificate?

Yes. Delegates who complete the course receive a London Leadership Management Innovation certificate of completion.

Can this course be delivered in-house for our team?

Yes. LLMI can tailor and deliver this course privately for your organisation at your premises or in one of our training cities.

Course information last updated 14 November 2026.

Related

More Data Management and Business Intelligence courses

View all

Training a team?

Any course in our catalogue can be delivered privately for your organisation, at your offices or in one of our cities, with content shaped around your goals.

Plan in-house training Speak to an advisor