Concepts, Design and Modelling for Extended Data Warehousing
The complete lifecycle of a data warehouse project is covered and after completing this comprehensive 4 day course data warehouse practitioners will be armed with sufficient knowledge to guide them through the process of designing business intelligence/data warehousing solutions. Concepts such as data lakes, big data and cloud computing will also be discussed.
Topics covered:
• 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 modelling 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
Date: 29 July 2018 to 31 July 2018
Venue: Sierra Square Hotel, Randburg
Date: 11 September 2018 to 14 September 2018
Time: 08:30 - 16:30
Venue: Cape Town, Cape Town
Date: 17 September 2018 to 20 September 2018
Time: 08:30 - 16:30
Venue: Sierra Square Hotel, Randburg
Date: 19 November 2018 to 22 November 2018
Time: 08:30 - 16:30
Venue: Cape Town, Cape Town
Date: 26 November 2018 to 29 November 2018
Time: 08:30 - 16:30
Venue: Sierra Square Hotel, Randburg