Data Warehouse and Reporting Architecture
Reporting becomes unreliable when every team builds its own version of the numbers. This course covers how data is modelled, loaded and served so that reporting is consistent, fast and traceable back to source.
Course outline
What this programme covers, module by module.
- 01Why reporting fragments and numbers stop agreeing
- 02Transactional versus analytical data models
- 03Dimensional modelling: facts, dimensions and grain
- 04Extract, transform and load processes and their control
- 05Agreeing definitions for key measures once
- 06Performance, aggregation and query design
- 07Lineage, traceability and auditing a number
What you will gain
- Explain the components of a reporting architecture
- Model data for analysis rather than transactions
- Design load processes that are repeatable and auditable
- Establish a single agreed definition for key measures
- Balance performance against flexibility
- Trace a reported number back to its source
Who should attend
- Data engineers and analysts
- Business intelligence developers
- IT staff supporting reporting
- Information managers
Upcoming sessions
| Date | City | Duration | Fees | Book |
|---|---|---|---|---|
| 9 to 13 Nov 2026 | Johannesburg | 5 Days | R18,000 | |
| 23 to 27 Nov 2026 | London | 5 Days | US$1,800 | |
| 7 to 11 Dec 2026 | Dubai | 5 Days | US$1,800 | |
| 11 to 15 Jan 2027 | Pretoria | 5 Days | R18,000 | |
| 15 to 19 Feb 2027 | Durban | 5 Days | R18,000 | |
| 26 to 30 Apr 2027 | Cape Town | 5 Days | R18,000 | |
| 21 to 25 Jun 2027 | Johannesburg | 5 Days | R18,000 |
Fees are per delegate and exclude VAT. Public intakes are confirmed once minimum numbers are met. We also deliver this course on your own schedule, in-house or live online.
Enquire about this course
Register your team or ask for a tailored in-house quote. We reply within one working day.
WhatsApp usCourse brochure (PDF)- Fees from
- R18,000 per delegate
- Duration
- 5 Days
- Field
- Data & Analytics
- Formats
- In-house, public, online
More in Data & Analytics
Data Analysis and Visualisation with Excel
Excel remains the most widely used analysis tool in business, and few use it to its full potential. This course takes participants beyond basic formulas into structured analysis, PivotTables, and clear charts that reveal what the numbers mean.
Power BI for Business Intelligence and Reporting
Power BI turns scattered data into interactive reports that decision-makers can explore for themselves. This course guides participants from connecting data sources through building models to publishing dashboards that stay current.
Introduction to Data Analytics for Decision Making
This course demystifies data analytics for professionals who need to use data but are not specialists. Participants learn how to ask the right questions, interpret results, and use evidence to support better decisions.