analysis · GPT-4o · free
Design a Looker Explore and a Look for [BUSINESS QUESTION] that scales beyond one analyst's brain. Business question: [SPECIFIC] Underlying tables: [LIST + GRAIN] Downstream users: [WHO WILL SLICE THIS] Deliver a LookML shaped design doc: View files needed (dimensions, measures — name each with type + sql) Explore joins, join types, and PK/FK integrity notes Symmetric aggregates or fanout risks Named filter templates for the common cuts The 3 base Looks non analysts should be able to open and answer their own follow up Access controls (row level or attribute based) if PII is in play Cost / performance concerns and the aggregate table I should pre compute Optimize for other analysts hating me less.
#looker #lookml #dashboard