Design and configure Looker Studio dashboards with BigQuery data sources. Use when creating analytics dashboards, connecting BigQuery to visualization tools, or optimizing data pipeline performance. Handles BigQuery connections, custom SQL queries, scheduled queries, dashboard design, and performance optimization.
86
82%
Does it follow best practices?
Impact
90%
1.07xAverage score across 3 eval scenarios
Passed
No known issues
BigQuery query optimization for dashboards
Scheduled query SQL present
100%
100%
Pre-aggregation approach
100%
100%
Partition key filtering in scheduled query
25%
100%
No SELECT * in any SQL file
100%
100%
Dashboard query targets summary table
100%
100%
Partition key filtering in dashboard query
100%
100%
Avoids live query explanation
100%
100%
Scheduled query cost benefit
100%
100%
Partition filtering explanation
100%
100%
Output files complete
100%
100%
Dashboard layout and design specification
F-pattern layout present
100%
100%
Header with filters at top
100%
100%
KPI tile count
100%
100%
Date range filter included
100%
100%
Filter count within limit
100%
100%
Chart ordering sequence
100%
100%
Single-page chart count limit
100%
100%
Color palette size
0%
0%
Trend chart included
100%
100%
Detail table included
100%
100%
BigQuery security and access control
BigQuery Data Viewer role granted
100%
100%
BigQuery User role granted
0%
0%
BigQuery Job User role granted
0%
0%
Row Access Policy SQL present
100%
100%
Per-country RLS filtering
100%
100%
All three regions covered
100%
100%
Viewer/Editor sharing levels
100%
100%
Per-data-source permissions
41%
100%
Specific user/group sharing
100%
100%
All output files present
100%
100%
c033769
Table of Contents
If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.