← Back
University courseworkData Science Specialisation & IT Management Master's — Universidad Rafael LandívarGroup project

Executive sales summary — RetailCo

Year-over-year growth by segment, category and region with a year selector

Problem

Give management an executive view of sales growth versus the previous year.

Data

4 years of sales history by segment, category, region and state.

Methods

  • Cumulative sales KPI
  • YoY growth computed automatically for the selected year
  • Monthly current vs previous year with trend line
  • Bubble map by state

Results

  • Cumulative sales for the analysed year (2018): 722.1K.
  • YoY growth by segment: Home Office 51.24%, Corporate 15.16%, Consumer 12.87%.
  • YoY growth by category: Office Supplies 31.77%, Technology 21.36%, Furniture 8.43%.
  • Year selector: charts compute the previous year automatically.

Tools

Looker Studio

University work; no claim of sole individual authorship.