Concepts, Design and Modelling for the Extended Data Warehousing

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 4 day course Data Warehouse Practitioners will be armed with sufficient knowledge to guide them through the process of designing Business Intelligence / Data Warehousing solutions. Concepts such as data lakes, big data and cloud computing will also be discussed.

Price Per Delegate:


(Ex VAT)
Group Discounts Available


    • Evolution, value and definition of the DW
    • Historical perspective on Data Analytics
    • New Waves: Comparing and discussing the options
    • Brief overview of current concepts and technologies
    • The Data Warehouse and Dimensional Modeling in Perspective
    • 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
    • Architecture of Extended Data Warehouse
    • Design principles
    • Dimensional Modeling and Design Techniques: Basics and Expanded                            (including exercises and workshops)
    • Implementation Considerations
    • Effects of Cloud and Big Data
    • Significance of Meta Data 
    • Data Warehouse Construction
    • High level introduction to Back-end and Front-end processes
      • ETL Overview
      • Deployment Overview
      • Visualisation and Presentation
Contact Details
Course Details

Course Delivery Method: 

In Class In Class

Presented Presented Courses

In House In-House

On Demand On Demand

Course Duration: 

4 days


R14 500 Excluding VAT

Course fee Includes: 

Manual, Textbook , Workshops, Lunch and Refreshments