Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

32146 Assessment Task 1: Data Visualisation

 

Collecting Dataset:

The dataset you will collect for this assessment task is from ABS and PriceFinder, which contains 20x years of Census data between 2001 and 2021. The dataset contains property median price, the suburb's house finance status, personal and family financial status, ownership and household information, dwellings information, family information, population and marriage status, and unemployment and unemployment and employment status. Dataset samples can be downloaded from Canvas.

 

Data Preparation:  

Task a. Collect and prepare the dataset and its characters, including finding and filling up all data in the proper format.

Task b. Understand data behaviours, styles, and it's patterns.

 

Visualisation 1. Supply and demand:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet, then calculate the ratio between total dwelling and population.

Task b. Create the visualisation combo graph and use layout / rescaling / labelling / trend / highlight techniques to find the supply and demand story, illustrate the supply and demand story and tell the supply and demand story.

 

Visualisation 2. Property price:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet.

Task b. Create the multiple line and bar charts, and choose the best one for property price data visualisation.

Task c. Use layout/rescaling/labelling/trend/highlight techniques to find the house and unit data story, illustrate the house and unit data story and tell the house and unit data story.

 

Visualisation 3. Finance:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet. The new datasheet includes household, family and personal finance status.

Task b. Create the multiple line and bar charts, and choose the best one for financial data visualisation.

Task c. Use layout/rescaling/labelling/trend/highlight techniques to find the income, mortgage and rent data story, illustrate the income, mortgage and rent data story, and tell the income, mortgage and rent data story.

 

Visualisation 4. Population:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet. Create a population index for measuring the population changes.

Task b. Create the multiple line and bar charts, and choose the best one for population data visualisation.

Task c. Use layout/rescaling/labelling/trend/highlight techniques to find the population changes and marriage status story, illustrate the population changes and marriage status story, and tell the population changes and marriage status story.

 

Visualisation 5. Ownership:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet.

Task b. Create the multiple line and bar charts, and choose the best one for the ownership status visualisation.

Task c. Use layout/rescaling/labelling/trend/highlight techniques to find the fully-owned, owner-with-mortgaged and rented status story, illustrate the fully-owned, owner-with-mortgaged and rented status story, and tell the fully-owned, owner-with-mortgaged and rented status story.

 

Visualisation 6. Workforce:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet.

Task b. Create multiple line and bar charts, and choose the best one for the workforce status visualisation.

Task c. Use layout/rescaling/labelling/trend/highlight techniques to find the full-time, part-time and unemployment status story, illustrate the full-time, part-time and unemployment status story, and tell the full-time, part-time and unemployment status story. As there is no 2021 Census data, trying use trends techniques to estimate in storytelling.

 

Visualisation 7. Dwelling:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet.

Task b. Create multiple line and bar charts, and choose the best one for the dwelling status visualisation.

Task c. Use layout/rescaling/labelling/trend/highlight techniques to find the separate house, semi-detached, and unit dwelling status story, illustrate the separate house, semi-detached, and unit dwelling status story, and tell the separate house, semi-detached, and unit dwelling status story.

 

Visualisation 8. Family:  

Task a. Create a new sheet that duplicated necessary data from the original datasheet.

Task b. Create multiple line and bar charts, and choose the best one for the family status visualisation.

Task c. Use layout/rescaling/labelling/trend/highlight techniques to find the couple family with or without children, one parent family, and other family status story, illustrate the couple family with or without children, one parent family, and other family status story, and tell the couple family with or without children, one parent family, and other family status story.

 

Visual Analytics. Summarise and conclusion:

 

Task a. Summarise the suburb's profile through each category's data. Indicate where the dataset came from, and highlight the data's attributes and characteristics. Data attributes should be adjusted to fit the visualisation techniques the student intends to use.

 

Task b. Write a report explaining how you dealt with data node-overlap / data edge-crossing / rescaling in your data visualisation, particularly in combining multi-dimensional data. Describe the graphic attribute designs and labelling techniques used in your data visualisation and how they enhanced the readability and storytelling of the visualisation. Highlights any trends and breakthrough analysis you have discovered through the data

visualisation process, particularly the price movement visual comparison. Concludes overall, you would give any recommendations to a buyer or investor for this suburb. Summarise the advantages of the visualisation approaches you have used.