One Course
Every lesson, project and mock exam in Looker and LookML.
Billed monthly. Cancel any time.
Level 1: Newcomer
0 points
Sign in to save your progress across devices.
Courses / Data and analytics tools
Practice Looker and LookML in your browser. Query an Explore, define reusable measures, repair a join and build a dashboard from checked results. The course includes focused Data Studio basics, under its former Looker Studio name, plus projects, cases and timed assessments.
Unit 1, Explore reports: 5 lessons and 28 checked exercises, with no account or card.
Start the free unitThe rest of the course opens with a One Course or All Access plan. See plans and prices
Choose access here. Your course is already selected.
Compare transaction counts, distinct customers and average revenue on new order data.
5 steps · 20 minProject · IntermediateOutdoor equipment salesBuild profit measures and a completed-sales dashboard for an equipment retailer.
6 steps · 20 minCase study · IntermediateA refund reportSeparate return activity, missing revenue and completed sales before calculating margin.
5 steps · 20 minProject · IntermediateService orders reviewPrepare an operations dashboard from service orders and check the sharing boundary.
6 steps · 20 minProject · AdvancedRegional reporting modelModel regional derived totals and hand operations a reproducible saved dashboard.
6 steps · 20 minProject · AdvancedRegional reviewer accessApply regional user restrictions and a permanent completed-order population rule.
6 steps · 20 minProject · AdvancedA Studio operations reportBuild a dated Studio report and reconcile its metrics with a saved Looker dashboard.
6 steps · 20 minProject · ExpertA model change reviewReview contribution, completed sales, margin and field naming before a modeled release.
6 steps · 20 minProject · ExpertReporting releasePrepare a regional reporting handoff with freshness and saved-content validation decisions.
6 steps · 20 minMock exam · ExpertTimed job test AComplete twelve timed tasks covering Explore, LookML, joins, derived tables and Studio.
12 questions · 30 minCase study · ExpertInconsistent totalsInvestigate conflicting regional totals and identify the missing access-control evidence.
5 steps · 20 minProject · ExpertAn executive reviewCreate an executive review that preserves revenue, customer and margin definitions between charts.
6 steps · 20 minMock exam · ExpertTimed job test BApply advanced reporting and governance skills to twelve fresh tasks under a thirty-minute clock.
12 questions · 30 minLearn Looker and LookML by editing a semantic model and querying a fictional order warehouse in your browser. Build dimensions and measures, repair joins, check fanout, define derived tables and apply row restrictions. Save dashboard queries and practice Data Studio (formerly Looker Studio) source, chart, date and credential settings. Each result is checked on the visible data and a second fixture. Projects carry your work between steps, and two timed job tests mix modeling and reporting tasks. The environment is an independent simulation with a documented SQL subset. It does not connect to Google, deploy models or run warehouse schedules.
Beginner
Practice explore reports with checked warehouse tasks.
Practice views and measures with checked warehouse tasks.
Practice model presentation with checked warehouse tasks.
Intermediate
Practice joins and grain with checked warehouse tasks.
Practice metric definitions with checked warehouse tasks.
Practice dashboard delivery with checked warehouse tasks.
Advanced
Practice derived-table models with checked warehouse tasks.
Practice governed access with checked warehouse tasks.
Practice data studio (looker studio) basics with checked warehouse tasks.
Expert
Practice model review with checked warehouse tasks.
Practice freshness and release with checked warehouse tasks.
Practice applied analyst work with checked warehouse tasks.
Work from a result you can explain. If an order total doubles after a join, changing the chart will not repair the measure. The course builds that habit from the first Explore: inspect the fields, name the grain and check the rows that can break the answer.
Use the Looker vs Looker Studio guide to choose the workflow your role needs. For warehouse SQL practice alongside LookML, continue with BigQuery or SQL.
No. The course runs in our own browser simulator with fictional data. It does not connect to a production warehouse, deploy LookML or publish reports in Google's service. The Work Gym is independent of Google.
The main course teaches Looker and LookML. It includes Data Studio basics, the product formerly called Looker Studio, with a separate tutorial for report fields, dates and credentials. It does not reproduce all Data Studio connectors or its report canvas.
The former Looker Business Analyst and LookML Developer exams are retired. Our assessments check practical skills with original questions and do not award a Google credential. Read the certification status guide.
Start with Explore totals and joins, then save a checked query as a dashboard tile. The dashboard tutorial explains an original example and filter checks.
The first unit of the course is free. Access to later units follows the plan shown on the pricing page.