Concepts, Design and Modelling for Extended Data Warehousing


Duration: 4 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,500

(Ex VAT)
Group Discounts Available

Topics:


  • 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
  • Data Warehouse Construction
  • High level introduction to Back-end and Front-end processes
  • – ETL Overview
  • – Deployment Overview

Course Dates:


Johannesburg 2018 – 2019

29,30,31 May
17,18,19,20 September
11,12,13,14 February 2019

Cape Town 2018

23,24,25 May
11,12,13,14 September
19,20,21,22 November

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

Data Warehouse Course Enquiry Form:


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


Start the Conversation!