The Aim of this blog:
The aim of this blog is to showcase what I have achieved on the first day of the dashboard week.
What did I build:
The dashboard I build is designed to find the best directions to travel from your apartment for entertainments and Relaxation.
The data set that we used for day 1 of dashboard week is the Census of Land Use and Employment (CLUE) Data from data.melbourne.vic.gov.au
To prepare the data for virtualization.
Firstly I joined the Bar__tavern__pub_patron_capacity_2019.csv, Building_information_2019.csv and Cafe__restaurant__bistro_seats_2019.csv files together by their Block ID.
Then I spatial matched them to the Blocks for Census of Land Use and Employment (CLUE).shp file using Alteryx.
How Does this Dashboard work ?
From the screen above, the user would first search for their apartment.
Then they click on one of the CLUE blocks they want to have a look at, to be redirected to the Apartment map, where all the apartment of that CLUE block is plotted on a similar map.
From there, they will need to click on one of the apartments to drill down to entertainment facilities that are close to the apartment.
What Tool did I use in Alteryx ?
The screen shot above is my Alteryx Workflow, it’s rather straight forward.
I started from Importing the three CSV filed into Alteryx, then filter for the types of facilities I will be using.
Then I Unioned the facilities together, and used the Create Point tool, to build spatial objects for each of facilities.
After all the spatial objects are created. I did a Find Nearest to identify all the facilities that are close to each of the apartments.
There you have it.
A simple dashboard to find the best direction to travel from your apartment for some relaxations and fun.