Question

A retail company has multiple teams that each build their own spreadsheets and reports, resulting in conflicting numbers for key metrics like 'monthly active customers.' Leadership wants a solution that defines business metrics once and reuses those definitions consistently across all reports and dashboards, so every team sees the same trusted figures. Which Google Cloud capability best addresses this need?

Accepted Answer

Use Looker's semantic modeling layer (LookML) to centrally define metrics as a single source of truth reused across dashboards

Answer

Give each team its own BigQuery dataset so they can run independent queries

Answer

Export data to Cloud Storage so teams can download it into their own spreadsheets

Answer

Enable BigQuery Data Transfer Service to schedule automatic data loads