Concepts, Design and Modelling for Extended Data Warehousing

Purpose:

The complete life cycle 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.

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 modelling 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 modelling 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
• A high-level introduction to back-end and front-end processes
• ETL overview
• Deployment overview
• Data visualisation and presentation

Who should attend:

• Data warehouse administrators
• Project managers
• Database administrators
• Developers
• Analysts
• Data warehouse practitioners
• BI practitioners

Cape Town course: 09 April 2019 to 12 April 2019
Venue: Cape Town, Cape Town

Johannesburg course: 20 May 2019 to 23 May 2019
Time: 09:00 - 16:30
Venue: Sierra Square Hotel, Randburg

Johannesburg course: 15 July 2019 to 18 April 2019
Time: 09:00 - 16:30
Venue: Sierra Square Hotel, Randburg

Cape Town Course: 16 July 2019 to 19 July 2019
Time: 09:00 - 16:30
Venue: Cape Town, Cape Town