Page | 1 DEAKIN BUSINESS SCHOOL DEPARTMENT OF INFORMATION SYSTEMS AND BUSINESS ANALYTICS MIS771 Descriptive Analytics and Visualisation Assignment Three Introduction % Total Mark for Unit: 40% Submission Due Date: Sunday 9th October 2016 11:59 pm Submission Location: CloudDeakin Dropbox The Data Visualisation assignment consists of the following steps: a) Review the dataset b) Identify key data elements in the selected dataset that could be used to explore further using data visualisation methods. c) Define a business/user persona that will be the audience of your data visualisation, and develop a story to help focus and guide your data visualisation development process. d) Present a professional report outlining the key aspects of your data visualisation. e) Develop a Data Visualisation dashboard (using the Tableau software), and present screenshots and descriptions of the dashboard in PowerPoint. The formal assignment submission will comprise the following two components: a) Written component (maximum 4 pages including cover page provided in PDF format). b) Presentation component (maximum 10 slides including cover page provided in PowerPoint format). Note: Students can provide either Individual Submissions or Group Submissions (that is, in teams of 2 or 3 students). You will need to submit your assignment documents via the appropriate assignment submission box.Page | 2 Penalties for late lodgement: Extensions of time are not permitted. A penalty of 10% of the 40 marks allocated to this assessment task will be deducted for each day or part day that the assessment is late. Penalties include weekend days. The remainder of this document will review the details of each component of the assignment. Written Component (Details) You are required to write a 'professionally' presented business report based on the working data and with the following content areas (no more than 4 pages including cover page presented as a PDF): a) Identify Data Elements Using what you have learnt in the lectures and tutorials, please describe each column in the dataset (note: you should describe all columns regardless of whether you will ultimately use them in your visualisation or not) and classify the Data (example, Categorical, Numerical: Discrete, Continuous / Scales of measurements: Nominal, Ordinal, Interval and ratio / Time/Date, Location) b) Describe the Audience for your Data Visualisation Describe the audience of the Data Visualisation you intend to create. This section should include a general description of the persona, questions they want answered, actions/outcomes you will be supporting, the feeling you'd like to convey. c) Describe at a high level what types of charts you might use to display the data. Based on the data types you described earlier in this section, along with the objectives of the persona you described, what charts and visualisations do you think might work well to communicate our information. d) Finally, describe any data ethics considerations there with the data you intend to use. Please describe any considerations you think you should keep in mind while developing and sharing your visualisation. You will NOT be expected to present an Oral Presentation of your assignment to the class, instead your entire assignment score will be based on the assessment of your written and presentation submission.Page | 3 Presentation Component (Details) In the Presentation component of the assignment you are expected to develop an Interactive Data Visualisation Dashboard, using your selected dataset, and then capture and describe various screenshots in a PowerPoint presentation (no more than 10 slides including the cover page). Then using the skills you have developed in the tutorial sessions (and leveraging any additional training and on-line support provided by Tableau) you should develop an interactive Data Visualisation using the Tableau software. In addition to the screenshots, you are required to provide additional comments and descriptions on each slide (for example, add Audio commentary, or comments on each slide), which describe details about how you have considered the Data Visualisation Framework while developing the Data Visualisation. For example: a) What and why you selected certain types of Charts? b) How have you used Colour (or not)? c) How have you used Hierarchy in your approach? d) What Interactive components do you introduce? e) How have you supported the motivations of the Persona you defined? f) Data Source details/citations, and any data manipulation you performed Hint: You can simply capture full screenshots using the MS-Windows function, or you can easily export 'Screen images' by using the 'Export Image' option from either Tableau Worksheet or Dashboard menu items. Hint: In some later versions of PowerPoint you can also record your own personal commentary directly in to the PowerPoint file… Try using the menu option Slide show-- > Record Slide ShowPage | 4 Datasets (Details) For this Data Visualisation assignment, I have provided you with a Dataset that contains Data Elements with characteristics that lend themselves to different types of Data Visualisations and Interactions (that is, Multi-Variant and Geo-Location). The following section provides a high-level description of the Dataset and the actual dataset will be available via the Cloud Deakin Site. Dataset: Sony Music Filename: SonyMusic.xlsx The 'Sony Music' dataset is a Multivariate dataset that provides details on 150 albums released by Sony Music in the last 6 years. Sony Music Entertainment (sometimes known plainly as Sony Music or by the initials, SME) is an American music corporation managed and operated by Sony Corporation of America (SCA), a subsidiary of Japanese conglomerate Sony Corporation and is the world's second largest music company, after Universal Music Group. Out of the "Big Three" record companies, with Universal Music Group, being the largest, and Warner Music Group, SME can be considered a middle-sized company which has managed to survive despite all fluctuations in the music industry. Hint: You may add additional Statistical analysis and/or supporting data of your own (for example, additional Latitude/Longitude data). However, the focus of the assignment should be on the core data provided in the dataset.Page | 5 Rubric Criteria Poor Needs Improvement Acceptable Well Done Excellent Part 1: Written Components - Overall Presentation Quality of Written Submission (Marks: 2) 0 points The structure of the written submission was unclear and difficult to follow (0 Marks) 0.5 points The written submission had a basic structure but was inconsistent or incomplete (0.5 Marks) 1 point All written topic areas were covered and basic structure was provided (1 Marks) 1.5 points The written submission was complete and very well presented (1.5 Marks) 2 points The written submission was skilfully prepared and comprehensively presented (2 Marks) Part 1: Written Components - Identified and described data elements, described audience, explained charts (Marks: 12 ) 0 points None of the specified Topic areas was answered clearly or completely (0-2.9 Marks) 3 points All Topic areas were addressed but most topics lack clarity and/or incomplete (3-5.9 Marks) 6 points All Topic areas were addressed but some topics lack clarity and/or incomplete (6-7.9 Marks) 8 points All Topic areas were addressed with clear and complete answers (8-9.9 Marks) 12 points An exceptional understanding of all specified Topic areas was clearly demonstrated (10-12 Marks) Part 1: Written Components - Describes Ethical Considerations (Marks: 2 ) 0 points No attempt was made to provide any details on Ethical Considerations (0 Marks) 0.5 points An attempt was made to articulate Ethical Considerations, but the answer was either unclear or incomplete (0.5 Marks) 1 point A simplified or generic Ethical Consideration answer was provided (1 Marks) 1.5 points A clear and complete answer was provided that especially related to the Assignment data (1.5 Marks) 2 points An exceptional understanding of the Ethical Considerations was clearly demonstrated (2 Marks) Part 2: Presentation Components -Overall Presentation Quality of Presentation Submission (Marks: 4) 0 points The structure of the presentation submission was unclear and difficult to follow (0 Marks) 1 point The presentation submission had a basic structure but was inconsistent or incomplete (1 Marks) 2 points The presentation was well presented and a good basic structure was provided (2 Marks) 3 points The presentation submission was complete and very well presented (3 Marks) 4 points The presentation submission was skilfully prepared and comprehensively presented (4 Marks) Part 2: Presentation Components -Information, design, and interaction elements, Persona Objectives (Marks: 20 ) 0 points Only some Topic areas were addressed or most were incomplete and lack clarity (0-9.9 Marks) 10 points All Topic areas were addressed but most topics lack clarity and/or incomplete (10-11.9 Marks) 12 points All Topic areas were addressed but some topics lacks clarity and/or incomplete (12-13.9 Marks) 14 points All Topic areas were demonstrated clearly and completely (14-15.9 Marks) 20 points An exceptional understanding of all specified Topic areas was clearly demonstrated (16-20 Marks) Overall Score Or equivalent Fail (N) 0 or more Or equivalent Pass (P) 20 or more Or equivalent Credit (C) 24 or more Or equivalent Distinction (D) 28 or more Or equivalent High Distinction (HD) 32 or more