The Study Guide That Covers What the Exam Actually Tests

Data Exploration (~25%)

• ✓Use offset() and pivot_index() to build period-over-period comparisons in table calculations
• ✓Add custom fields to an Explore without asking a LookML developer
• ✓Build a running total that resets per pivot column
• ✓Filter an Explore by a field not shown in the results

Data Analysis and Calculation (~25%)

• ✓Use date_diff and date_trunc correctly in table calculations vs. LookML dimensions
• ✓Calculate percent of total across rows and columns without double-counting pivots
• ✓Apply conditional logic (if, case) in table calculations and custom fields
• ✓Use string functions (concat, split, regexp_extract) on dimension values

Visualizations and Dashboards (~20%)

• ✓Choose the correct chart type for time-series, part-to-whole, and distribution data
• ✓Configure dashboard filters that apply to some tiles but not others
• ✓Set up cross-filtering between dashboard tiles and explain when it fails
• ✓Diagnose slow dashboard performance and identify which tiles are causing it

Sharing, Scheduling, and Governance (~15%)

• ✓Configure a scheduled delivery with conditional send (only send if rows returned)
• ✓Set up an alert on a Look and explain the difference between alert and schedule
• ✓Explain how access filters restrict data in an Explore without hiding the field
• ✓Describe Looker's cache model and when a query bypasses the cache

Navigation and Interface (~15%)

• ✓Explain the difference between a Look, a tile, and an Explore result
• ✓Describe the hierarchy of spaces/folders and how permissions propagate
• ✓Use the data dictionary to find which Explores contain a field
• ✓Merge results from two different Explores into a single table