Write a data analytical report to provide useful insights

Assignment Help Other Subject
Reference no: EM132218736

Assignment -

Analytic Report:

Learning Outcomes Assessed: A3, K3, K6, and S2:

Purpose: The purpose of this task is to provide students with practical experience in working in teams to write a Data Analytical report to provide useful insights, pattern and trends in the chosen/given dataset. This activity will give students the opportunity to show innovation and creativity in applying Watson Analytics and designing useful visualization solutions and predictive solutions for various analytics problems.

Group Presentation: Week 10 (Scheduled Laboratory) Learning Outcomes Assessed: K4, A1, A2, V1, V2
Purpose: The purpose of the oral presentation is to provide an opportunity for students to present the results of DATA Analysis and to share this knowledge while practicing their verbal communication skills

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. 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.

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. [1 Page]

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. [2-3 Pages]

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). [1-2 Pages]

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. [1-2 Pages]

Task 6 - Cover letter
Write a cover letter to the Content Manager with the important data insights and recommendation to achieve operational/strategic objectives [1 page]

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

Other Tasks -
Please refer to marking scheme at the end of the assignment for other tasks and expectations.

Attachment:- Analytic Group Assignment.rar

Verified Expert

In descriptive statistics, summary statistics are used to summarize a set of observations, in order to communicate the largest amount of information as simply as possible. Statisticians commonly try to describe the observations in a measure of location, or central tendency, such as the arithmetic mean.

Reference no: EM132218736

Questions Cloud

Describe how falling barriers to trade and investment : Discuss the major points of the inequality between nations argument and describe how falling barriers to trade and investment might help reduce this inequality
Define computer security : Define computer security and explain the difference between passive and active security threat. Provide examples to support your response.
Explore your systems vulnerabilities : Explore your system's vulnerabilities,and address the nature of potential internal and external threats and natural or unintended events that may jeopardize it.
How could the shortcoming have been prevented : Using a Web browser and a search engine,search the terms "Citibank backup tapes lost" you will find many results.
Write a data analytical report to provide useful insights : ITECH1103- Big Data and Analytics Group - Write a description of the selected dataset and project, and its importance for the firm.
Discuss the systems integration solutions at ups : Discuss the systems integration solutions at UPS. How does it help UPS integrate new technologies?
Determine what research design was used : To narrow/broaden your search, remove the words qualitative and quantitative and include words that narrow or broaden your main topic.
How a phased implementation might allow the organization : Discuss how a phased implementation might allow the organization to focus on a critical area, stabilize the system, and make adjustments.
Discuss the use of epidemiology in disease prevention : Define epidemiology and describe the epidemiological triangle and other epidemiology tools in disease control and prevention. Discuss the use of epidemiology.

Reviews

len2218736

1/19/2019 1:50:03 AM

7- Cover letter (Format, key findings and recommendation ) [1+1+3] 5 8- Other Tasks Report is well-written and presented professionally, containing: • Title page • Table of Contents • Introduction • Appropriate use of headings within report • Appropriate use of figures (i.e. graphs, summary tables) and reference to calculations and summaries to justify all observations and recommendations • Overall structure, presentation and formatting. Note that the report has to be presented formally. It must include discussion of calculations, observations and recommendations with graphs and/or tables. 1 1 2 1 1 2 2 Total Marks 100 Total Marks out of 20 20%

len2218736

1/19/2019 1:49:53 AM

5- Recommendations - The Content Manager would like to improve the advertising operations. Based on your BI analysis and the insights gained from 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 assist in achieving operational/strategic objectives. 15 6- The Reflection: Each Team member is expected to write a brief reflection about this project in terms of challenges, learning and contribution. 10

len2218736

1/19/2019 1:49:46 AM

3- Advanced Work: The quality and complexity of additional five (5) insights provided other than the guided questions. 10 4- Research - Justify why these BI reporting solution/dashboards are chosen and why those 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 assignment report (i.e. the report to the operational team of the company). [Each analysis/dashboard and report explanation with relevant research papers, complexity and in- depth of the justification, use of peer-reviewed sources] 15

len2218736

1/19/2019 1:49:40 AM

Tasks Max Marks 1- Background of the Project: Description of Project, Datasets and firm. The important of project for the firm [1+1+1+2] 5 2- Dashboard/Reports What are the BI reporting solution/dashboards you will need to develop for Content Manager of chosen in the light of Questions of your Data analysis - [Quality and complexity of the analysis – 30

len2218736

1/19/2019 1:49:33 AM

• Reports are to be presented in hard copy in size 12 Arial Font and double spaced. Your report should include a list of references used in the essay and a bibliography of the wider reading you have done to familiarize yourself on the topic. • A passing grade will be awarded to assignments adequately addressing all assessment criteria. Higher grades require better quality and more effort. For example, a minimum is set on the wider reading required. A student reading vastly more than this minimum will be better prepared to discuss the issues in depth and consequently their report is likely to be of a higher quality. So before submitting, please read through the assessment criteria very carefully.

len2218736

1/19/2019 1:49:24 AM

• Hard-copy to tutors/lecturers assignment box in week 10. Double- sided printing for the hard-copy is encouraged in order to save paper. • You will also submit a 7-8 pages report (about 1500 words not counting cover page and references) of this project. At least 15 references in your report must be from peer-reviewed sources. Include any and all sources of information including any person(s) you interviewed for this project.

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd