Preppin' Data

Challenge by: Jenny Martin It was the final of this year's series of Strictly Come Dancing at the weekend, which made me have a few more questions I'd like to answer using the dataset we used in a challenge a few week's back . If you've yet to catch up on this year's final, don't worry this data doesn't include results from this year.  As I watched the final this year I found myself wondering, is it the contestant that makes the biggest improvement that is most likely to win? Or is it the contestant that has been consistently good since week one? Let's work out the percentage improvement of the finalists from week 1 in order to answer this question! One additional question, does getting perfect scores in the final guarantee you'll win?  Input  The input is the same as challenge 42. If you recall this data was webscraped and so it does require a little cleaning before we can start answering the questions.  Requirements Input the data The webscraping i...

 Challenge by: Thomas Duong Thomas has just finished his training at the Data School and has created a Preppin' Data challenge to celebrate! Over to Thomas to explain the challenge:

Created by: Carl Allchin When watching basketball this weekend, I suddenly started to wonder what is the lowest number that isn't found on any NBA players jersey? Well there's only one way to work that out… data! But there are other questions that started flowing too: What's the average salary per 10 centimetres grown? (how much should my parents incentivised me to eat more broccoli?) What's the tallest team in the NBA? And who's the shortest team?  Do taller players wear larger numbers? Just like Week 4 2019 challenge, data preparation tools can often allow us to get to the answers we need. Can you find the answers too? Input There's one Excel workbook with 30 individual worksheets: Requirements  Input the data Combine all 30 worksheets together Answer the following questions through creating separate flows: What's the lowest number not used on a jersey in the NBA? What's the average salary per 10cm of height?  What's the shortest average height te...