Preppin' Data

Challenge by: Jenny Martin We're getting spooky this week, not only with Halloween data, but also with another click-only challenge! That's right, typed calculations are absolutely forbidden. We've got sales data from a company selling Halloween costumes around the world, but it certainly needs a little tidying up. With their fiscal year coming to an end on Halloween itself, they want to see how their sales are comparing to last year's. Let's hope the results aren't too scary! Input There is one input this week, containing Halloween costume sales from different countries:  Requirements Remember this is a click-only challenge, no typed calculations allowed! (Although you may rename fields, we're not that harsh)  Input the data. Each costume is in the language of the country the sales occur in. Group these costumes together by their English translation. You should have 9 costumes once you've finished grouping There have been some errors when inputting cou...

Time's are tough at the moment and Netflix usage is high. We've all got that fear as we come to the end of a series we've been binging - what should I watch next?! So we decided to make this week's challenge all about helping to answer this question. We took a survey of colleagues to find out what they've been watching, what devices they've been using and how they would rate these shows. Unfortunately, the survey was thrown together rather hastily and there's definitely some clean up to be done!   As an extra challenge, typed calculations are forbidden!  That's right, we've got another CLICK ONLY challenge for you to really showcase the power of Tableau Prep. Remember to keep an eye on the recommendations and you are allowed to rename things. Check out this post of all the other click only challenges for inspiration if you're getting stuck! Inputs There are 3 inputs this week: Netflix Survey Results List of all content on U...

One of the great things about Tableau Prep is that much of the functionality can be achieved through clicks of your mouse, rather than having to write complex calculations. This makes it a great tool for those just starting their journey in data preparation. Preppin' Data has made an effort to showcase this amazing functionality by creating the below challenges. As well as the usual requirements, you are also forbidden from using calculated fields. Make sure you have a go and see how rewarding self service data prep can be, before diving into the video solutions. Preppin' Data 2019: Week 26 - Clean Cocktail Data with only Clicks This challenge starts with a cocktail menu. We split out the ingredients list and reshape the data so that each ingredient has its own line. Then we work out the average price of a cocktail containing that ingredient. Finally, we join it back to the cocktail menu data to find out which cocktails containing your favourite ingredient offer the be...