Task 3 Reports using Tableau Desktop (Worth 25 Marks)
The following web site was used to construct a list of people who died while climbing Mount Everest.This data set contains the following variables, note there are missing values in this data set.
|
Variable Name
|
Type and description of variable
|
Range of values
|
|
No_Deaths
|
Integer
|
running count of deaths
|
|
|
|
recorded in climbing Mt
|
|
|
|
Everest
|
|
Name
|
Character String, Name of person who died
|
Range of names of people
|
|
|
on Mt Everest
|
|
|
Age
|
Integer, age when person died on Mt Everest
|
Range of ages in integer values
|
|
Expedition
|
Character String, Name of Mt Everest
|
Range of Expeditions
|
|
|
Climbing Expedition
|
|
|
Nationality
|
Character String, Nationality of Person who
|
Range of Nationalities
|
|
|
died on Mt Everest
|
|
|
Cause_Death
|
Character String, Cause of Death
|
Range of causes of death
|
|
Location
|
Location of death on Mt Everest
|
Range of locations on Mt
|
|
|
|
Everest
|
With the MtEverestDeaths.xlsx data set use Tableau Desktop to produce three different views of Deaths that have occurred in expeditions attempting to climb Mt Everest. Note you will find it useful to do some research on the Deaths that have occurred in expeditions attempting to climb Mt Everest in order to comment on each of three views of Deaths on Mt Everest that you will need to create for Task 3.1, 3.2 and 3.3.
Task 3.1) Create a view of the Deaths on Mt Everest in a Tableau Text Table or Graph view that displays by Nationality, No_Deaths over time (in years). Comment on the key trends and patterns that are apparent in this Text Table/Graph (about 50 words).
Task 3.2) Create a view of the Deaths on Mt Everest in a Tableau Text Table or Graph view that displays by Location, Cause of Death, and Nationality. Comment on the key trends and patterns that are apparent in this Text Table/Graph (about 50 words).
Task 3.3) Create a view of the Deaths on Mt Everest in a Text Table or Graph view that displays by Expedition, Cause of Death and Nationality. Comment on the key trends and patterns that are apparent in this Text Table/Graph (about 50 words).
Note that you need provide a copy of each Text Table or Graph view in your Assignment 2 report for the relevant sub Tasks 3.1, 3.2 and 3.3. The Tableau Menu / Worksheet and then Copy or Export Options will allow you to copy and paste the view for each Text table or Graph into relevant section of Task 3 for your Assignment 2 report.
Note you need to provide a copy of your Assignment 2 Task 3 Tableau file in twbx format as part of your Assignment 2 submission
Your assignment 2 report must be structured in report format as follows:
Title Page for Assignment 2 Report Table of Contents
Body of report – main sections and subsections for assignment 2 tasks and sub tasks so Task 1 will be a main heading with appropriate sub headings etc....for each sub task
such as Task 1.1, Task 1.2 etc.. Task 2 …
Task 3 …. List of References List of Appendices
You need to submit two files for Assignment 2:
1.Assignment 2 Report for Tasks 1, 2 and 3 in Word document format with the extension .docx
2.Tableau packaged workbook with the extension .twbx contains three required Text Table / Graph views for Task 3
Use the following file naming convention:
1.Student_no_Student_name_CIS8008_Ass2.docx and
2.Student_no_Student_name_CIS8008_Ass2.twbx
Harvard referencing resources
Install a bibliography referencing tool – Endnote which integrates with your word processor.
USQ Library how to reference correctly using the Harvard referencing system
REPORTS USING TABLEAU DESKTOP