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
Is it for me?
anybody interested in gaining a better understanding of how to deliver data and analytics;
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;
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.
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
Recomended Data archtecture
Module 1 - Vision, Scope and Requirements
Module 2 - Understanding your data
Data profiling using pandas 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
Post it note UI
Module 4 - Changing data using business rules
Natural language rule script
GUI to create mapping or rule in Agiledata.io wizard
Slack integraton to show output of logs
Module 5 - Making data fit for consumption
Consume layer – Agiledata.io 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.