Today is the last day of Dashboard Week and its been my favorite!
Our task for today was to analyze the Boys Band dataset from Github. I did the prep in Alteryx and it was very simple: just joining the two tables Boys and Bands. When I was exploring the data I saw a link to the YouTube video and decided to create an additional dataset to use. (I did it manually,I thought I would be quicker, but it took me a while.) This is my final flow adding the extra table:
![](https://www.thedataschool.co.uk/content/images/2021/03/image-149.png)
![](https://www.thedataschool.co.uk/content/images/2021/03/image-148.png)
This dataset contains for each song, the total # of views in YouTube and the date the video was published on YT, so I could calculate how many months a video had been on YT:
![](https://www.thedataschool.co.uk/content/images/2021/03/image-161.png)
I create a table with the months on Youtube, the total views, and created a calculated field to get the AVG views by month.
![](https://www.thedataschool.co.uk/content/images/2021/03/image-162.png)
I created a set for the top 20 bands by avg monthly views on Youtube:
![](https://www.thedataschool.co.uk/content/images/2021/03/image-163.png)
And a second set containing Bands that have achieved the top 3
![](https://www.thedataschool.co.uk/content/images/2021/03/image-153.png)
By right clicking on one of the sets and choosing the create combined set option I created a new set for the shared members in the previous one.
![](https://www.thedataschool.co.uk/content/images/2021/03/image-157.png)
My aim was to compare the ranking in youtube and the ranking based on the position on the US version of the Billboard Hot 100
![](https://www.thedataschool.co.uk/content/images/2021/03/image-158.png)
It is possible to see in the top right corner that members from the combined set.
I created some charts to use as BAN at the top of the dashboard
![](https://www.thedataschool.co.uk/content/images/2021/03/image-167.png)
Using the Date they got in the Billboard Hot 100 I analysed on the one hand the number of songs by year and on the other hand by month
![](https://www.thedataschool.co.uk/content/images/2021/03/image-159.png)
This is my final dashboard:
![](https://www.thedataschool.co.uk/content/images/2021/03/BOY-BAND-DASHB.png)