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
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
- 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!
