Reference no: EM132312644

Assignment

Background

This is an individual assignment, which requires you to analyse a given data set, assemble an interactive dashboard using the Tableau software, and then convey your results as a website through WordPress platform.

This assignment assesses following Graduate Learning Outcomes and related Unit Learning Outcomes:

Graduate Learning Outcome (GLO)
GLO1: Discipline-specific knowledge and capabilities - appropriate to the level of study related to a discipline or profession.

GLO2: Communication - using oral, written and interpersonal communication to inform, motivate and effect change.

GLO3: Digital literacy - using technologies to find, use and disseminate information.

Unit Learning Outcome (ULO)
ULO 1: Apply quantitative reasoning skills to solve complex problems.

ULO 2: Deduce clear and unambiguous solutions in a form that they useful for decision making and research purposes and for communication to the wider public.

Scenario

You will continue with your role as a master of business analytics student doing an internship at Beautiful Data Inc. In addition to data analytics, the company is specialised in developing insightful and dynamic dashboards for their clients.

Todd has requested you to come up with an interactive business dashboard for one of their clients, i.e. Sony. In his memo sent to the analytics team via SLACK (see next page), Todd has provided some guidelines on how to tackle the task. In particular, you are expected to explore the Sony dataset and develop an interactive dashboard using Tableau Desktop software. Then, you should convey your results as an eportfolio comprised of a process component and a solution component via WordPress platform.

Dataset Details (accessible via Sony.xlsx file)

The Excel file contains details of 150 Albums. Data description is available from Variable_Descriptions worksheet in the Excel file.

The ‘Sony' 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 (additional Latitude/Longitude data, web links etc.). However, the focus of the assignment should be on the core data provided in the dataset.

The assignment consists of two main sections (web pages): Process and Solution (accessible via Sony Project menu in the WordPress template). You are required to complete both parts. This assignment is equivalent to 2,500 words.

A) Process Component

You are required to complete this section by completing four pre-set web pages under the process menu. Content presented here should be written in ‘professional' language and must cover the following four aspects:

1) Describe the Audience for your Data Visualisation (to be written under AUDIENCE page)

Describe the audience of the Data Visualisation you intend to create. This section should include a general description of the persona, questions they want to be answered, actions/outcomes your dashboard will be supporting, and the feeling you would like to convey.

2) Identify Data Elements
(to be written under DATA ELEMENTS page)
Using what you have learnt in the lectures and tutorials, first 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). Then classify the data (example, Categorical, Numerical: Discrete, Continuous / Scales of measurements: Nominal, Ordinal, Interval and Ratio / Time/Date, Location).
3) Describe at a high level what types of charts you might use to display the data. (to be written under THE RIGHT FIT page)
Based on the data types you described earlier in this section, along with the objectives of the persona you described, describe what charts and visualisations do you think might work well to communicate the information.
4) Finally, describe any data ethics considerations there with the data you intend to use. (to be written under ETHICS page)
Describe any considerations you think you should keep in mind while developing and sharing your visualisation.
Note: While adding content, images, and tables are allowed under these sections (web pages); students are strictly prohibited from moving web page locations, renaming web pages or adding new pages under the PROCESS component.

B) Solution Component

Under the SOLUTION component (WordPress web page), you are expected to have two deliverables, namely, Live Dashboard and Story Telling.

First, using the skills, you have developed in the tutorial sessions (and leveraging any additional training and online support provided by Tableau Inc.) you should develop an interactive dashboard using Tableau Desktop. Then, you should embed your interactive dashboard on the Live Dashboard web page.

Note: Instructions on how to retrieve embed code and import interactive dashboard to WordPress websites is available in the WordPress Instruction Manual.

Under the Story Telling web page, you are expected to capture and describe various screenshots of your interactive dashboard developed using Tableau Desktop.

Your descriptions, comments, or annotations of the interactive dashboard should detail how you have considered the data visualisation framework while developing the interactive dashboard.
The questions below will give you some ideas of the type of comments you should include in this section:

I. What types of charts have you selected and why? II. How have you used colour (or not)?

III. How have you used hierarchy in your approach?

IV. What interactive components did you introduce?

V. How have you supported the motivations of the persona you defined?

VI. Comment on data sources and any data manipulation you may have performed.
Note: While adding content, images and tables are allowed under these sections (web pages); students are strictly prohibited from moving web page locations, renaming web pages or adding new pages under this PROCESS component.

C) Other components of the WordPress website

There are three web pages on the WordPress website template where you need to provide additional information. These include Welcome to Beautiful Data Inc. (Home page), About Us, and Contact pages.

In the Welcome page, you may provide some information about Beautiful Data Inc. operations as well as the visualisation project, i.e. Sony chain, its history, and operations (be creative).

In the About Us page, you should briefly introduce yourself.

Attachment:- Descriptive Analytics and Visualisation.rar