Answers to Questions 1 3 Answers to Questions 4 5 Answers to Questions 6 6 Answer to Questions 7 6 Answer to Questions 8 7 Answer to Question 13 13 Answer to Question 14 14 Answer to Question 15 14 An

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:

12
DATA ANALYTICS
1. Laurent Baffie..
2. Zemmour et…
3. France: famous..
4. L’histoire des…
5. Felvrier…
6. La chanson..
7. JO 2018…
8. MaAlys est…
9. Montpellier to..
10. Quand les…
GB top 10 least viewed titles:
1. Mountain bikes..
2. QUIZ : Name the…
3. George Dur…
4. 1080p WOLF…
5. Best bikes in…
6. New album Of..
7. Scarlets VS …
8. F&F Active..
9. Ia…
10. UK bike skills..
CANADA top 10 least viewed titles:

13
DATA ANALYTICS
1. Gala Artis…
2. Canadian…
3. Raptors post..
4. Simon oliver..
5. 018 Algebra…
6. Good vybz only…
7. RPA…
8. Maple Leafs…
9. Canucks For..
10. The best moment..
Answer to question 10
The videos are uploaded from year 2006 to year 2018 are 13.

14
DATA ANALYTICS
Answer to question 11
The last month is June 2018. In this month total 103 rows are there or this much
amount of videos were uploaded.
Answer to question 12
The most videos were uploaded in the year in which most number of rows are there.

15
DATA ANALYTICS
Answer to question 13
Answer to question 14
The countries retrieved from the dataset are CANADA, FRANCE, GB and US.
Answer to question 15

16
DATA ANALYTICS
The categories identified from the data set are: 22, 24 and 25.
Answer to question 16
The video id with the most likes have been identified above.
Answer to question 17
The video id with the highest number of dislikes have been identified above.

17
DATA ANALYTICS
Answer to question 18
The days with the highest uploads have been identified in this visualization from top
to bottom.
Answer to question 19
The days with the lowest uploads have been identified in this visualization from top to
bottom.

18
DATA ANALYTICS
Answer to question 20
The number of videos uploaded in each month has been displayed in this
visulaozation.
Advanced Insights
Insight 1
The insight on what drives the years have been displayed here.

19
DATA ANALYTICS
Insight 2
The counts of the number if comments by each country has been described here. This
describes the activeness of the people of the countries on YouTube.
Insight 3
The insight describes the top dislikes of the publish countries.
Insight 4
We further develop insight into the dislikes and the comments made by the people and
their relationships.

20
DATA ANALYTICS
Insight 5
We tried to find insight on the drive of dislikes but no such results were found from
the dataset and hence, more extensive research is required on this field.
Research
From the analysis it is found that, the dataset contains data only about 18 categories
which are listed below;
 1-Film & Animation
 10- Music
 29 – Non-profits & Activism

21
DATA ANALYTICS
 20 – Gaming
 22 - People & Blogs
 23 – Comedy
 43 - Shows
 44 - Trailers
 24 - Entertainment
 22 - People & Blogs
 23 – Comedy
 43 - Shows
 44 - Trailers
 15 - Pets & Animals
 17 – Sports
 25 - News & Politics
 19 - Travel & Events
 26 – How to & Style
 2 Autos & Vehicles
 27 - Education
 28 - Science & Technology
 30 – Movies

22
DATA ANALYTICS
There have been various Dashboards in the given data have been related to the You
tube videos that have been uploaded in the December. However, the lowest number of videos
in the channels of YouTube have been uploaded from the country GB. This may be a reason
behind the lesser number of views from that country when compared to three other countries
record available in the dataset.
Recommendations for Content Manager
The content manager would be advised to take the following recommendations into
considerations:
It has been suggested to the Content Manager to enhance the quality of the videos in t
he You tube. There have been various music videos uploaded in the min t h and gaining the
most viewed category in the YouTube. The quality of the music video might help in
increasing the viewers in the YouTube.
There has been slow growth in the video upload as compared to GB than US, France,
and Canada. Therefore, users need to be encouraged to upload their videos over the Youtube.
Dislikes for the videos should be minimized as it reduces the interest of the other
users therefore, it is suggested to check and remove the contents that can be disliked by the
audience.
Reflection
We found that there have been examination of the Watson analytics tool of dataset. It
can found that with the utilization of the beginning stages it winds up less demanding to
discover the bits of knowledge. It has been analysed that the use of Watson analytics has been
creating some With all the previously mentioned advantages there are a few drawbacks in this
AI based NLP and data analysis tool. Watson Analytics has been equipped in order to join

23
DATA ANALYTICS
several datasets related to other same attributes. There have been more than single dataset
that have not been blended and used in the investigation regardless of whether data can be
recorded into typical segment in same name. The use of Watson helps in setting up number of
mathematic tasks on data collection from the stages. IBM Watson Analytics have been
helping in gaining information about the techniques that might be helping in imagining keen
approach in the dataset analytics. The use of the dataset has ben helping in maintaining keen
analysis using Watson Analytics with several patterns.
Conclusion
For conclusion it can be said that data analytics is very important for any type of
business and the report consists the details of the Youtude dataset. The analysis has tried to
gather information about the current trends in the YouTube videos and the uploads which are
made in YouTube for the entertainment of the audience. Visualizations an graphs from
datasets have been provided from IBM Watson for the reference of the readers.

24
DATA ANALYTICS
Cover letter
To
The Content Manager
ABC online Multimedia Company
Respected Sir,
I am writing this letter in order to the results of the analysis for the
provided dataset on the YouTube dataset that contained details about different videos,
uploaded during the period from 2006 to 2018 and their viewership by the audience in four
countries US, GB, FRANCE and CANADA.
It can be analysed in the report that significant spike of viewership and channels in the GB.
The total number of views have been anakysed and category of the videos achieving more
viewers have been analysed. The use of the YouTube channel have been helping in gaining
more information about the channels. The use of the dataset has been helping in providing a
keen approach to the analysis of the YouTube channel.
In further analysis, it is also found that, most liked video was “Childish Gambino - This Is
America (Official Video) among all the entries in the dataset. Whereas the “So sorry” titled
video was the most disliked video.
Therefore, it is suggested to improve the contents as well as channels in GB in order to
improve the viewership in that country. In addition to that, the quality of other contents
related to different other categories should be improved in order to attract larger number of
viewers in the selected countries as available in the dataset. The above recommendations as
well as insights can help the organization to improve its business through the larger number
of acquired viewers on the platform.

25
DATA ANALYTICS
Thanking You,
[Fill your name]

26
DATA ANALYTICS
Bibliography
Agresti, A. (2018). An introduction to categorical data analysis. Wiley.
Ott, R. L., & Longnecker, M. T. (2015). An introduction to statistical methods and data
analysis. Nelson Education.
Schabenberger, O., & Gotway, C. A. (2017). Statistical methods for spatial data analysis.
CRC press.
Silverman, B. W. (2018). Density estimation for statistics and data analysis. Routledge.
Wickham, H. (2016). ggplot2: elegant graphics for data analysis. Springer.
Yan, C. G., Wang, X. D., Zuo, X. N., & Zang, Y. F. (2016). DPABI: data processing &
analysis for (resting-state) brain imaging. Neuroinformatics, 14(3), 339-351.