Objectives

  • Identify where my products are referenced
  • Optimize assortment depending on the banner where the references are located

Key questions

  • How to determine distribution rate of my products within each banner (SM, AD, Proxy)?
  • In detail, where are my products findable?
Nice to know

Period

  • 1 month

Banner 

  • SM 
  • AD 
  • Proxy

Deliverable

  • Excel Pivot-Table with split per reference, per week, per store