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 a data analyst

        Learn the skills data analyst jobs ask for in the order analysts use them: spreadsheets, SQL, a dashboard tool, then Python. Every exercise is checked as you go, and the pathway ends in projects, a timed assessment across the tools and the interview.

        Tools
        Excel, SQL, Power BI, Python, pandas, Looker and LookML
        Units
        39 units, 226 lessons
        Checked exercises
        1,193
        Cross-tool projects
        5
        Final assessment
        15 tasks, 60 minutes

        About 47 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 226 lessons
        Projects
        0 of 5 finished
        Assessment
        Not taken yet

        Start with Formula basics

        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. Python basics

          Enough Python to read a script, change it and write your own: variables, lists, dictionaries, loops and functions. pandas makes sense after this.

          1. BasicsBeginner · 5 lessons · 26 exercisesFree
          2. CollectionsBeginner · 6 lessons · 33 exercises
          3. Control flowBeginner · 5 lessons · 30 exercises
          4. FunctionsBeginner · 4 lessons · 24 exercises
        2. 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. Explore reportsBeginner · 5 lessons · 28 exercisesFree
          2. Views and measuresBeginner · 5 lessons · 28 exercises
          3. Dashboard deliveryIntermediate · 5 lessons · 29 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.

        Hearthline
        ExcelSQLpandasPower BI
        ProjectFree

        Why is profit falling when sales are up?

        Your first week as Hearthline's data analyst. Turn a messy order export into gross profit in Excel, roll it up in SQL, measure what each discount code costs in pandas, chart the margin in Power BI and tell your manager what to change.

        5 stages · 2 h 30 minView brief
        Greenbasket Market
        ExcelSQLPower BI
        Project

        Did the summer promotions pay?

        Marketing ran eight promotions this summer and wants to plan the fall. Turn the offers into numbers, measure each one against the weeks before it, total the extra sales and write the memo.

        4 stages · 2 h 30 minView brief
        Greenbasket Market
        SQLExcel
        Case study

        Why did September revenue drop?

        The monthly report shows September down on August, and the CFO wants to know why before the board meeting. Separate the calendar from a real decline and say where it came from.

        3 stages · 1 hView 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
        Pennant
        SQLpandas
        Case study

        Is the annual offer result real?

        A checkout test offered half the visitors an annual plan. The dashboard says it worked; count the test fairly and decide whether the difference is real before it ships.

        3 stages · 1 hView brief
        Greenbasket Market
        ExcelSQLPower BIGoogle SheetsTableau
        Journey

        Your first 90 days as a data analyst

        You've joined Greenbasket's two-person analytics team. Review the summer promotions, find the stores running out of stock, then explain a bad month to the CFO.

        4 chapters · 5 h 40 minSee the journey

        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
        Excel310
        SQL311
        Power BI315
        pandas313

        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 data analyst 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 data analyst interview

        What each plan opens

        Free
        The first unit of every course, with no account: 6 of the 39 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: Excel (9 units), SQL (8 units), Power BI (7 units), Python (4 units), pandas (8 units), Looker and LookML (3 units).
        All Access
        The whole pathway: every unit, every project stage and spoken interview practice.

        See plans and prices

        What a data analyst does

        A data analyst turns raw records into answers people can act on: which stores sold less after a price change, why sign-ups fell in March, what a promotion really cost. Most of the job is getting the data, checking it and explaining what it means to someone who has to decide. The tools differ from one company to the next. The work doesn’t.

        The skills, in the order you use them

        Analyst job ads usually name a spreadsheet, SQL, a dashboard tool and often Python. This pathway follows that order. Each step takes only the units an analyst needs from that course, so you reach the projects sooner. When you want more depth in one tool, the rest of its course is there.

        Showing what you can do

        Employers want to see work, not a list of courses. The projects start from a fictional company’s brief and move between tools the way the job does. In Hearthline’s profit question you clean an order export in Excel, roll it up in SQL, price each discount code in pandas and chart the margin in Power BI. Finish one and you have something specific to walk through in an interview. The assessment then shows which tool to practice before you apply.

        For database reports, practice SQL query optimization: read the plan and preserve the result as you rewrite the query. The SQL cheat sheet covers the query syntax.

        Common questions

        How long does it take to become a data analyst?

        The lessons on this pathway add up to about 47 hours. How many weeks that is depends on how much time you have. Getting hired also depends on your background and on the jobs near you, so we don't promise a timeline.

        Do I need a degree or experience to start?

        You need no experience: every course on the pathway starts from first steps. Whether a job asks for a degree is up to the employer, so read the ads you plan to apply to. This pathway gives you practice and projects to show, not a credential.

        How is this different from the data analyst course page?

        The data analyst course path lists whole courses in order. This pathway takes only the units an analyst uses from each course, adds a timed assessment across the tools, and tracks your progress through all of it.

        Is there a certificate at the end?

        No. The Work Gym doesn't issue certificates, and this pathway isn't a program from Microsoft, Google or any other vendor. You get a record for each project and mock exam you finish, with a code anyone can check, and the assessment report.

        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.