Modern data warehousing and BI (EN/NL/FR)

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.

Intended for

Anyone with ties to DWs - all interested parties, data analysts, data managers, future administrators and developers.

Backgroud

No specific background is required, but some basic knowledge of relational databases can be useful (see course SQL and relational databases fundamentals).

Main topics

• Historical background - context: Why the importance?
  CIF (Corporate Information Factory) and BUS (DataWarehouse Bus)
• Definitions:
  Explanation of the key concepts against the background of the above context - Data Warehouse (Data Mart, ODS, ...) - Data Lake - Data Vault - Enterprise Data Architecture
  Big Data
• Data warehouse 'infrastructure':
  The Data source, Back end (ETT/ETL) processes, the Data store, the Front-end tools
  The importance of Meta Data
• Front-end tooling: Query & Reporting, OLAP, Data Mining, Data Science, Machine Learning
• Logical implementation:
  Data profiling
  The complete strategy: source data • transformation • loading • extraction • cleaning • metadata maintenance • ...
• Designing a data warehouse:
  No data warehouse without a well-thought-out data model: ER, Multi Dimensional Modelling, Snowflakes & Stars, Data vault modelling

Training method

Live instructor-led training, with plenty of opportunities for discussion

Delivered as a live, interactive training: available in-person or online, or in a hybrid format. 
Training can be implemented in English, Dutch, or French.
If interested in organising this training internally, get in touch with us; we can even customise it to meet your specific needs.

Certificate

At the end of the course session, the participant receives a 'Certificate of Completion'.

Duration
1 day.