How to run a Data Visualisation Project), as well as that from published articles, back to the business problem.

Imagine that you are a newly hired middle manager for an online office supplies company….

Business problem: Imagine that you are a newly hired middle manager for an online office supplies
company. You have a background in data analytics and so you understand big data issues as well as
how to manage an analytics team. Your employer routinely collects sales data from different regions of
Australia and the executives of the company have asked you to report on the results for the period
2013 to 2016. This means that the sales data must be analysed, visualised and a report written.
On this occasion you decide to analyse the data for yourself and report to the executives. Given that this
is a routine task and analyses should be done preferably every six months, rather than waiting for four
years, you want to provide advice on how this task may be done in the future.
In particular, the analysis of sales data could be considered a project and therefore there are implications
associated with its management. You might also consider outsourcing the analysis next time, and
consequently you would need to consider the risks and costs related to that decision. On the other hand,
if you keep the analysis in house, you would need to decide what software to buy/build.

Attachments:Page 1 Kaplan Business School Assessment Outline
Assessment 3 Information
Subject Code: DATA4100
Subject Name: Data Visualisation Software
Assessment Title: Individual Report
Assessment Type: Creating a dashboard for a Business Problem
Word Count:
1500 Words (+/-10%)
Weighting: 40 %
Total Marks: 40
Submission: Via Turnitin
Due Date: Monday, 23.55pm (AEDT) Week 13
Your Task
This report is to be done is an individually.
• Part A: Given a business problem and data, create visualisations, interpret and report on the
outcomes. (20 Marks)
• Part B: Relate the theory that you have learnt in week 5 (Creating an analytics platform: add,
build or buy?) and week 7 (How to run a Data Visualisation Project), as well as that from
published articles, back to the business problem. (15 Marks)
5 marks will be awarded for structure and referencing.
Individually complete Part A and Part B of the assessment and submit the assessment as a Microsoft
Word file via Turnitin. This assessment covers Learning outcomes: LO2, LO3
Assessment Description
Business problem: Imagine that you are a newly hired middle manager for an online office supplies
company. You have a background in data analytics and so you understand big data issues as well as
how to manage an analytics team. Your employer routinely collects sales data from different regions of
Australia and the executives of the company have asked you to report on the results for the period
2013 to 2016. This means that the sales data must be analysed, visualised and a report written.
On this occasion you decide to analyse the data for yourself and report to the executives. Given that this
is a routine task and analyses should be done preferably every six months, rather than waiting for four
years, you want to provide advice on how this task may be done in the future.
In particular, the analysis of sales data could be considered a project and therefore there are implications
associated with its management. You might also consider outsourcing the analysis next time, and
consequently you would need to consider the risks and costs related to that decision. On the other hand,
if you keep the analysis in house, you would need to decide what software to buy/build.
Page 2 Kaplan Business School Assessment Outline
Data set
• Access the sales data file, “DATA4100_Store_Sales.xlsx” on the KBS Student Portal
(announcements).
Original Source: TIBCO Spotfire sample data from the US modified to have Australian locations
• The data consists of product details, costs, customers and sales region
Assessment Instructions
The report will consist of two parts- Part A and B.
Part A: After accessing the data, prepare eight visualisations in order to provide insight to the
executives of the company about store sales around Australia from 2013-2016. In constructing the
visualisations, consider best practices, such as the use of pre-attentive attributes.
• Write 1000 words interpreting the implications your visualisations have for store sales
performance.
Part B: Relate the theory that you have learnt in week 5 and week 7, and published literature, back to
this business problem.
• More specifically, detail your options regarding project management considerations, the choice of
software (buy or build) for future analyses, risks and costs of the decisions you make.
• This section should be 500 words.
• A minimum of five references is expected. Use Harvard style referencing (see student “Study
Support Resources”, scroll to “Referencing and Plagiarism Help”).
• Marks will be allocated for report structure and referencing (see rubric).
Page 3 Kaplan Business School Assessment Outline
Important Study Information
Academic Integrity Policy
KBS values academic integrity. All students must understand the meaning and consequences
of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct
Policy.
What is academic integrity and misconduct?
What are the penalties for academic misconduct?
What are the late penalties?
How can I appeal my grade?
Click here for answers to these questions:
http://www.kbs.edu.au/current-students/student-policies/.
Word Limits for Written Assessments
Submissions that exceed the word limit by more than 10% will cease to be marked from the point
at which that limit is exceeded.
Study Assistance
Students may seek study assistance from their local Academic Learning Advisor or refer to the
resources on the MyKBS Academic Success Centre page. Click here for this information.
Page 4 Kaplan Business School Assessment Outline
Assessment Marking Guide
Data Visualisation Software
Marks Available
Part A: Visualisations and
Interpretation
• Students should be able to
design eight visualisations
• The charts should be easy to
read and consider preattentive attributes
1000 Words
20 marks
Part B: Integration of Theory
Students should relate the
theory of week 5 (project
management) and week 7
(buy/build software), including
risks, and costs of decisions
made.
500 Words
15 marks
Structure and referencing
Student should be concise &
their report should have relevant
headings & findings
A minimum of five references
should be included (using
Harvard style referencing)
5 marks