This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackHopefully 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
2 questions on the provided solution (from @TaraM / @GeneR)
- 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 🙂
Yes, I think "hacky" was the best description for my solution 🙂
My (verrrry long) solution... this one was brutal for me... ouch. 🙂
But you got there. The beauty of Alteryx in action, get the answer in the most roundabout way, then work backwards to clean up your processes for speed.
It means everyone can get there eventually.
More ETL fun?