Looker LookML Analyst

Expert guidance for building and optimizing Looker LookML models, Explores, and dashboards. Covers semantic layer design, derived tables, performance optimization, and governance patterns for scalable self-serve analytics.

Gold

v1.0.00 activationsData & AnalyticsTechnologyintermediate

SupaScore

83.45

Research Quality (15%)

8.3

Prompt Engineering (25%)

8.5

Practical Utility (15%)

8.4

Completeness (10%)

8.3

User Satisfaction (20%)

8.2

Decision Usefulness (15%)

8.3

Best for

▸Building semantic layer views and explores for self-serve analytics teams
▸Optimizing LookML model performance with derived tables and PDT strategies
▸Implementing row-level security and governance patterns for enterprise Looker deployments
▸Migrating existing BI dashboards to Looker with proper dimensional modeling
▸Designing reusable metric definitions and drill paths for cross-functional teams

What you'll get

●Complete LookML view definition with properly typed dimensions, measures, drill fields, and SQL optimizations
●Explore configuration with appropriate joins, filters, and access controls for specific user groups
●PDT implementation with incremental refresh logic and datagroup triggers aligned to ETL schedules

Not designed for ↓

×Building the underlying data warehouse or ETL pipelines (that's dbt/Airflow territory)
×Creating custom visualizations beyond Looker's built-in chart types
×Direct SQL database administration or performance tuning at the warehouse level
×Setting up Looker infrastructure or managing user provisioning

Expects

Details about your data warehouse schema, business metrics requirements, user personas, and existing dbt models or raw tables to model against.

Returns

Complete LookML code with views, explores, derived tables, plus governance patterns, naming conventions, and performance optimization recommendations.

Evidence Policy

Enabled: this skill cites sources and distinguishes evidence from opinion.

lookerlookmlsemantic-layerexploresderived-tablesdata-modelingbi-analyticskimballdashboardsself-serve-analyticsdata-governancebigquery

Research Foundation: 7 sources (3 official docs, 1 books, 1 community practice, 1 web, 1 industry frameworks)

This skill was developed through independent research and synthesis. SupaSkills is not affiliated with or endorsed by any cited author or organisation.

Version History

v1.0.02/16/2026

Initial release

Prerequisites

Use these skills first for best results.

SQL Query OptimizerPlatinum

Works well with

BigQuery Analytics ExpertGold Dashboard Design StrategistGold Data Governance StrategistGold dbt Analytics EngineerGold SQL Query OptimizerPlatinum

Need more depth?

Specialist skills that go deeper in areas this skill touches.

Data Warehouse ArchitectGold BigQuery Optimization ExpertGold Tableau Analytics ExpertGold

Common Workflows

Modern Analytics Stack Setup

Transform raw data into governed, performant self-serve analytics: dbt for data modeling, LookML for semantic layer, dashboard design for end-user experience

dbt Analytics Engineer→looker-lookml-analyst→Dashboard Design Strategist

Activate this skill in Claude Code

Start Free to Activate This Skill