Choosing the Right Data Model for Analytics

For organisations that are already more mature – especially those using dbt or a well-defined warehouse, Paul Houghton explores how you can evolve toward a Medallion architecture, with raw, processed, and presentation layers. Yet, he still recommends delivering a flattened, user-friendly “gold” layer for business users, because simplicity trumps purity when it comes to adoption.