LAYER 5 · DESIGN · STAGE 5
Data modelling for FDEs
Quick answer
Shaping tables and entities so the data answers real questions. A good model makes every later report, retrieval job and eval simpler.
Practise it
- 1. Model a CRM export as a star schema
- 2. Choose keys and handle history
- 3. Document the model for the client's analysts
Where it sits
Stage 5 of the roadmap: Customer discovery. You can turn a vague brief into scope, a design and a plan a client signs.
Field problems
Map a client's CRM fields to a warehouse schema [ EASY ]Portfolio projects
Weekly KPI report from a messy databaseA gap skill for: full stack developers, field engineers