Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        Courses / Data and analytics tools

        Looker tutorial and LookML course

        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.

        Start lesson 1Practice interviewTake the assessmentPractice the first unit of every course. No account needed.
        57lessons
        345checked exercises
        15projects, cases and exams
        Prepares you for BI developer, data analyst and analytics engineer job tests

        What you will be able to do

        • Choose dimensions, measures, filters and sorts in an Explore
        • Define views and SQL-backed dimensions, counts, sums and ratios in LookML
        • Test primary keys, nulls and join fanout before trusting a measure
        • Build SQL derived tables and explain the boundaries of persistence
        • Save dashboard tiles and check their filter scope
        • Use access filters and distinguish hidden fields from data restrictions
        • Practice Data Studio dimensions, metrics, dates, blends and credentials

        Who it is for

        You analyze modeled warehouse data
        Practice tracing a report result back to its fields, filters and join relationships.
        You want to work on LookML models
        Edit a model, inspect the resulting query and test totals on original fictional data.
        Your role mentions Looker Studio
        The Studio basics lessons cover the report-builder concepts of the product now called Data Studio. They are a focused introduction within the Looker course.

        What you can practice free

        Unit 1, Explore reports: 5 lessons and 28 checked exercises, with no account or card.

        Start the free unit

        The rest of the course opens with a One Course or All Access plan. See plans and prices

        Keep going in Looker and LookML

        Choose access here. Your course is already selected.

        One Course

        Every lesson, project and mock exam in Looker and LookML.

        Loading price/ month

        Billed monthly. Cancel any time.

        All Access

        Every course, exam and project, plus the Interview Hub.

        Loading price/ month

        Billed monthly. Cancel any time.

        Projects, case studies and mock exams

        Case study · BeginnerRepeated customers

        Compare transaction counts, distinct customers and average revenue on new order data.

        5 steps · 20 min
        Project · IntermediateOutdoor equipment sales

        Build profit measures and a completed-sales dashboard for an equipment retailer.

        6 steps · 20 min
        Case study · IntermediateA refund report

        Separate return activity, missing revenue and completed sales before calculating margin.

        5 steps · 20 min
        Project · IntermediateService orders review

        Prepare an operations dashboard from service orders and check the sharing boundary.

        6 steps · 20 min
        Project · AdvancedRegional reporting model

        Model regional derived totals and hand operations a reproducible saved dashboard.

        6 steps · 20 min
        Project · AdvancedRegional reviewer access

        Apply regional user restrictions and a permanent completed-order population rule.

        6 steps · 20 min
        Project · AdvancedA Studio operations report

        Build a dated Studio report and reconcile its metrics with a saved Looker dashboard.

        6 steps · 20 min
        Project · ExpertA model change review

        Review contribution, completed sales, margin and field naming before a modeled release.

        6 steps · 20 min
        Project · ExpertReporting release

        Prepare a regional reporting handoff with freshness and saved-content validation decisions.

        6 steps · 20 min
        Mock exam · ExpertTimed job test A

        Complete twelve timed tasks covering Explore, LookML, joins, derived tables and Studio.

        12 questions · 30 min
        Case study · ExpertInconsistent totals

        Investigate conflicting regional totals and identify the missing access-control evidence.

        5 steps · 20 min
        Project · ExpertAn executive review

        Create an executive review that preserves revenue, customer and margin definitions between charts.

        6 steps · 20 min
        Mock exam · ExpertTimed job test B

        Apply advanced reporting and governance skills to twelve fresh tasks under a thirty-minute clock.

        12 questions · 30 min

        Learn 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

        FreeNo account or card needed. Every lesson in this unit is yours to practice.

        Explore reports

        Practice explore reports with checked warehouse tasks.

        5 lessons

        Views and measures

        Practice views and measures with checked warehouse tasks.

        5 lessons

        Model presentation

        Practice model presentation with checked warehouse tasks.

        5 lessons

        Intermediate

        Joins and grain

        Practice joins and grain with checked warehouse tasks.

        5 lessons

        Metric definitions

        Practice metric definitions with checked warehouse tasks.

        5 lessons

        Dashboard delivery

        Practice dashboard delivery with checked warehouse tasks.

        5 lessons

        Advanced

        Derived-table models

        Practice derived-table models with checked warehouse tasks.

        4 lessons

        Governed access

        Practice governed access with checked warehouse tasks.

        5 lessons

        Data Studio (Looker Studio) basics

        Practice data studio (looker studio) basics with checked warehouse tasks.

        5 lessons

        Expert

        Model review

        Practice model review with checked warehouse tasks.

        4 lessons

        Freshness and release

        Practice freshness and release with checked warehouse tasks.

        4 lessons

        Applied analyst work

        Practice applied analyst work with checked warehouse tasks.

        5 lessons

        A model before a chart

        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.

        Common questions

        Do I need a Looker account?

        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.

        Is this a full Looker Studio course?

        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.

        Does it prepare me for a Looker certification?

        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.

        Where should I start with dashboards?

        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.

        What is free?

        The first unit of the course is free. Access to later units follows the plan shown on the pricing page.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Change your plan

        Checking the price

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.