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.
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.
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
The complete life cycle of a data warehouse project is covered in this comprehensive course.