Hopefully everyone had fun with the Grand Prix challenges and a few of you are ready to jump in the ring next year for the 2017 Grand Prix at Inspire in Las Vegas. The solution for the final lap (challenge #32) is HERE.
Let’s dial it back this week and look another real world example of using Alteryx to reshape data into a usable format for analysis.
Use Case: A radio station is trying to analyze data they receive from Nielsen disclosing the number of listeners the station has on a weekly basis by program. The challenge is that the data is formatted in a way that makes it challenging to use for analytics.
Objective: Reshape the data detailing the listening stats for the 30 programs listed in the data.