Challenge 4 - Cleaning product (data)
Want to test your Aperture Data Studio skills a little more? This next challenge requires you to analyse the situation, compare the starting point to the destination state and figure out what functionality needs to be applied to navigate the journey.
The sample data for this challenge is some messy product data:
As you can see these values are largely related to the same sorts of things but represented in very differently. Your challenge (should you choose to accept it) is to tidy this up so that the distinct list of values you get is simply as follows:
There are multiple ways of solving this challenge so do please share your approach in the Challenge 4 Solutions thread.
Top tip, don’t just dive straight in. Step back, analyse the situation, make a plan and then see what you can do 😊