2021: Week 45 - Spread the Knowledge for TC
Challenge by: Jenny Martin Tableau Conference 2021 is here and we thought we'd put together a challenge themed around Brain Dates to celebrate! The idea is, how many people will you indirectly gain knowledge from as you attend brain dates? The people you're meeting with will have been to other brain dates across the conference, so they will be able to share their key insights and the collective knowledge will grow with every brain date held! I had a lot of fun putting this challenge together, even needing pen and paper at times to work out the final output, so I hope you'll enjoy putting your Preppin' skills to the test with this challenge too. Inputs The brain dates for each day are spread across 3 excel sheets: There is also an Attendee ID Lookup table contained within this excel workbook: Requirements Input the Data Create a DateTime field for each Session Create a row for each Attendee and Join on the Lookup Table Create a Direct Contact Field for each Attend...