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