How to build a modern agile data warehouse

A one day hands on course where you get to build a modern data warehouse from beginning to end

[teaser text].


Is it for me?


anybody interested in gaining a better understanding of how to deliver data and analytics;

Who needs

to understand how to design, build and deploy a modern agile data warehouse;


“How to build a modern agile data warehouse” is a 1 day hands on course;


provides you with the concepts, patterns, processes and templates to build a modern agile data warehouse;


the current plethora of confusing technical concepts and techniques;

The "1 day Modern agile data warehouse course" will:
  • Introduce you to all the concepts, patterns and processes you need to build a modern agile data warehouse;

  • Provide you with hands on excercises to actually build a working solution during the course;

  • Be tailored to any level of techncial experience;

Key Outcomes

Everything you need to learn, nothing you don’t

Modern agile data warehouse

Learn what a modern agile data warehouse is.

Gathering vision, scope and requirements

Understand how to gather the vision, scope and requirements from business stakeholders.

Gather data requirements

Learn how to gather data requirements using business language.

Model core business processes

Learn how to model data using core business processes.

Transform data using business rules

Learn how to define business rules to change the data structures and context.

Develop interactive content

Learn how to create interactive content and visualisations.

Course Content

The training is interactive and includes both exploring concepts and the hands on creation of a agile data warehouse.

Module 0 - Why we need a modern agile data warehouse

Problem statement
The why
Current options
Recomended Data archtecture

Module 1 - Vision, Scope and Requirements

IP Canvas
Vision statement

Module 2 - Understanding your data

Data requirements


Data profiling using pandas profiling

DLP profiling

History versus current – load a second version of the customer and order data.  Show diff between end dates on customer detail and new orders/dates on the order table, to explain the two versions of history.

Module 3 - Creating a business data model

Event modeling

Post it note UI

Module 4 - Changing data using business rules

Psuedo code

Natural language rule script

Mapping logic

Example code

GUI to create mapping or rule in wizard

Slack integraton to show output of logs


Module 5 - Making data fit for consumption

Consume layer – consume views

Multiple consumption types – Explain dimensional vs denormalised vs summary

Documentation – show static site CD/CI


Module 6 - Delivering value to the stakeholder

Create dashboard in Google Data Studio
Creating an Data service (API or csv extract)

Module 7 - Analytical modelling

Analytics maturoty, decriptive,, predicitive etc

WHat is machine learning

Build a forecast algorythim using BQML

Run a jupyter noteboook using python.