Data Warehouse Concepts and Dimensional Modelling Techniques

Duration: 3 Days  |  Time: 9:00 – 16:30  |  Prerequisites: None


Who should attend:

  • Data Warehouse Administrators
  • Project Managers
  • Database Administrators
  • Developers
  • Analysts
  • Data Warehouse Practitioners

Purpose:  The complete lifecycle of a Data Warehouse project is covered and after completing this comprehensive course Data Warehouse Practitioners will be armed with sufficient knowledge to guide them through the process of designing Business Intelligence / Data Warehousing solutions.

Price Per Delegate:


(Ex VAT)
Group Discounts Available


  • The Data Warehouse and Dimensional Modeling in Perspective
  • Evolution, terminology, value and definition of the DW
  • DW Project Planning and Management
  • Impact of a Data Warehouse Strategy on Business
  • Reasons for, components and deliverables of an Architectural Approach
  • Business Requirements Definition
  • How to Implement a Data Warehouse
  • Business and Technical Architecture
  • Dimensional Modeling and Design Techniques: Basics and Expanded (including exercises and workshops)
  • Implementation Considerations
  • Data Warehouse Construction
  • High level introduction to Back-end and Front-end processes
  • ETL Overview
  • Deployment Overview

Course Dates:

Johannesburg 2018

29,30,31 May
28,29,30 August
23,24,25 October

Cape Town 2018

23,24,25 May
22,23,24 August
17,18,19 October

  • +27 (0) 11 513 4083
  • +27 (0) 86 558 4348

“By stretching information integration boundaries, together we can help you take your business to a level that goes beyond the imagination.”

Start the Conversation!