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.

Harsha Kunchu
Author: Harsha Kunchu