Preppin' Data

Challenge by: Will Sutton We're starting June with a collaboration with #GamesNightViz and  #DataFamCon : a monthly challenge with topics covering a wide range of the geeky world including TV Series, films, books, and even some data about geek culture and conventions itself.  For this challenge, we'll be looking at a Dungeons and Dragons dataset from the podcast "Critical Role". If we wanted to know how long each character speaks for during each episode we'd need to do a little bit of preppin' to prepare the dataset for such an analysis.  There's an additional bonus challenge to build the following dashboard using the data we'll prep. Find the details at the bottom of this post! Find the viz designed by the super talented Christina Gorga here Inputs Episode Details  Dialogue  Requirements Input the data To create our gantt chart we'll need to work out how long each character is talking. To do this we can work out the difference from one timestamp ...

 Challenge By: Will Sutton Did you see the launch of #GamesNightViz a couple of weeks ago? It's a new community project which gives you the opportunity to practise your data visualisation, design and preparation skills. So we've decided to team up this week to bring you a #GamesNightViz style Preppin' challenge!  This week's challenge is about building new dimensions from #GamesNightViz's Top Female Poker Players data to better understand their successes across their poker careers. They've earned millions of dollars but was it all in one go? How many years have they been playing poker? How regularly do they win?  The resulting dataset will allow you to build a pizza plot/coxcomb chart like below, which you're welcome to do as a bonus challenge too! Inputs Top 100 Female Poker Players  Top 100 Poker Events  Requirements Input the Data Add the player names to their poker events Create a column to count when the player finished 1st in an event Replace any nul...

 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...

 Challenge by: Beth Kairys A couple of weeks ago, at the Tableau Prep User Group, co-leader Beth Kairys presented a brilliant workflow which covers a lot of the fundamentals of data prep. Luckily, she agreed to allow us to turn it into a Preppin' Data challenge, thanks Beth! If you missed the session or want a sneaky peak at the solution, then click here to watch the user group recording. The purpose of the challenge is to get our cases data into a format where we can reproduce the following chart (which you're welcome to do as a bonus exercise too!) Inputs There are 3 inputs for this challenge: Business Unit A cases  Business Unit B cases  Risk Level lookup table  Requirements Input the data From the Business Unit A Input, create a Date Lodged field Use the lookup table to update the risk rating Bring Business Unit A & B together We want to classify each case in relation to the beginning of the quarter (01/10/21): Opening cases = if the case was lodged before...