ITECH1103 Big Data Analytics: YouTube Trend Analysis Report 2018

This report presents an analysis of a YouTube dataset using IBM Watson Analytics, focusing on video trends, viewership patterns, and factors influencing likes and dislikes. The dataset includes information on videos from the USA, UK, Canada, and France. Key findings include the most viewed video categories, the impact of video tags on dislikes, and trends in video uploads across different countries. The analysis recommends strategies for the ABC online multimedia company to improve viewership and engagement, particularly in countries with lower channel counts, and to avoid content associated with negative feedback. The report also reflects on the strengths and limitations of using IBM Watson Analytics for data analysis.

Running head: ITECH1103- BIG DATA AND ANALYTICS
ITECH1103- Big Data and Analytics
Name of the Student
Name of the University
Authors note

1ITECH1103- BIG DATA AND ANALYTICS
Background information
For the ABC online multimedia company, this project is aimed to find out the
different insights from the dataset which is collected form the following URL;
https://data.world/iamdilan/youtube-dataset
The dataset contains total 161,470 rows, 17 columns. The rows contains data about the
videos different attribute on the YouTube such as video_id, trending date, title of the video
channel title that uploaded the video , a specific category_id of the video, publish date of the
video, time_frame for the uploaded video, publication day week for the video, publish
country for a specific video , tags used for the video, views, likes, dislikes, count of the
counts for videos, whether the comments or ratings are disabled for the video and finally
information about whether there us any video error or removed from the site. From the
analysis it is found that, in the dataset, it contains the detailed data about the viewership of
the audience in the countries USA, UK (used country code GB), Canada and France.
The following report contributes to the interpretation of the different dashboards that are
created using the IBM Watson Analytics tool, five advanced insights, justification about the
use of the Watson analytics tool and Recommendation for the ABC online multimedia
company.
Reporting / Dashboards
Answer 1
The total number of uploaded videos is 161470.

2ITECH1103- BIG DATA AND ANALYTICS
Answer 2
The dataset contains total 18 categories of videos uploaded in the dataset for the
given time period which are;
1: Film & Animation
2: Autos & Vehicles
10: Music
15 - Pets & Animals
17 – Sports
22 - People & Blogs
23 – Comedy
20 – Gaming
24 - Entertainment
43 - Shows
44 - Trailers
25 - News & Politics
19 - Travel & Events
26 – How to & Style
27 - Education
28 - Science & Technology
29 – Non-profits & Activism
30 – Movies

3ITECH1103- BIG DATA AND ANALYTICS
Answer 3
There are total 4 countries in the dataset.
Answer 4
There are total 12360 unique channels in the dataset.

4ITECH1103- BIG DATA AND ANALYTICS
Answer 5
The top three countries are France, Canada and US according the distinct number of
channels.
Answer 6
The country with the least number of channels on YouTube from the dataset is GB.

5ITECH1103- BIG DATA AND ANALYTICS
Answer 7
There are total 2207 unique YouTube channels in US.
Answer 8
Following is the list dashboard that depicts the top 10 viewed videos for the
Countries US, GB, CANADA and France.

6ITECH1103- BIG DATA AND ANALYTICS
From the above dash board, it can be stated that, there are similar 10 videos that
ranked between the top 10 videos, the list of videos is;
Nicky Jam x J. Balvin - X (EQUIS) | Video Oficial
Bad Bunny - Amorfoda | Video Oficial
Te Bote Remix - Casper, Nio GarcÃa, Darell, Nicky Jam, Bad Bunny, Ozuna | Video Oficial
Ozuna x Romeo Santos - El Farsante Remix
Childish Gambino - This Is America (Official Video)
Drake - God's Plan (Official Music Video)
YouTube Rewind: The Shape of 2017 | #YouTubeRewind
Ozuna - UÌnica (Video Oficial) 🻠A U R A
Ariana Grande - No Tears Left To Cry (Live On The Tonight Show Starring Jimmy Fallon)
Becky G, Natti Natasha - Sin Pijama (Official Video)
Answer 9

7ITECH1103- BIG DATA AND ANALYTICS
following is the list of bottom 10 videos for the countries;
the list contains the following
Famous Dimbler,JO2018, Moring live and others.
Answer 10
The data set contains data about the uploaded video for 13 years.

8ITECH1103- BIG DATA AND ANALYTICS
Answer 11
For the last month December, the number of the uploaded videos is given by 8525.
Answer 12
For the country GB, the maximum amount of video is uploaded in the year 2018.

9ITECH1103- BIG DATA AND ANALYTICS
Answer 13
The time frame in which the maximum number of videos are uploaded is 16:00 to
16:59.
Answer 14
The top 3 viewed categories in terms of number of uploaded videos is given by 10, 1, 29.
Answer 15
Least three video categories in terms of uploaded videos are 44,25,27.

10ITECH1103- BIG DATA AND ANALYTICS
Answer 16
Videos that has highest percentage of likes is given by Childish Gambino - This Is America
(Official Video)
Answer 17
Videos that has highest percentage of dislikes is given for the video title “So Sorry.”

11ITECH1103- BIG DATA AND ANALYTICS
Answer 18
Friday has the maximum number of uploaded videos.
Answer 19
The least number of videos are uploaded on Saturday.