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/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.

        Case studyCopperline Freight · fictional company1 h3 stagesSQL → Power BI → Recommendation

        You write the recommendationIt goes to the chief operating officer. Say what the evidence shows and what still needs checking.

        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 situation

        From
        Aisha MensahChief Operating Officer
        To
        Analytics
        Subject
        Which on-time number is right?

        Operations' dashboard says we delivered most shipments on time in October. Finance's dashboard says the rate is lower, and our biggest customer has seen both. I don't want to argue about whose dashboard is broken. I want to know why they differ, one measure we all use, and which number we put in the customer report.

        You have the dispatch snapshot: one row per shipment with its status, dates and an on-time flag that is blank until a shipment is delivered.

        Done looks like: both definitions side by side by month, one agreed measure in the shared Power BI model, and a recommendation.

        • Data: about 170 shipments booked in September and October 2026.
        • You deliver a reconciliation by month, an agreed Power BI measure and a recommendation.
        • The recommendation is reviewed against a four-point rubric.

        The evidence

        SQL

        1. Put both definitions side by side

        Both on-time rates by month, from the same shipments.

        Reads:
        shipments
        Produces:
        definitions
        Time:
        20 minutes
        Open SQLOne Course in SQL or All Access
        Power BI

        2. Write the agreed measure

        One On Time % measure in the shared model, by lane.

        Reads:
        shipments
        Produces:
        Time:
        20 minutes
        Open Power BIOne Course in Power BI or All Access

        3. Your recommendation

        Use the reference evidence or your checked tables. Make the call, support it with a comparison, and say what would change your mind. Allow 20 minutes.

        Case study 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.