looker-expert

Create LookML views, explores, dimensions, measures, and dashboards.

41|9|Updated Jan 13, 2026
One-click install
npx skills add https://github.com/personamanagmentlayer/pcl --skill looker-expert
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: looker-expert
Source: https://github.com/personamanagmentlayer/pcl/tree/main/stdlib/data/looker-expert
Command: npx skills add https://github.com/personamanagmentlayer/pcl --skill looker-expert

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill empowers users to efficiently design, build, and optimize Looker BI dashboards and LookML models, transforming raw data into actionable business insights.

Core Features & Use Cases

  • LookML Development: Create robust and maintainable LookML views, explores, and models.
  • Data Modeling: Design semantic layers with dimensions, measures, and derived tables.
  • Dashboard Creation: Build interactive and insightful dashboards for business users.
  • Use Case: A data analyst needs to create a new sales performance dashboard. They can use this Skill to generate the necessary LookML for sales data, define key metrics like total revenue and customer count, and build an explore that joins sales and customer information, finally creating a dashboard to visualize trends.

Quick Start

Use the looker-expert skill to generate a LookML view for a 'products' table with dimensions for 'product_name', 'category', and 'price'.

Frequently Asked Questions about looker-expert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a LookML view for my database tables?

To create a LookML view, define dimensions and measures that map to your database columns. This structures raw data into queryable fields, enabling business users to generate insights without writing SQL.

How does a persistent derived table (PDT) work in Looker?

A persistent derived table (PDT) works by caching the results of an SQL query in your database. PDTs optimize dashboard performance by materializing complex transformations, reducing the need to recompute heavy queries on the fly during data exploration.

What is the best way to model an explore joining multiple views in LookML?

Modeling an explore joining multiple views requires defining relationships in your LookML model file. You establish joins between views using primary and foreign keys, enabling users to combine fields across different data tables within a single Looker query.

Can I use Looker to build interactive BI dashboards for business users?

Yes, you can use Looker to build interactive BI dashboards. You configure dashboard elements visualizing measures and dimensions defined in LookML, transforming modeled data into actionable business insights through charts and filters.

Why are my LookML dimensions not showing up in the Looker explore?

LookML dimensions may not show up in the explore if they contain syntax errors or are not properly referenced in the model file. Validating your LookML project ensures fields are correctly defined and exposed for querying.