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

        Case studyGreenbasket Market · fictional company1 h3 stagesSQL → Excel → Recommendation

        You write the recommendationIt goes to the CFO. Say what the evidence shows and what still needs checking.

        Greenbasket Market

        Grocery retail

        About the company

        A grocery chain with twelve stores in four Ohio cities.

        Greenbasket Market sells fresh food and everyday groceries in Columbus, Dayton, Cincinnati and Cleveland. Six of its stores are small neighborhood shops and six are larger superstores. The sales you work with cover five categories: produce, dairy, bakery, snacks and beverages. Much of the data is typed in by hand in the stores and in marketing, so it is rarely clean. Requests come from category management, store operations and finance, and you sit in a two-person analytics team at the head office.

        Founded
        1998
        Head office
        Columbus, Ohio
        Stores
        12 in four cities
        Employees
        About 1,300

        Who writes the briefs

        • Dana WhitfieldCategory Director
        • Marcus BellHead of Store Operations
        • Priya RamanCFO

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

        The situation

        From
        Priya RamanCFO
        To
        Analytics
        Subject
        September is down

        The monthly report has September net sales well below August, and the board will ask about it on Thursday. Is this a problem in the stores, or something else? If it is real, I need to know where it is coming from.

        You have weekly sales by store and category. Weeks run Monday to Sunday and each one is filed under the month its Monday falls in. Tremont was closed for a refit in the week of August 31.

        Done looks like: August and September compared fairly, the change shared out across cities and categories, and a recommendation I can take to the board.

        • Data: weekly sales for 12 stores and 5 categories, August and September 2026.
        • You deliver a month comparison, a share of the change for each city and category, and a recommendation.
        • The recommendation is reviewed against a four-point rubric.

        The evidence

        SQL

        1. Compare the months week for week

        Count the weeks in each month and compare sales per week, by city and category.

        Reads:
        weekly_sales · stores
        Produces:
        month_compare
        Time:
        20 minutes
        Open SQLOne Course in SQL or All Access
        Excel

        2. Share out the change

        Work out how much of the chain's change in weekly sales each city and category accounts for.

        Reads:
        month_compare
        Produces:
        drop_drivers
        Time:
        20 minutes
        Open ExcelOne Course in Excel 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.