Preppin' Data

Challenge By: Jenny Martin What's one of the benefits of preparing your own data? Being able to start your analysis sooner! Sometimes I can find opening Tableau Desktop to explore my data gets a little distracting by trying to visualise it before I've decided on the story. Starting my analysis of the dataset in Tableau Prep helps me, personally, to stay more focused! It's clear where the outliers are, what the distribution of the dataset is and therefore what the story should be. For this week's challenge we're looking at a dataset that was used in December 2020 for Sports Viz Sunday  (thanks to Kate Brown for sharing!) This dataset comes from the PGA and LPGA  2019 Golf tours and lists the total prize money for the top 100 players. For those of us who aren't too familiar with golf, the PGA is the men's tour, whilst the LPGA is the women's tour. Input We have one input this week: Official Money Requirements Input the data Answer these questions: What...

Welcome back to the solution for week 6 of Preppin’ Data. Firstly, Carl and I would like to thank everyone for the free labour you have all given in helping run the Chin & Beard Suds Co business. It was much cheaper than finding and hiring an external data analyst. In terms of actually completing this challenge there were 3 main elements: Joining the " Soap Pricing Details " with the " England - Mar 2019 " data. Calculating the profit and aggregating it to the country and soap type level. Unioning the newly aggregated data to the " Company Data " table. At any point before, during, or after the previous elements, adding the date information for the new data. You can view our solution below and download it here . The full solution workflow. So let’s dive in. Joining the soap product information with the city sales data. No hidden tricks here, simply joining the product details table to the city sales data on [Category] = [Type of ...

For week 6 of 2019, Carl and I are going to get you playing with aggregation and, more importantly, introduce you all to our side hustle: Chin & Beard Suds Co – esteemed purveyor of (fake) luxury soap products. The Scenario: Chin & Beard Suds Co (C&BS Co.) is looking to update their company data table which details the monthly profit generated by each product in Scotland and England. This has already been done for the first three months of 2019 for Scotland, but the March sales information for England has yet to be aggregated and added to the master table. The March sales information for England is in its own table and contains how many units of each product type were sold in each city. The pricing and production costs for each product type are also contained in their own sheet. The Requirements: Import the file. Make sure to use all 3 sheets. Use the soap pricing details to calculate the profit in each city in England in March. Add the missing overa...