Advanced Data Analysis Techniques
Next: 21 - 25 Dec 2026 · Barcelona
Barcelona, Amsterdam, London +2 more
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
- 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
-
1Day 1: Data Warehouse Concepts
- Purpose of warehouses
- Architectures
- Data marts
- Cloud warehouses
- Requirements
- Exercise: Requirements analysis
-
2Day 2: Dimensional Modelling
- Business process modelling
- Grain
- Facts
- Dimensions
- Star and snowflake
- Workshop: Dimensional model
-
3Day 3: Advanced Dimensions
- Slowly changing dimensions
- Conformed dimensions
- Hierarchies
- Bridge tables
- Exercise: SCD design
-
4Day 4: Data Integration
- ETL and ELT
- Staging
- Data quality
- Orchestration
- Lab: Integration design
-
5Day 5: Performance and Governance
- Indexing and partitioning
- Aggregations
- Metadata
- Governance
- Capstone: Warehouse design
Dates and fees
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.
How much does the course cost?
Fees start from £2,250 + VAT 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
Advanced Power BI: DAX and Data Modelling
Next: 16 - 20 Nov 2026 · Vienna
Vienna, Barcelona, Rome +4 more
ArcGIS Pro: Essential Workflows
Next: 16 - 20 Nov 2026 · Barcelona
Barcelona, Dubai, Cape Town +11 more