2022: Week 29 C&BSco Meeting Targets?

 Challenge by: Carl Allchin 

This week's challenge is a continuation of another introductory month for newer Preppers. 

When you work with data, you are likely to increasingly ask more and more questions as you find out new insights. These additional questions often means you need to combine data sets together. This uses a technique called Joins. For this week's challenge, you might want to use the supporting links if you haven't joined data sets together before. 

If you are newer to preparing data then you might want to use the following links to learn these techniques:

Input

1. The same input as Week 27 & 28

2. Targets (k's)

Requirements

  • Input both data sets
  • Remove unnecessary values from the Product Name field to just leave the Product Type
  • Total Sales for each Store and Product Type
  • Change the Targets data set into three columns
    • Product
    • Store
    • Sales Target (k's)
  • Multiple the Sales Target (k's) by 1000 to create the full sales target number (i.e. 75 becomes 75000)
  • Prepare your data sets for joining together by choosing your next step:
    • Easy - make your Sales input Product Type and Store name UPPER CASE
    • Hard - make your Targets' Store and Product fields TitleCase
  • Join the data sets together and remove any duplicated fields
  • Calculate whether each product in each store beats the target
  • Output the results

Output


6 data fields:
  • Beats Target?
  • Target
  • Store Name
  • Region
  • Sales Value
  • Product 
12 rows (13 rows incl. headers)

You can download the full output here

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