Depth 20.2.1 · Data platform · Level 4
Warehouse and modelling layer
A warehouse and modelling layer is the place where data from your operational systems lands, is cleaned and is shaped into tables your reports and models read, with each table defined once, tested and documented.
Specification
- Input
- The source systems, the reports people rely on today, and the definitions your teams argue about.
- Method
- We load each source on a schedule, write the cleaning and joining steps as versioned code, test the rules each table must meet, and document what every column means.
- Deliverable
- The warehouse, the modelling code with tests, and a data dictionary, in your accounts.
- Measured by
- Tables with passing tests and a documented owner, and reports reading from modelled tables rather than raw sources.
What the file contains
- Scheduled loads per source
- Modelling code with tests
- Data dictionary
- Report migration list
Part of Data platform.
Ask about the warehouse and modelling layer
Tell us which systems it should cover. We reply with the access we would need and what the first version would contain.
Ask about this deliverable
A written reply, no call needed.