ITECH1103 Data Analytics: YouTube Video Analysis Report, Sem 3, 2018

This report presents a comprehensive data analysis of a YouTube dataset from 2006 to 2018, utilizing IBM Watson Analytics to uncover trends and insights related to video uploads, viewership, and user engagement across different countries (US, GB, France, and Canada). The analysis identifies popular video categories, channel performance, and factors influencing video likes and dislikes. Key findings include the identification of top-viewed videos, least-viewed videos, and the most and least active days for uploads. The report also provides recommendations for content managers to enhance video quality, encourage uploads, and minimize dislikes, ultimately aiming to improve user experience and viewership. The analysis highlights the importance of data analytics in understanding user behavior and optimizing content strategy on YouTube. This student-contributed assignment is available on Desklib, a platform offering a wide range of study resources for students.

Running head: DATA ANALYTICS
Title: Data Analytics
Name of the Student:
Name of the University:
Author Note:

1
DATA ANALYTICS
Table of Contents
Acknowledgement......................................................................................................................2
Introduction................................................................................................................................3
Reporting/Dashboards................................................................................................................3
Answer to question 1..............................................................................................................3
Answer to question 2..............................................................................................................4
Answer to question 3..............................................................................................................4
Answer to question 4..............................................................................................................5
Answer to question 5..............................................................................................................5
Answer to question 6..............................................................................................................6
Answer to question 7..............................................................................................................6
Answer to question 8..............................................................................................................7
Answer to question 9............................................................................................................10
Answer to question 10..........................................................................................................12
Answer to question 11..........................................................................................................13
Answer to question 12..........................................................................................................13
Answer to question 13..........................................................................................................14
Answer to question 14..........................................................................................................14
Answer to question 15..........................................................................................................14
Answer to question 16..........................................................................................................15
Answer to question 17..........................................................................................................15
Answer to question 18..........................................................................................................16

2
DATA ANALYTICS
Answer to question 19..........................................................................................................16
Answer to question 20..........................................................................................................17
Advanced Insights....................................................................................................................17
Insight 1................................................................................................................................17
Insight 2................................................................................................................................17
Insight 3................................................................................................................................18
Insight 4................................................................................................................................18
Insight 5................................................................................................................................19
Research...................................................................................................................................19
Recommendations for Content Manager.................................................................................21
Reflection.................................................................................................................................21
Conclusion................................................................................................................................22
Cover letter...............................................................................................................................23
Bibliography.............................................................................................................................25

3
DATA ANALYTICS
Acknowledgement
I would like to express my special thanks of gratitude to my teacher _____________ as well
as our principal _____________who gave me the golden opportunity to do this wonderful
project on the topic _____________which also helped me in doing a lot of Research and i
came to know about so many new things I am really thankful to them.
Secondly i would also like to thank my parents and friends who helped me a lot in finalizing
this project within the limited time frame.

4
DATA ANALYTICS
Introduction
The selected dataset Youtube.xlsx contains the information about different videos
uploaded in the period of 2006 to 2018. The data dictionary has the following columns
Video_id, Trending_date, Title, Channel_title, Category_id, Publish_date, Time_frame,
Publish_day_of_week, Publish_country, Tags, Views, Likes, Dislikes, Comments_count,
Comments_disable, Ratings_disabled, Video_error_or_removed. The description of each
columns are given in the question file.
The above dataset is much important to the ABC online multimedia company as
critical insights of the data can be developed and that can help the company to understand the
characteristics of individual customers and as well as help to segment the datasets in several
parts. Understanding the customer and after segmenting them in specific sections the ABC
multimedia can improve the user experience by showing the videos relevant to them and
those categories they like the most.
Reporting/Dashboards
Answer to question 1

5
DATA ANALYTICS
The total number of rows in the dataset is the total number of videos, which is
161470. However, the total number of distinct video present in the data are 55885.
Answer to question 2
There are 18 distinct categories in total in the dataset.
Answer to question 3
Unique countries are 4. Namely US, CANADA, FRANCE and Great Britain.

6
DATA ANALYTICS
Answer to question 4
Total number of unique channels are 12360.
Answer to question 5
The top three countries in terms of number of unique channels are CANADA,
FRANCE and US having total channels of 5076, 6679 and 2207 respectively.

7
DATA ANALYTICS
Answer to question 6
The number of channels in Great Britain is 1624 which is the lowest among the four
countries.
Answer to question 7
The number of unique channels in the US are 2207 channels.

8
DATA ANALYTICS
Answer to question 8
The top 10 viewed videos in CANADA are
1. Youtube rewind….
2. Marvel studios’ Avengers Infinity war…
3. BTS….
4. Childish Gambino….
5. Nicky Jam….
6. To our Daughter….
7. Venom….
8. Luis Fonsi, Demi Lovato….
9. Ozuna x Romeo….
10. Marvel Studios’Avengers…..

9
DATA ANALYTICS
The most viewed titles in France are
1. Youtube rewind
2. BTS
3. Nicky Jam
4. Childish Gambino
5. To our Daughter….
6. Luis Fonsi, Demi Lovato….
7. Ed sheeran- Perfect…
8. Brytiago X….
9. Marvel studios’ Avengers Infinity war…
10. Taylor swift end game….

10
DATA ANALYTICS
The most viewed titles in GB are
1. Nicky Jam…
2. Bad Bunny….
3. Childish Gambino
4. Te bote Remix…
5. Ozuna x Romeo..
6. Becky G, Natti….
7. Drake…
8. Luis Fonsi, Demi Lovato….
9. Youtube rewind
10. Ariana Grande…

11
DATA ANALYTICS
The most viewed titles in US are
1. Childish Gambino
2. Youtube rewind
3. BTS
4. Ariana Grande…
5. Marvel studios’ Avengers Infinity war…
6. Maulama….
7. Becky G, Natti….
8. Cardi B, Bad Bunny…
9. TWICE what is love…
10. Luis Fonsi, Demi Lovato….
Answer to question 9
US top 10 least viewed titles:
1. 1 dead, others…
2. Artwork Forge…
3. Coach Tagga…
4. Raw: 3 South…
5. Huffy Metaloi..
6. OjO Commute..
7. John legend…
8. Bannon Arrive..
9. UR EEOC…
10. OjO Commute..
France top 10 least viewed titles: