Looker Business Analyst study plan

Map the Looker object hierarchy (connection, project, model, Explore, view, field) and write a one-page diagram showing how a query travels from Explore to SQL.

Distinguish dimension types (string, number, time, yesno, tier, duration) and pick the correct type for ten sample business fields.

Build a minimal LookML project with one view file and one model file, then validate it with the project health tools.

Explain to a non-technical stakeholder what an Explore is versus a dashboard, using your own working instance.

Define primary keys, foreign keys, and join relationships in LookML and justify each join's relationship type.

Create dimensions, dimension groups for time fields, and measures with the correct aggregate type for additive and non-additive metrics.

Use symmetric aggregates to prevent fan-out and demonstrate the difference in results with a one-to-many join.

Configure a derived table or native derived table and explain when each is preferable to a persistent table.

Refactor repeated filter and dimension logic into a refinement or extends pattern and confirm downstream Explores still validate.

Apply access filters and field-level access to restrict a sensitive column and verify the restriction as a test user.

Implement parameters and templated filters in a derived table and document the resulting SQL.

Trace a slow Explore to its generated SQL and identify at least one modeling cause of the slowdown.

Design an Explore with a curated field picker, sensible default filters, and required filters where full scans would be costly.

Build pivot and row-total configurations that answer a specific business question without post-processing.

Select the correct visualization type for five different question shapes and justify each choice in one sentence.

Configure drill fields and drill links so a user can move from a summary tile to row-level detail.

Create a dashboard with filters that cross-filter multiple tiles and confirm filter behavior on each tile.

Apply table calculations for percent-of-total and running totals and verify them against a hand calculation.

Write a custom measure or table calculation using a documented function and explain its evaluation order.

Tune a dashboard for performance by reducing tile count or query cost and record the before-and-after load behavior.

Schedule a recurring delivery to a destination and confirm the recipient receives correctly formatted output.

Set up an alert with a threshold condition and describe what triggers it and what does not.

Compare sharing via schedules, alerts, and embedded or public access, and state the governance risk of each.

Apply content validation and fix or retire at least one broken content item.

Audit a folder's content access using roles and permission sets and correct one over-permissioned group.

Use System Activity Explores to report on query history and identify the most expensive recurring queries.

Document a content-organization convention (folders, naming, boards) and apply it to your practice content.

Explain how Looker handles data access versus content access and where each is enforced.

Complete a timed full-length practice set and score each domain separately to find weak areas.

Rebuild from scratch the two weakest artifacts from earlier weeks without notes.

Review every missed question and write the underlying rule, not just the correct answer.

Confirm readiness by re-taking the weakest domain's practice questions and comparing scores.