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.

        Data analytics projects for your portfolio

        Analyst work rarely stays in one tool. These projects take one company's question through Excel, SQL, Power BI, Tableau or pandas, the way the job does, and end in a written readout and 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
        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
        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
        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
        Pennant
        SQLpandasMachine learning
        Project

        Who cancels in the first 90 days?

        Pennant loses too many subscribers in their first three months. Build a churn table without peeking at the future, find who leaves, fit a first model and plan what the retention team should try.

        4 stages · 2 h 50 minView 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
        Tradewind
        BigQuerypandasGoogle Sheets
        Project

        Should cheap listings pay a higher fee?

        Tradewind takes a flat 12% on every sale. The marketplace lead wants tiered fees. Measure what sells in each price band, how far below the asking price it sells, and model what the tiers would earn.

        4 stages · 2 h 20 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
        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
        Wayfriend
        DatabricksSQL
        Case study

        The reminder question

        Denver tested reminder notifications before planned meetups. Decide whether Wayfriend should send them in every city.

        3 stages · 45 minView brief
        Quillfield
        SalesforcePower AutomateExcel
        Project

        Find the leads nobody is calling

        Demo requests from the Central region have gone quiet since August. Fix the Salesforce rule that sends them to a rep who left, build the flow that tells each owner about a new lead, and report conversion by owner in Excel.

        4 stages · 1 h 50 minView brief

        Projects and case studies in the Excel course

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

        See all 19 in the Excel course

        Projects and case studies in the SQL course

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

        See all 12 in the SQL course

        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.

        See all 11 in the Power BI course

        Projects and case studies in the Tableau course

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

        See all 11 in the Tableau course

        Projects and case studies in the pandas course

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

        See all 10 in the pandas course

        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

        Project format

        Each project in the library starts with a brief from a fictional company: who is asking, what they want to decide and what data there is. You work through stages, each in its own tool, and the tables you produce in one stage are the tables the next stage starts from. Get a stage wrong and you find out then. Not three tools later.

        Most projects end in a written readout: a short memo or recommendation that answers the question. It’s reviewed against what a good answer must cover, the same way the Interview Hub reviews a typed answer.

        Starting points

        Start small. If you are new to analysis, pick a case study inside one course, such as the ones from the Excel or SQL course below. If you have the basics, Your first 90 days as a data analyst strings three projects and case studies at one company into a journey.

        Tool by tool

        There are separate pages for Excel projects, SQL projects and Power BI projects, and every course page lists its own. When you are ready to interview, the Interview Hub has spoken data analyst interviews, round by round.

        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.