2023: Week 18 - The Nut House Revenue Analysis

Challenge by: DS39

After just 1 day with Tableau Prep, Data School Cohort number 39 were tasked with creating some training content on the following steps:

  • Input
  • Clean
  • Pivot 
  • Aggregate
  • Output
They went above and beyond to create a challenge for Preppin' Data that used each of these steps! What's more, they even created their own company: The Nut House! Let's tidy up the data so we can see the Total Revenue for each Location.

Input

A single input this week:

Requirements

  • Input the data
  • Clean up the location names
  • Reshape so that we have a field for each measure
  • Calculate the Revenue 
    • Price * Quantity
  • Aggregate the data so we can perform our analysis at the Location level. We want to see the:
    • Total Revenue
    • Avg. Price per pack (rounded to 2 decimal places)
  • Output the data

Output

  • 3 fields
    • Location
    • Revenue
    • Avg. Price (£) per pack
  • 3 rows
After you finish the challenge make sure to fill in the participation tracker, then share your solution on Twitter using #PreppinData and tagging @Datajedininja@JennyMartinDS14 & @TomProwse1

You can also post your solution on the Tableau Forum where we have a Preppin' Data community page. Post your solutions and ask questions if you need any help! 

Popular posts from this blog

2024: Week 1 - Prep Air's Flow Card

2023: Week 1 The Data Source Bank

How to...Handle Free Text