2019: Week 44
Last week's challenge, Chin & Beard Suds Co. looked at Store Performance for the end of year appraisals. This week we are looking at our staff members.
Chin & Beard Suds Co. wants to understand how much our team are selling each day but we don't capture team member level sales at the moment. We would like to reward our top three sellers in each store but who are they?
Requirements
Team Member Days
Store Sales
- Input Data
- Determine how many staff work in each store each day
- Join Store Sales and Team Member Days
- Estimate the Staff Sales per Day based on the Store Sales divided by the number of staff who worked that day
- Determine the team member's rank within their store
- Number 1 is the highest estimated average Estimated Sales per Day
- Output the data
Output
One File:
- 4 Columns:
- Store
- Team Member
- Rank
- Estimated Sales From Staff Member (avg per day)
- 13 Rows of Data (14 Rows including headers)
The outputs can be found here for comparison. Don’t forget to fill the participation tracker and share your solutions using #PreppinData on Twitter.
