Your Working Dashboard

Assignment Part 2
Your Working Dashboard
Due 22/10/2019 by 10:00am
Assignment Part 2 is worth 15% of your final grade.

Submission via LearnOnline

Submit a packaged Tableau .twbx file and a Microsoft Word document (.docx) ONLY.

zip and PDF files will not be accepted.

If you have problems submitting, keep proof of your submission attempt and email me at

Part 2 Submission Preparation Instructions:
When you are ready to submit you will upload two files: a Microsoft Word .docx file and a working
Tableau dashboard, submitted as a packaged Tableau file (.twbx). You have practiced how to create
.twbx files in your practicals using the File menu in Tableau:

A .twbx file combines your data and dashboard into one file and we need this for assessment and
Warning! If the marker cannot open the dashboard in Tableau the assignment you will be given
0 marks for this part of the assignment – you are not able to re-submit your work.
• Once submitted do not edit any electronic files of your work.
• Assignments submitted late, without an extension being granted, will attract a penalty of 10
marks per each working day or any part thereof beyond the due date and time. Please refer to
the Course Outline for the course policy regarding extensions.
• An incorrectly or partially filled cover sheet will result in lost marks and delays in the marking
and return of your assignment.

Page 17 of 19

Assignment Part 2 Marking criteria

Area Weighting

Dashboard Requirements
A mixture of visualisations:
• At least 4 and no more than 6 different visualisations
• At least one visualisation must be a non-standard Excel
visualisation (e.g. a geographical map or bubble diagram)


Quality of dashboard: layout and good design – taking into account
readability, variable type (eg. use of retinal variables), order of
visualisations, instructional text. What is the story you are telling with
your visualisations?


Questions able to be answered 20%
Interactive features – allowing the CEO to use filters/slidebars or
other means to change the data

Correct linking of at least two data sources 10%
Written Submission
Instructions, including questions and explanation for changes if
necessary (maximum 350 words)


Loss of 10 marks for incorrect file type submitted
Late marks – 10% of total mark awarded per working day

Part 2 will be the creation of the dashboard you proposed in Part 1. The dashboard needs to be built
using Tableau with actual data. Your dashboard should be accompanied by a brief instruction
(maximum 350 words) on how the dashboard should be operated to deliver insight into the questions
you identified in Part 1. See below for what to do if you can’t find data and also for guidelines on how
to write the instruction document.

Need Dashboard Inspiration?
In Week 2 we gave you a copy of the Tableau whitepaper “Which chart or graph is right for you?” – you
can download it from the course website (Workshops page, Week 2).

Tableau also have a massive visualisation gallery at

Page 18 of 19
Data – You Can’t Find Data to Answer Your Questions?
An unfortunate fact of any analysis is that we aren’t always able to find data to support the questions
we need to answer. In the real-world, if you won the job you might still find the organisation does not
have the data you need or in the expected format and. you will need to revise your questions.
You might find you’ve just run into the same problem – you have the best questions ever in Part 1 but
the real-world has let you down because you can’t find data. Figures 2 (a) and (b) show an example of
this situation and what you will need to do if this happens to you. Remember, we will not deduct marks
providing you explain this change in your written submission for Part 2. So no stress, just hit those
data engines one more time ☺



Figure 2: (a) no data to support questions and (b) the approach to take when/if this happens.


What does
‘young’ mean?

What are popular
travel destinations?

Do young people prefer
overseas travel?

Do preferences
vary by age?

Does gender
influence preferred
travel experiences?

Priority: We have a clear priority that has a focus but is broad
Questions: We can come up with any questions that relate to/support providing insight into this priority.
Data: When we look at the data, some of the questions can be answered, some can’t. What do we do?

no data

Data Data Data
no data


What does
‘young’ mean?

What are popular
travel destinations? New Question New Question

Does gender
influence preferred
travel experiences?

Priority: Stays the same
Questions: Keep questions we can answer, come up with new questions that support the priority
Data: Add more sources and/or use what we have

Data Data Data
find data for new
question + explain in

find data for new
question + explain in

Page 19 of 19

New Questions: think broadly around your chosen organisation for questions + data sets e.g.
• Qantas’ performance is impacted by tourism, exchange rate, fuel prices, visa conditions,
other airlines and terrorism;
• A physiotherapy practice you would look for health related data and aging population. Aging
population is a hot topic especially in South Australia; and
• Demographic information on which age groups use mobile phones.
These are examples of different types of data to look for. The importance is the relevance to the
question and the reliability of the data to answer the question – not so much the volume of data!
Working Dashboard Instructions for Assignment Part 2
Your working dashboard should be a .twbx file – we learned how to produce those in pracs! The
visual specifications for your working dashboard are given in the marking criteria at the start of the
Assignment Part 2 section of this guide.
Written Dashboard Instructions for Assignment Part 2: Presentation + Structure
Word Limit
Strict maximum of 350 words.
These instructions should be written in Microsoft Word .docx format only.
Marks will be deducted if the instructions are over this word limit. Keeping to a word limit requires
a focus on what the reader most needs to know. The proposal should contain the sections below
covering the points described:

Section Explanation

Title Page • The title page is separate to the assignment cover page
• See Microsoft Word templates for examples.
Introduction • A very brief statement introducing the Priority the

dashboard supports.

Dashboard Instructions • Explain which dashboard visual answers which Priority

Question(s) and the insight(s) gained.
• Document any issues with finding data and indicate
whether questions have been dropped or replaced – if
replaced, indicate the relevant visual to the new
• Word limit: strictly no more than 350 words.
Reference(s) • You must include the sources of data you used – can
either be on the dashboard itself (if you have the space)
or in the Dashboard Instructions
• These are excluded from the word count.
• If you do include references, refer to the referencing
guide from Assignment Part 1 for formatting.