Project Details: Consider you are working as a Content Analyst in an ABC online multimedia company..

Project Details: Consider you are working as a Content Analyst in an ABC online multimedia company and your task for this analytical project is to use analytical tool (i.e. IBM Watson Analytics) to explore, analyse and visualize the given dataset. This dataset reflects details about different videos, uploaded during the period from 2006 to 2018. The original dataset is extracted from the and then modified and uploaded onto Your primary goal is to download the modified dataset and provide different and interesting insights in the lights of 20 guided questions listed below along with advance insights . The dataset could be downloaded from the following link

Dataset source:

Data Dictionary:

Video_id Unique identity of video

Trending_date trending date of video

Title Name of video

Channel_title Name of channel

Category_id : see category list below (table)

Publish_date The date on which the video was published

Time_frame The time at which the video was uploaded/published

Publish_day_of_week Day of the week video published

Publish_country Country in which video published

Tags Tags

Views Number of views of video

Likes Number of likes of video

Dislikes Number of dislikes of video

Comments_count Number of comment for a video

Comments_disable Whether comment is disable or not

Ratings_disabled Whether ratings is disabled or not

Video_error_or_removed Whether video has error or it is removed

YouTube Video Category Id list:

2 – Autos & Vehicles

1 – Film & Animation

10 – Music

15 – Pets & Animals

17 – Sports

18 – Short Movies

19 – Travel & Events

20 – Gaming

21 – Videoblogging

22 – People & Blogs

23 – Comedy

24 – Entertainment

41 – Thriller

42 – Shorts

43 – Shows

44 – Trailers

25 – News & Politics

26 – How to & Style

27 – Education

28 – Science & Technology

29 – Nonprofits & Activism

30 – Movies

31 – Anime/Animation

32 – Action/Adventure

33 – Classics

34 – Comedy

35 – Documentary

36 – Drama

37 – Family

38 – Foreign

39 – Horror

40 – Sci-Fi/Fantasy

You are expected to present the data findings in a visual forms (i.e., charts and graphs). This is a group assignment. You will complete it with your team (max 3 members enrolled in the same laboratory). It is expected that each team member will contribute equally in the project. Each team will turn in one joint document and give a joint presentation in Timetabled Laboratory class in Week 10. In addition, each individual team member will write a short reflection as part of the report. You will receive feedback on the draft about presentation choices, content, analysis, and style.

The Questions

Your job is to examine the dataset and present it in a set of informative graphs and text by answering the following questions.

Guided Questions for Dataset

1. What is the total number of uploaded videos in this dataset?

2. How many different types of uploaded categories are there?

3. What is the number of countries in this dataset?

4. What is the number of (unique) channels in this dataset?

5. Which are the top three countries, according to number of channels, in this dataset?

6. What is the lowest number of channel by country?

7. How many different unique channels are there in the US?

8. Provide a list of the top 10 viewed video titles with respect to each country.

9. Provide a list of least 10 viewed video titles with respect to each country.

10. How many years of uploaded videos are there in the data file?

11. How many uploaded videos have there been in the last month? (Select the last month of the year)

12. In which year, were the most videos uploaded in GB?

13. Which hour had the most uploaded videos in this dataset? Is there any differences between countries? (time_frame)

14. What are the top 3 viewed categories in terms of number of uploaded videos?

15. What are the least 3 viewed categories in terms of number of uploaded videos?

16. Which video has the highest percentage of likes?

17. Which video has the highest percentage of dislikes?

18. Which day has the highest uploads of videos?

19. Which day has least uploads of videos?

20. What is monthly breakdown of published videos?

Task 1- Background information

Write a description of the selected dataset and project, and its importance for the firm.

Information must be appropriately referenced.

Task 2 – Reporting / Dashboards

For your project, perform the relevant data analysis tasks by answering the above questions and, identify the visualization and dashboards you need to develop for the Content Manager of the indicated firm.

Task 3 – Advanced Insights: In addition to the guided questions, it is expected to provide at least five (5) insights of the data. These insights will be judged in terms of quality and complexity.

Task 4 – Research

Justify why these BI reporting solution/dashboards are chosen in Task 2 (Reporting / Dashboards) and why that dataset attributes are present and laid out in the fashion you proposed (feel free to include all other relevant justifications).

Note: To ensure that you discuss this task properly, you must include visual samples of the reports you produce (i.e. the screenshots of the BI report/dashboard must be presented and explained in the written report; use ‘Snipping tool’), and also include any assumptions that you may have made about the analysis in your Task2 (i.e. the report to the content manager of the company).

Task 5 – Recommendations for Content Manager

The Content Manager would like to improve the multimedia operations. Based on your BI analysis and the insights gained from the dataset in the lights of analysis performed in previous tasks, make some logical recommendations to the Content Manager, and justify why/how your proposal could enhance company’s multimedia operations and could assist in achieving operational/strategic objectives with the help of appropriate references from peer- reviewed sources.

Task 6 – Cover letter

Write a cover letter to the Content Manager with the important data insights and recommendation to achieve operational/strategic objectives

Task 7 – The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution.

"Get 15% discount on your first 3 orders with us"
Use the following coupon

Order Now