Building BI Dashboards and LookML Models on GCP
Reduced report preparation time by 80% through Looker and SQL automation.
Context
Business teams across Soulriza, AI Avatar, and Twomi needed faster, more reliable reporting on marketing, revenue, and product performance. Reporting was slow, manual, and inconsistent, making it hard for stakeholders to trust the data or act quickly.
My Role
I led the development of 15+ Looker dashboards and LookML models on GCP, designed the semantic data model, wrote complex SQL queries, and built Python scripts to automate core BI workflows across all three products.
Approach
I audited existing reporting workflows to find the biggest time sinks, then modeled data in LookML to create a reusable, consistent semantic layer. Python automation handled repetitive data transformation and delivery tasks.
Impact
Report preparation time dropped by 80%. Business and product teams now access self-serve dashboards instead of waiting for manual reports. The LookML semantic layer ensures consistent metric definitions across all dashboards.
Key Metrics
- 15+ dashboards
- 80% time reduction
- Self-serve reporting










