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.

        How to become an analytics engineer

        Learn SQL modeling, version control in Git, tested transformations in dbt and a cloud warehouse, so the numbers every dashboard shows come from one trusted place. Every exercise is checked, and the pathway ends in warehouse projects, a timed assessment across the tools and the interview.

        Tools
        SQL, Git, dbt, Snowflake SQL, Looker and LookML
        Units
        34 units, 160 lessons
        Checked exercises
        846
        Cross-tool projects
        3
        Final assessment
        15 tasks, 60 minutes

        About 45 hours of lessons, from the estimate on each lesson.

        Your progress

        Nothing done yet. Progress saves in this browser as you finish lessons, and in your account when you sign in.

        Lessons
        0 of 160 lessons
        Projects
        0 of 3 finished
        Assessment
        Not taken yet

        Start with Query a table

        The pathway, unit by unit

        Take the steps in this order. Each step is a set of units from one course, not the whole course: the units this role uses. Open a unit to start its first lesson.

        1. Semantic models in LookML

          Build reusable warehouse fields and measures, test join grain and save a dashboard definition. Use access filters for regional restrictions and check the source totals before sharing.

          1. Views and measuresBeginner · 5 lessons · 28 exercises
          2. Joins and grainIntermediate · 5 lessons · 29 exercises
          3. Derived-table modelsAdvanced · 4 lessons · 24 exercises
          4. Governed accessAdvanced · 5 lessons · 29 exercises
          5. Model reviewExpert · 4 lessons · 25 exercises

        Projects for this role

        Each project starts from a fictional company's brief and moves between tools the way the job does: what you build in one stage is where the next one starts. Every brief is free to read.

        Copperline Freight
        SnowflakedbtTableau
        Project

        Move the on-time report into the warehouse

        Copperline's on-time report is a spreadsheet someone rebuilds every Monday. Rebuild it on the warehouse: one current row per shipment in Snowflake, a tested dbt model, and a Tableau view operations can trust.

        4 stages · 2 h 40 minView brief
        Wayfriend
        DatabricksdbtSQLDagster
        Project

        From invites to meetups

        Wayfriend wants to know whether friends who plan to meet actually spend time together. Clean the raw events, model meetups, measure success and plan the next day of work.

        5 stages · 3 h 30 minView brief
        Copperline Freight
        SQLPower BI
        Case study

        Two dashboards, two on-time numbers

        Operations reports one on-time rate and finance reports a lower one, for the same month. Find out why, write the measure both teams agree on, and recommend which number goes to customers.

        3 stages · 1 hView brief

        The job-readiness assessment

        When you finish the units, test yourself across the tools of the job at once: 15 practical tasks in 60 minutes, each in the tool it is about and checked automatically. The clock keeps running if you close the page.

        ToolTasksMinutes
        Looker and LookML311
        SQL311
        Git311
        dbt313
        Snowflake SQL311

        How it is scored

        Each tool
        Ready when you get two thirds of its tasks right or more, Close at one third, otherwise Not yet. A coding task earns the share of its tests that pass.
        Ready for interviews
        75% or more overall, and every tool at Ready.
        Nearly ready
        50% or more overall, and no tool at Not yet.
        Keep practicing
        Anything else. The report lists every task you missed with the lesson that teaches it.

        Open the assessment

        The assessment is free. The result is practice feedback in the Interview Hub's report format, not a hiring decision. Retakes draw different tasks where the question pools allow.

        The interview

        The Interview Hub runs the analytics engineer interview round by round, at a fictional employer: you answer out loud or in writing, the interviewer follows up, and the report quotes your answers.

        Practice the analytics engineer interview

        What each plan opens

        Free
        The first unit of every course, with no account: 4 of the 34 units on this pathway. Every project brief is free to read, and the job-readiness assessment is free.
        One Course
        One course in full. On this pathway that is one of these: SQL (9 units), Git (5 units), dbt (9 units), Snowflake SQL (6 units), Looker and LookML (5 units).
        All Access
        The whole pathway: every unit, every project stage and spoken interview practice.

        See plans and prices

        What an analytics engineer does

        An analytics engineer sits between data engineering and analysis. They take the raw tables that land in the warehouse and build the clean, tested models everyone else reports from: one definition of revenue, one table of active customers, one on-time rate. They write SQL in dbt, review each other’s changes in Git and add tests so a broken source shows up before a wrong number reaches a dashboard.

        From a query to a tested model

        SQL and modeling come first because every later step is SQL. Git follows because dbt projects live in repositories. dbt is the longest step and the heart of the job. The warehouse comes last, when you know what you are running in it.

        Showing what you can do

        Copperline’s on-time report is a spreadsheet someone rebuilds every Monday. You move it onto the warehouse: one current row per shipment in Snowflake, a tested dbt model and a view operations can trust. At Wayfriend you model meetups from raw events. Both are the kind of project analytics engineering interviews ask about. The assessment then shows which tool to practice before you apply.

        Common questions

        What is the difference between an analytics engineer and a data engineer?

        A data engineer gets data into the warehouse and keeps the pipelines running. An analytics engineer turns those raw tables into tested, documented models that analysts and dashboards use. The data engineer pathway adds Python and orchestration; this one goes deeper into modeling and dbt.

        Do I need to know Python?

        Not to start. Analytics engineering is mostly SQL, dbt and Git. Python helps later, and the Python course is there when you need it.

        How long does it take?

        The lessons on this pathway add up to about 45 hours. We don't promise how long getting hired takes.

        What does it cost?

        The first unit of every course is free, with no account. One Course opens one course in full; All Access opens the whole pathway. The pricing page shows every plan and its price.

        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.

        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.