Concepts, Design and Modelling for Extended Data Warehousing

After completing this comprehensive 4 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.

•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
•Significance of Meta Data
•Data Warehouse Construction
•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
•Data Warehouse Practitioners
•BI Practitioners

Cape Town Course: 09 April 2019 to 12 April 2019
Venue: Tyger Valley, Cape Town

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

Johannesburg Course: 15 July 2019 to 18 July 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
Company name: Alicornio Africa
Telephone number: +27824524055
Email address