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 BI developer

        Learn to query and shape data, model it for reporting, write the measures behind a dashboard and build reports people trust, in Power BI and in Tableau. Every exercise is checked, and the pathway ends in dashboard projects, a timed assessment across the tools and the interview.

        Tools
        SQL, Power Query, Power BI, Tableau, Looker and LookML
        Units
        38 units, 192 lessons
        Checked exercises
        1,017
        Cross-tool projects
        5
        Final assessment
        15 tasks, 65 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 192 lessons
        Projects
        0 of 5 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.

        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
        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
        Greenbasket Market
        Google SheetsSQLTableau
        Project

        The empty-shelf problem

        Store managers say shelves keep running empty, but the shelf checks are messy. Mark every check, compare the stores fairly and show availability next to how much was checked.

        4 stages · 2 h 10 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
        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
        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

        The job-readiness assessment

        When you finish the units, test yourself across the tools of the job at once: 15 practical tasks in 65 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
        Power Query311
        Power BI315
        Tableau315

        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 bI developer 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 bI developer interview

        What each plan opens

        Free
        The first unit of every course, with no account: 4 of the 38 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 (7 units), Power Query (6 units), Power BI (12 units), Tableau (7 units), Looker and LookML (6 units).
        All Access
        The whole pathway: every unit, every project stage and spoken interview practice.

        See plans and prices

        What a BI developer does

        A BI developer builds the reports and dashboards a company runs on, and the data models underneath them. They agree on what a measure means, write it once so every report shows the same number, control who sees which rows, and keep reports fast as the data grows. When two dashboards disagree, they are the person who finds out why.

        From a query to a governed report

        SQL comes first because every report starts with data you can query. Power Query prepares that data so refreshes are automatic. Power BI is the longest step, from a first chart to security and publishing. Tableau comes last, so you can work in either tool.

        Showing what you can do

        At Copperline, operations and finance report two different on-time rates for the same month. You find out why, write the measure both teams agree on and recommend which number goes to customers. At Greenbasket you show shelf availability fairly across stores in Tableau. Each is a story about a number people trust again, which is what BI interviews look for. The assessment then shows which tool to practice before you apply.

        Common questions

        Is a BI developer the same as a data analyst?

        They overlap. A data analyst answers questions; a BI developer builds and maintains the models and reports many people use to answer their own. That is why this pathway goes deeper into Power BI modeling, security and publishing than the data analyst pathway.

        Power BI or Tableau?

        Read the ads for the jobs you want: they usually name one. This pathway covers both because the ideas carry over and many employers list either. If you know which one you need, take its units first.

        How long does it take?

        The lessons on this pathway add up to about 47 hours. The Power BI step is the longest on purpose. 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.