Yes, it’s the second day of dashboard week! Today we are given data about Trending videos on Youtube. The data was quite clean so the Alteryx workflow is simple, as shown below:

I used a wildcard to input all the datasets and output filename so that I could get the country for that video. Then I used Text-to-column to get the published time and trending time. Finally, I output the data as a hyper file.

In Tableau, I built a bar chart to show the view counts and the number of trending days of each video. And I applied Map to show the trending days in each country.

 

Camille Shi
Author: Camille Shi