Concepts, Design and Modelling for Extended Data Warehousing In Class Training Course May CPT 2021

Duration: 4 Days | Time: 8:30 – 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:
R12,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

Tel: +27 (0) 11 513 4083
Fax: +27 (0) 86 558 4348