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:

R14,000

(Ex VAT)
Group Discounts Available

Topics:


  • 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

13, 14, 15 March

Cape Town 2018

07, 08, 09 March

  • +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!