Concepts, Design and Modelling for Extended Data Warehousing

After completing this comprehensive four-day course you will be armed with sufficient knowledge to guide the process of designing business intelligence/data warehousing/analytical solutions. Concepts such as traditionally structured data warehouse, unstructured data, data lakes, big data and cloud computing will be clarified to enable you to talk the talk and walk the walk.

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

Contact: Training
Telephone number: +27824524055
Email address