2019: Week 43

This week's challenge sees the start of our stores' end of year appraisals. This year, we want to give the stores encouragement to start determining their own plans for next year. Can this be automated based on their current sales and targets? We thought you'd like to give our crazy idea a go!

Requirements


  • Input the data
  • Remove any non-store sales data
  • Form a date to help with your quarterly calculations
  • Determine Store Quarterly Sales
  • Join on Store Quarterly Targets
  • Determine Store variance to Target - actual as well as percentage difference
  • Match Action Description to Variance %
  • Output the data

Output


1 File:
40 Rows (41 including Headers)
9 Columns:
  • Store
  • Variance to Target
  • Variance to Target %
  • Sales
  • Target Value
  • Quarter
  • Region
  • Target
  • Actions

The outputs can be found here for comparison. Don’t forget to fill the participation tracker and share your solutions using #PreppinData on Twitter.

Popular posts from this blog

2023: Week 1 The Data Source Bank

2023: Week 2 - International Bank Account Numbers

How to...Handle Free Text