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.

        Projects/Tradewind

        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.

        ProjectTradewind · fictional company2 h 20 min4 stagesData and analytics

        One brief, 3 toolsYour tables pass from BigQuery to pandas to a Google Sheets model. You finish with a recommendation memo.

        Tradewind

        Online marketplace

        About the company

        An online marketplace for second-hand furniture in the Netherlands.

        On Tradewind, private sellers and small dealers list used sofas, tables, chairs, storage and lighting, and buyers nearby make an offer. The marketplace runs in Amsterdam, Rotterdam, Utrecht, Eindhoven and Groningen. Tradewind earns a commission on every sale, a flat 12% today, and the marketplace team decides the fees. A small lamp costs as much to support as a sofa but earns a fraction of the commission. You work in the analytics team that answers the marketplace team's questions.

        Founded
        2017
        Head office
        Utrecht, Netherlands
        Cities
        5
        Employees
        About 45

        Who writes the briefs

        • Joost van DijkHead of Marketplace

        A fictional company, invented for practice. Meet the other companies

        The brief

        From
        Joost van DijkHead of Marketplace
        To
        Analytics
        Subject
        Tiered commission

        We take 12% of every sale today. Small items cost us as much to support as sofas, so I'd like to test tiered fees: 15% under 50 euros, 12% up to 149, 10% up to 399 and 8% from 400. Before I take it to the board I need to know what it would do to our commission, and whether the bands where we raise the fee are the ones that sell fastest.

        You have four months of listings with the asking price and, when an item sold, the sale date and price. Every listing has had at least 30 days by the data cut on October 31.

        Done looks like: sell-through within 30 days by category and price band, how far below the asking price items sell, a model of the tiered fee against today's flat 12%, and a short recommendation.

        • Data: 340 listings from June to September 2026.
        • You deliver sell-through by band, a price realization table, a fee model and a memo.
        • Checks cover the 30-day window, the band edges and fees on sales rather than rates.

        The project path

        1. 1
          BigQuery35 min

          Measure sell-through by price band

          How many listings in each category and price band sold within 30 days, and what they brought in.

          Reads
          listings
          Produces
          sell_through

          Google Sheets reads the sell-through table.

          Open stageOne Course in BigQuery or All Access
        2. 2
          pandas30 min

          How far below the asking price?

          The median sale-to-asking ratio by price band, private sellers next to dealers.

          Reads
          listings
          Produces
          realization

          Your memo cites the ratios.

          Open stageOne Course in pandas or All Access
        3. 3
          Google Sheets30 min

          Model the tiered commission

          What each row would pay under the tiers, beside its sales.

          Reads
          sell_through
          Produces
          fee_model

          Your memo compares the totals.

          Open stageOne Course in Google Sheets or All Access
        4. 4
          Readout20 min

          Write the recommendation

          Tell the head of marketplace what the tiers would earn, who pays more, and whether to test them.

          Reads
          fee_model · realization
          Produces
          tiered_fee_memo.md

          Optional: present it in Interview Hub.

          Open stageAll Access

        Each stage includes reference inputs. Starting in the middle or using them doesn't complete the earlier stages.

        Project access

        Free

        $0

        Read all briefs and paths. Tool stages and written work are locked.

        Keep browsing

        One Course

        $17.99/month

        Practice the stages in your chosen tool. Reference tables let you start at that stage.

        All Access

        $29.99/month

        Every stage in every format, plus optional spoken readouts using dumbbells.

        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.