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

Sales behaviour — Adventure Works

Quarterly trend, brands, regions, stores and key customers

Problem

Summarise commercial performance to guide loyalty and expansion decisions.

Data

Adventure Works sales data 1997–1998 (sales and margin by brand, region, store and customer).

Methods

  • Quarterly sales and margin trend
  • Rankings with brand, region and store filters
  • Region × brand matrix

Results

  • Sales of 326.38K in Q4 1998, the highest quarter of the period.
  • North West concentrates sales (847.8K) vs 330.4K for Mexico Central.
  • Hermanos and Tell Tale lead sales and margin by brand.

Tools

Looker Studio

University work; no claim of sole individual authorship.