About the service
I build a managed semantic layer in Looker that turns your data warehouse into a single source of trusted business metrics. Instead of each team writing their own SQL and getting three different revenue numbers, I describe the data once in LookML: clean views, thoughtful explores, and reusable metrics that everyone consults the same way. Key metrics — MRR, churn, gross margin, active users — get a single definition that lives in version-controlled code. The number on the exec dashboard means exactly the same thing as the same number in an analyst's independent report.
My work covers the full delivery, not just a set of tiles. I design the LookML model layer with derived tables, persistent aggregates for speed, and symmetric aggregates that preserve sum correctness across joins. I tune explores to how your analysts actually think, then build dashboards and Looks on top with clear filters, drill paths, and alerts. I carefully set up access controls: model sets, permission sets, and row-level access so finance, sales, and customers each see only what they're supposed to. Where you need analytics inside your product, I implement embedded Looker with signed SSO and tenant-level filtering.
You get a maintained repository, documented metrics, and a team that trusts the dashboards. I work through your Git process with dev and prod separation, LookML change review, and validation before publishing. A typical project includes metric audit and data modeling, a set of managed dashboards, and knowledge transfer so your people confidently evolve the system further.
— LookML models: views, explores, and reusable metrics
— Persistent derived tables and aggregate awareness for speed
— Managed dashboards, Looks, alerts, and scheduled sends
— Permission sets, model sets, and row-level access
— Embedded analytics with signed SSO and multi-tenant filtering
My work covers the full delivery, not just a set of tiles. I design the LookML model layer with derived tables, persistent aggregates for speed, and symmetric aggregates that preserve sum correctness across joins. I tune explores to how your analysts actually think, then build dashboards and Looks on top with clear filters, drill paths, and alerts. I carefully set up access controls: model sets, permission sets, and row-level access so finance, sales, and customers each see only what they're supposed to. Where you need analytics inside your product, I implement embedded Looker with signed SSO and tenant-level filtering.
You get a maintained repository, documented metrics, and a team that trusts the dashboards. I work through your Git process with dev and prod separation, LookML change review, and validation before publishing. A typical project includes metric audit and data modeling, a set of managed dashboards, and knowledge transfer so your people confidently evolve the system further.
— LookML models: views, explores, and reusable metrics
— Persistent derived tables and aggregate awareness for speed
— Managed dashboards, Looks, alerts, and scheduled sends
— Permission sets, model sets, and row-level access
— Embedded analytics with signed SSO and multi-tenant filtering
