ITECH1103- Big Data and Analytics Group

FIND A SOLUTION AT Academic Writers Bay

1 | P a g eITECH1103- Big Data and Analytics GroupAssignment – Semester 3, 2018Worth – 30%ANALYTIC REPORT (20%- Due Week 11 Sunday11:55pm) and PRESENTATION (10% – Due Week10 in Tutorial Time)Analytic Report:Learning Outcomes Assessed: A3, K3, K6, and S2:Purpose: The purpose of this task is to provide students with practical experience inworking in teams to write a Data Analytical report to provide useful insights, pattern andtrends in the chosen/given dataset. This activity will give students the opportunity toshow innovation and creativity in applying Watson Analytics and designing usefulvisualization solutions and predictive solutions for various analytics problems.Group Presentation: Week 10 (Scheduled Laboratory) Learning OutcomesAssessed: K4, A1, A2, V1, V2Purpose: The purpose of the oral presentation is to provide an opportunity for studentsto present the results of DATA Analysis and to share this knowledge while practicingtheir verbal communication skillsProject Details: Consider you are working as a Content Analyst in an ABC onlinemultimedia 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 datasetreflects details about different videos, uploaded during the period from 2006 to 2018.The original dataset is extracted from the and then modified and uploadedonto Your primary goal is todownload the modified dataset and provide different and interesting insights in thelights of 20 guided questions listed below along with advance insights . The dataset couldbe downloaded from the following linkDataset source: Dictionary:
Video_idTrending_dateTitleChannel_titleCategory_id :Publish_dateTime_framePublish_day_of_weekPublish_countryTags
Unique identity of videotrending date of videoName of videoName of channelsee category list below (table)The date on which the video was publishedThe time at which the video was uploaded/publishedDay of the week video publishedCountry in which video publishedTags
2 | P a g e
Number of views of video
Number of likes of video
Number of dislikes of videoNumber of comment for a videoWhether comment is disable or notWhether ratings is disabled or not
Video_error_or_removed Whether video has error or it is removedYouTube Video Category Id list:
2 – Autos & Vehicles1 – Film & Animation10 – Music15 – Pets & Animals17 – Sports18 – Short Movies19 – Travel & Events20 – Gaming21 – Videoblogging22 – People & Blogs23 – Comedy24 – Entertainment41 – Thriller42 – Shorts43 – Shows44 – Trailers
25 – News & Politics26 – How to & Style27 – Education28 – Science & Technology29 – Nonprofits & Activism30 – Movies31 – Anime/Animation32 – Action/Adventure33 – Classics34 – Comedy35 – Documentary36 – Drama37 – Family38 – Foreign39 – Horror40 – Sci-Fi/Fantasy
3 | P a g eYou 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 membersenrolled in the same laboratory). It is expected that each team member will contributeequally in the project. Each team will turn in one joint document and give a jointpresentation in Timetabled Laboratory class in Week 10. In addition, each individualteam member will write a short reflection as part of the report. You will receive feedbackon the draft about presentation choices, content, analysis, and style.The QuestionsYour job is to examine the dataset and present it in a set of informative graphs and textby answering the following questions.Guided Questions for Dataset1. 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 monthof 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 differencesbetween 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 informationWrite a description of the selected dataset and project, and its importance for the firm.Information must be appropriately referenced. [1 Page]4 | P a g eTask 2 – Reporting / DashboardsFor your project, perform the relevant data analysis tasks by answering the abovequestions and, identify the visualization and dashboards you need to develop for theContent Manager of the indicated firm. [2-3 Pages]Task 3 – Advanced Insights: In addition to the guided questions, it is expected toprovide at least five (5) insights of the data. These insights will be judged in terms ofquality and complexity.Task 4 – ResearchJustify 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 youproposed (feel free to include all other relevant justifications).Note: To ensure that you discuss this task properly, you must include visual samples ofthe reports you produce (i.e. the screenshots of the BI report/dashboard must bepresented and explained in the written report; use ‘Snipping tool’), and also include anyassumptions that you may have made about the analysis in your Task2 (i.e. the report tothe content manager of the company). [1-2 Pages]Task 5 – Recommendations for Content ManagerThe Content Manager would like to improve the multimedia operations. Based on yourBI analysis and the insights gained from the dataset in the lights of analysis performedin previous tasks, make some logical recommendations to the Content Manager, andjustify why/how your proposal could enhance company’s multimedia operations andcould assist in achieving operational/strategic objectives with the help of appropriatereferences from peer- reviewed sources. [1-2 Pages]Task 6 – Cover letterWrite a cover letter to the Content Manager with the important data insights andrecommendation to achieve operational/strategic objectives [1 page]Task 7 – The Reflection: Each Team member is expected to write a brief reflection aboutthis project in terms of challenges, learning and contribution.Other Tasks –Please refer to marking scheme at the end of the assignment for other tasks andexpectations.Report Submission:• Hard-copy to tutors/lecturers assignment box in week 10. Double- sidedprinting 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 coverpage and references) of this project. At least 15 references in your report mustbe from peer-reviewed sources. Include any and all sources of informationincluding any person(s) you interviewed for this project.• Please note that all references must adhere to APA style. See and5 | P a g e for details on how to format a report and how to citereferences. Make sure your follow formal report structure with cover page,introduction, use of headings, subheadings, conclusion sand reference section.• You are reminded to read the “Plagiarism” section of the course description. Youressay should be a synthesis of ideas from a variety of sources expressed in yourown words. All reports must use the APA referencing style. UniversityReferencing/Citation Style Guide: The University has published a style guide tohelp students correctly reference and cite information they use in assignments(American Psychological Association (APA) citation style, t/ch06s04.shtml or Australian citation style• 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 abibliography of the wider reading you have done to familiarize yourself on thetopic.• A passing grade will be awarded to assignments adequately addressing allassessment criteria. Higher grades require better quality and more effort. Forexample, a minimum is set on the wider reading required. A student readingvastly more than this minimum will be better prepared to discuss the issues indepth and consequently their report is likely to be of a higher quality. So beforesubmitting, please read through the assessment criteria very carefully.6 | P a g eITECH1103- Big Data and Analytics Assignment 1Data Analysis Marking Scheme-Percentage 20%Due Week 11 (Sunday 11:55pm) – Hard and Soft Copies
1- Background of the Project: Description ofProject, Datasets and firm. The importantof project for the firm [1+1+1+2]
2- Dashboard/Reports What are the BIreporting solution/dashboards you willneed to develop for Content Manager ofchosen in the light of Questions of yourData analysis – [Quality and complexity ofthe analysis –
3- Advanced Work: The quality andcomplexity of additional five (5) insightsprovided other than the guided questions.
4- Research – Justify why these BI reportingsolution/dashboards are chosen and whythose attributes are present and laid out inthe fashion you proposed (feel free toinclude all other relevant justifications).Note: To ensure that you discuss this taskproperly, you must include visual samplesof the reports you produce (i.e. thescreenshots of the BI report/dashboardmust be presented and explained in thewritten report; use ‘Snipping tool’), and alsoinclude any assumptions that you may havemade about the analysis in your assignmentreport (i.e. the report to the operationalteam of the company).[Each analysis/dashboard and report explanationwith relevant research papers, complexity and indepth of the justification, use of peer-reviewedsources]
7 | P a g e
5- Recommendations – The Content Managerwould like to improve the advertisingoperations. Based on your BI analysis andthe insights gained from dataset in thelights of analysis performed in previoustasks, make some logical recommendationsto the Content Manager, and justifywhy/how your proposal could assist inachieving operational/strategic objectives.
6- The Reflection: Each Team member isexpected to write a brief reflection aboutthis project in terms of challenges, learningand contribution.
7- Cover letter (Format, key findings andrecommendation ) [1+1+3]
8- Other Tasks Report is well-written andpresented 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 andsummaries to justify all observations andrecommendations• Overall structure, presentation andformatting.Note that the report has to be presented formally.It must include discussion of calculations,observations and recommendations with graphsand/or tables.
Total Marks
Total Marks out of 20
8 | P a g eITECH1103- Big Data and AnalyticsAssignment 1- Data Analysis PresentationMarking Scheme Worth 10%Due Week 10 (Scheduled Tutorial) – Hard and Soft CopiesStudents are expected to create and present a 10-15 minute overview of the findings fromtheir Team Report.Student IDs:Assessment Criteria:
Content – Guided & Advanced Questions
Presentation Style e.g. clarity, engagement
Team participation
Timing (10-15 minutes)
General Comments:

Order from Academic Writers Bay
Best Custom Essay Writing Services