Tableau to Looker Modernization

Challenge

The existing reporting architecture needed a more scalable, governed analytics approach. As reporting demand grew, workbook-centric delivery made it harder to keep KPIs consistent, documented, and reusable.

Approach

I helped migrate business reporting toward a layered analytics platform: BigQuery for warehousing, dbt for transformation and testing, LookML for semantic modeling, and Looker for governed delivery.

Architecture

• Sources land in BigQuery
• dbt staging models clean and standardize raw data
• Intermediate models apply business logic
• Marts expose analytics-ready tables
• LookML defines the semantic layer and KPI governance
• Looker delivers consistent reporting to the business

Implementation

• Designed layered dbt models with staging, intermediate, and marts
• Added testing, documentation, and lineage so models could be trusted and explained
• Used semantic modeling to keep KPI definitions consistent
• Migrated reporting to Looker with shared LookML definitions instead of one-off workbooks

Result

• Reusable data models for business reporting
• Clearer KPI governance across teams
• Documented, tested models from the warehouse into Looker
• A foundation for replacing fragmented Tableau delivery