Surfalytics
All pet projects
Data Engineering intermediate ⏱ 12–16 hours

End-to-End Analytics: dbt + Looker

Multi-week community project: build a full analytics stack with dbt transformations on Azure PostgreSQL and Looker dashboards on top.

dbtLookerAzurePostgreSQLAnalytics Engineering
View project on GitHub

What you’ll build

A full analytics solution built week by week with the Surfalytics community: raw data loaded into Azure PostgreSQL, transformed through dbt layers (staging → intermediate → marts), and visualized in Looker with LookML models and explores.

Skills you’ll practice

  • End-to-end analytics stack architecture
  • dbt + Looker integration: dbt models as Looker views
  • LookML: dimensions, measures, explores, dashboards
  • Collaborative development with shared GitHub repos

The full project guide is for members

Join Surfalytics to unlock every step of this project, all other projects, the full course, and the private community.

7-day free trial · Cancel any time