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/Copperline Freight

        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.

        ProjectCopperline Freight · fictional company2 h 40 min4 stagesData and analytics

        One brief, 3 toolsYour tables pass from Snowflake to dbt to Tableau. You finish with a readout for operations.

        Copperline Freight

        Freight and logistics

        About the company

        A freight carrier that moves shared truckloads on six lanes between Canadian cities.

        Copperline Freight carries less-than-truckload freight: pallets from businesses that ship too little to fill a truck, such as pharmacies, food suppliers and furniture makers. Its six lanes are Toronto to Montreal, Toronto to Ottawa, Calgary to Edmonton, Vancouver to Calgary, Winnipeg to Regina and Montreal to Halifax. Every shipment gets a promised delivery date, and on-time delivery is the number customers watch, yet it still lives in a spreadsheet that someone rebuilds by hand every Monday. You work with operations, which runs the trucks and the docks, and with finance.

        More at Copperline Freight

        Founded
        1987
        Head office
        Toronto, Ontario
        Lanes
        6, across nine cities
        Employees
        About 350

        Who writes the briefs

        • Luc BergeronDirector of Operations
        • Aisha MensahChief Operating Officer

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

        The brief

        From
        Luc BergeronDirector of Operations
        To
        Analytics
        Subject
        The Monday on-time spreadsheet

        Every Monday someone exports shipments from the transport system and rebuilds our on-time numbers by hand, and every Monday the number is a little different. Now that the export lands in Snowflake every night, I'd like the report rebuilt there so it is the same for everyone.

        Watch out: the system writes a new row every time a shipment changes (booked, in transit, delivered or cancelled), so the raw table has two to four rows per shipment. A shipment delivered on its promised day counts as on time.

        Done looks like: one current row per shipment, a tested model of deliveries, a view of on-time delivery by lane, and a short readout on which lanes need attention.

        • Data: every change logged for about 170 shipments in September and October 2026.
        • You deliver a deduplicated table, a tested dbt model, a Tableau view and a readout.
        • Checks cover the latest version of each shipment, in-transit shipments and deliveries on the promised day.

        The project path

        1. 1
          Snowflake35 min

          Keep the latest version of each shipment

          One row per shipment, its latest change, with QUALIFY.

          Reads
          shipment_events
          Produces
          shipments_latest

          dbt reads the latest shipments.

          Open stageOne Course in Snowflake or All Access
        2. 2
          dbt50 min

          Model the deliveries

          A tested model of delivered shipments with days late and an on-time flag.

          Reads
          shipments_latest
          Produces
          fct_deliveries

          Tableau reads the delivery model.

          Open stageOne Course in dbt or All Access
        3. 3
          Tableau35 min

          Show on-time delivery by lane

          An on-time rate calculation and a view of every lane, worst first.

          Reads
          fct_deliveries
          Produces

          Your readout cites the view.

          Open stageOne Course in Tableau or All Access
        4. 4
          Readout20 min

          Tell operations which lanes need attention

          Name the weakest lanes, say what the new report changes, and propose the next step.

          Reads
          fct_deliveries
          Produces
          on_time_readout.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.