2022: Week 11 - The Prep School - Filling the Blanks

 Challenge by: Carl Allchin

Dealing with gaps in data sets is something any data prepper will have to deal with frequently. At the Prep School, some of our attendance recording isn't filled in well. 

Each lesson is taught at the same time, on the same day. 

Input


Requirements

Output


8 Fields
  • Weekday
  • Week
  • Teacher
  • Lesson Time
  • Lesson Name
  • Subject
  • Attendance 
  • Avg. Attendance per Subject & Lesson

40 rows (41 incl. headers)

You can download the full output here

After you finish the challenge make sure to fill in the participation tracker, then share your solution on Twitter using #PreppinData and tagging @Datajedininja@JennyMartinDS14 & @TomProwse1

You can also post your solution on the Tableau Forum where we have a Preppin' Data community page. Post your solutions and ask questions if you need any help! 

Popular posts from this blog

2023: Week 1 The Data Source Bank

2023: Week 2 - International Bank Account Numbers

How to...Handle Free Text