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.

        Power BI projects for your portfolio

        Power BI projects that go from a messy file to a finished report: clean it in Power Query, model it, write the measures and build the page. Every step is checked, and each project ends in a record you can share.

        Projects that move between tools

        One company brief, worked through each tool in turn. Your own tables carry from one stage to the next, and you finish with a written readout. 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
        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
        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
        Marlow & Pike
        AccountingExcelPower BI
        Project

        Close October and explain the cash

        October looks profitable, yet cash ended well below forecast. Post the adjusting entries, put each cash line next to its forecast in Excel, build the CFO's view in Power BI and write the month-end note.

        4 stages · 1 h 40 minView brief

        Projects and case studies in the Power BI course

        11 briefs inside the course, each a realistic task checked step by step in the tool.

        What you can show at the end

        A record with a verification code. Each project, case study and mock exam you finish gets a record that says what you did and when. Anyone you share the code with can check it.

        A portfolio page. Your records collect on one page you can link from a CV or a LinkedIn profile. Check a record

        A convincing Power BI project

        A Power BI project is most convincing when it shows the whole chain: data cleaned in Power Query, a model with sensible relationships, measures that give the right number when a slicer changes, and a page someone can read in a minute. The projects in the Power BI course follow that chain, starting with a store performance one-pager at beginner level and ending with a capstone, the full sales analytics report.

        You build each one in our Power BI simulator, with the report canvas, the fields pane, the Power Query editor and the DAX formula bar. Each step is checked against what the report or measure should return.

        Projects across tools

        In the library above, Did the summer promotions pay? ends in Power BI after Excel and SQL, and Two dashboards, two on-time numbers asks why operations and finance report different numbers for the same month, then has you write the measure both teams agree on.

        Next steps

        If you are aiming for the PL-300 exam, see Power BI certification: PL-300 exam prep. To rehearse the interview, the Interview Hub has spoken Power BI interviews.

        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.