Modern data warehousing and business intelligence

In this 1-day ABIS training, the concepts specific to 'Data Warehouses' (DW) are thoroughly explained. Typical architectures and implementation forms are discussed. Interactive, live classroom training session, aimed at anyone who wants to know more about DWs; first step for anyone who will begin working technically with DWs! Specific (technical) prior knowledge is not required.

This ABIS course aims to provide a conceptual view of the concept of data warehouse that is general, but also complete. All characteristics and possibilities of data warehousing are discussed: definitions and architectures, myths and reality, key concepts, implementation and exploitation strategies, alternatives - and their advantages and disadvantages. The concepts specific to Extraction, Transformation, and Load of data from (Operational Data) Sources are also examined. Frequently used DW modelling techniques are discussed.

Finally, we will consider how the data available in such an environment can be effectively unlocked - for reporting purposes and for analysis purposes (business intelligence and more).

After completing this training, the participant will have:

• a clear insight into the origins of DWs;
• an overview of alternative DW implementation strategies: traditional DWs, Data Lakes, Data Vaults,...
• an insight into the importance - and the benefits of using - alternative Extraction, Transformation and Load methodologies and methods;
• an overview of alternative DW usage scenarios - simple reporting and/or analysis - and ultimately business intelligence.