ITECH1103 Big Data And Analytics - Analysis of Uploads Assignment Solution

Task 1: Background Information

The ABC Online multimedia company came into form in 2015 and has been providing multimedia insights for its clients. In order to provide detailed insights and details about different videos, the total views, comments, likes and dislikes and time-frame of the uploaded videos during the period from 2006 to 2018. 

The dataset is provided to the content analyst by Kaggle and is gathered in the excel form. The dataset includes the information regarding video id, number of likes, number of dislikes, comments, publishing date, publishing day, video title, tags, channel titles, video errors and ratings. The dataset contains 161470 data points over 17 different columns. 

By providing access to such data, the mission of Content analyst at ABC Online Multimedia Company is to provide different analysis on the peak hours, peak days, most liked videos, most disliked videos and peak hours at which videos are uploaded. The aim of this report is to use analyze the given dataset by using analytical tool i.e. IBM Watson Analytics for exploring, analyzing and visualizing the given dataset. There are different questions that are explored along with advanced insights. The data is downloaded from data world and Kaggle.com. The major aim of this report are:

• To provide logical recommendations to the company for enhancing the multimedia operations
• Assisting the company in achieving its operational/strategic objectives
• Providing the company with advanced and basic insights into the data of uploaded videos

Task 2: Reporting/ Screen Shots of the Dashboard and Chats

There are total 55885 number of videos in the given data set with 18 different types of categories for 4 countries namely Canada, France, USA and Great Britain (GB). In the given data set, there are around 12360 number of unique channels. 

According to the given dataset, the Watson analytics showed that France is the top most country with 6678 numbers of channels followed by Canada (5076) and USA (2207) see figure 1 below.

Figure 1: Top 3 Countries in Terms of Channels

While the lowest number of channels are of Great Britain i.e. 1624 (see figure 2 below). In the given data set, USA has only 2207 number of channels. 

Figure 2: Lowest Number of Channels of Countries

The detailed observation showed the different titles of different countries. In the figures and tables below, top 10 most viewed video titles can be seen.  

Canada: