Building a Metrics Layer for Self-Service Analytics

<p>Every growing company hits the same wall: Looker says one revenue number, Tableau says another, and finance's spreadsheet says a third — and nobody can explain why. This project follows Alderwood Outfitters through building a metrics layer: a single, version-controlled source of truth for what "revenue" or "active customer" actually means, defined once as code and shared across every BI tool, notebook, and dashboard in the company. You'll write real semantic model and metrics YAML, see the SQL it compiles to, wire up multiple BI tools against it, and learn how to evolve metric definitions over time without breaking historical reports.</p>

Tools: dbt Semantic Layer, MetricFlow, YAML, SQL, Looker, Tableau