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 2017

15, 16, 17 February
3,4,5 May
22, 23, 24 August
25, 26, 27 October
15, 16,17 November

Cape Town 2017

22, 23, 24 February
26, 27, 28 July
22, 23, 24 November

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