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.
Ok, quick and dirty (hold your comments, please).
:-) I went the longest way round possible
- it seems like there's a first row of ratings data which this solution misses. Both @mceleavey and I have hacked around this by starting to count the ratings data from 0 instead of 1
- one field is called "P25_34Consume" instead of "P25_54Consume"
I've attached my super-awkward, super-long-way-round solution :-)