Andrew Foad – Hook: A Fresh Take on Data Warehousing

In this episode of Insane Data, host Giuliano Giannetti sits down with Andrew Foote – data modeler, consultant, and creator of the Hook methodology.

Frustrated by the shortcomings of Data Vault in real-world projects, Andrew developed Hook as a simpler, more flexible way to build and maintain data warehouses. Instead of piling on complexity, Hook focuses on formalizing business keys (hooks) and keeping ingestion and modeling separate – a lightweight approach that can extend the shelf life of a warehouse.

Andrew explains how Hook works using a classic e-commerce example, how it compares to Data Vault and dimensional modeling, and why “less modeling is often the best modeling.” We also touch on his consulting experiences, his upcoming book, and how Hook could combine with Francesco Puppini’s Unified Star Schema.

If you’ve ever struggled with brittle data models, endless rules, or projects collapsing after a few years, this conversation offers a fresh perspective – and maybe a way forward.