Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Hi Maveryx!
A solution to last week’s challenge can be found here.
Don't forget that we are running a campaign inviting all of you to contribute to our upcoming 2024 Weekly 
Now that winter is here, excitement is high among curling, skiing, snowboarding, and all winter sports enthusiasts! Special thanks to Nolan Gaskill (@Nolan) for contributing the idea for this challenge.
As the regional manager of a sports retail chain, your challenge is to manage the winter sports inventory, ensuring maximum sales and minimal spoilage. This decision-making process will be powered by—you guessed it—an insightful analysis of historical sales data using Alteryx Designer.
A dataset containing details of your store’s inventory, sales, and spoilage rates has been provided. It requires some preliminary cleaning to ensure accuracy in your analysis, allowing you to dive in and extract valuable insights.
Your tasks are:
- Spoilage Scrutiny: Discover the five products with the highest spoilage rate. These are items that are not selling as expected and are incurring losses.
- Sales Efficiency Evaluation: Determine the five products with the lowest sales per unit produced.
If you find yourself struggling with any of the tasks, feel free to explore these interactive lessons in Maveryx Academy for guidance:
Good luck!
Note: The Top Solvers and Top Challenges sections will be removed from the Weekly Challenge index pages at the end of January. But don't fear, these stats aren't going away! Top Solvers and Challengers will be recognized quarterly in our Top Contributors blog.
People have cleaned the data in so many different ways. I'll be using some of them in the future.
In hindsight, transpose, cross-tab, and regex tools were unnecessarily complicated. Multi-row was the way to go.
It's a solution, but definitely NOT recommended.