Today is the third day of dashboard week. We were told to find a data set which had a Arcgis connection. After lots of searching I decided to go with a data set from Environmental Planning Instrument – Land Zoning NSW.
What is ArcGis?
ArcGIS is a platform for organizations to create, manage, share, and analyse spatial data developed by Esri.
So How do you connect to Arcgis in Tableau?
Tableau has a very sophisticated integration with Esri-Arcgis. You have to open a Data Connection and Select ESRI-ArcGIS Server.
It will pop a window to enter the map server URL.
It will connect to the server when you click “’Ok”
The Land Zone Data set had 7 tables, each with different shape files.
I spent some time to go through each table to understand the data. I tried to do a few joins in the table, there was no similar fields to connect to. The only common attribute was the LGA.
I decided to try Spatial Match in Alteryx instead of joining them in Tableau.
But unfortunately Joining tables both ways was making the process too slow. Due to the time constraints I decided to use another external file to find the Population density and analyze it with the Property Heights in the LGA.
I joined the Population Data in Tableau with the Property Height Table.
Now it was time for me to story board and create a Viz.
Data Visualisation
I wanted to see whether densely populated LGA’s Had more high Rise than other LGA’s. I had to make a few calculations to get the building heights in to bins. And then show it in a map. Also I was keen to see if there was any insights for Lot size.
There fore I came up with the dashboard below to find some insights.
It was a Great Challenge to practice my Spatial Skills and Esri ArcGIs.
Looking forward for the challenge tomorrow.