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

        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.

        ProjectGreenbasket Market · fictional company2 h 30 min4 stagesData and analytics

        One brief, 3 toolsYour tables pass from Excel to SQL to Power BI. You finish with a memo for the category director.

        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 brief

        From
        Dana WhitfieldCategory Director
        To
        Analytics
        Subject
        Summer promotions, before we book the fall calendar

        We ran eight promotions between August and September across all twelve stores. Before I sign off the fall calendar on Friday, I need to know which ones actually brought in extra sales and which just gave margin away. Marketing's calendar is attached as they typed it: the offers are text like "20% off" and one is a buy-one-get-one.

        You have thirteen weeks of category sales by store, starting Monday July 6, and the calendar. Tremont was closed for a refit in the week of August 31, so it has no rows that week.

        Done looks like: the offers as numbers, a lift for each promotion against the four weeks before it, the extra sales totaled by category on a dashboard, and a short memo saying what to repeat and what to drop.

        • Data: 13 weeks of sales for 5 categories in 12 stores, and 8 promotions.
        • You deliver a clean promotion list, a lift table, a dashboard measure and a memo.
        • Checks cover the buy-one-get-one, the baseline window and the closed store.

        The project path

        1. 1
          Excel30 min

          Turn the offers into numbers

          Marketing typed the offers as text. Turn each one into a discount you can compare, including the buy-one-get-one.

          Reads
          promotions
          Produces
          promotions_clean

          SQL reads the clean promotion list.

          Open stageOne Course in Excel or All Access
        2. 2
          SQL45 min

          Measure each promotion

          Compare each promotion with its own category in the four weeks before it, per store-week.

          Reads
          promotions_clean · weekly_sales
          Produces
          promo_lift

          Power BI reads the lift table.

          Open stageOne Course in SQL or All Access
        3. 3
          Power BI40 min

          Total the extra sales

          Write the measure the category director will read every quarter, and show it by category.

          Reads
          promo_lift
          Produces

          Your memo cites the dashboard.

          Open stageOne Course in Power BI or All Access
        4. 4
          Readout25 min

          Write the memo

          Tell the category director which promotions to repeat and which to drop, with the numbers behind each call.

          Reads
          promo_lift
          Produces
          promotions_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.