We have arrived at Day-3. As usual we did our presentations in the mornings and we were straight into our 3rd challenge.

For Day-3 we will be looking at data for the city of Melbourne. They have a diverse set of data sets ranging from locations of artworks, footpaths, bike paths, sensor locations, and café locations to name a few. From the initial look at the data, I decided to something related with restaurants and foot traffic. So, if I’m interested in setting up own restaurant where should I be looking to set-up that will be away from my competition but still be at a close proximity to heavy foot traffic.

Learnings from Day 2

A lot of lessons learned. The theme of day-2 was also time boxing. Unfortunately, I finished my dashboard, Alteryx documentation and blog quite late. I spent too much time on cleaning the data which ate into how much time I had to dashboard. Day-3 is looking far better in that regard as the data is pretty clean and not a lot of prepping was necessary.

Data Prep

As stated earlier, data prep was a lot easier today as the data wasn’t too large and it was pretty clean. I just 3 workflow that were pretty small and easy to clean, and you can see some snapshots below:

This was the first workflow which has data that concerns restaurants in Melbourne.

The second workflow had data for where the sensors were located to measure the footpath traffic, which was then joined to another data set which had the count, on location_id.

The final workflow consisted of the footpath network for Melbourne.

My thoughts were to answer the question of where should I open an eatery in Melbourne. I have data for where the current restaurants are, as well as footpath traffic data, and the network for footpath. My dashboard is mainly aimed at someone who simply has an idea for starting a restaurant and would like to see where the competition is which help them move forward.


One of the requirements for today was using spatial. And the map options in terms of what the map looks like is quite limited, and I ended up using MapBox to make a bit more of an aesthetically pleasing map, like this:

You can go this link, https://www.mapbox.com/, if you are interested, make an account and you can create your own or use a template and change colour as you please.

Overall, my dashboard will give anyone that thinks about opening a restaurant and wants to get an idea of where the heaviest foot traffic is and where the competition is as well.

The Data School
Author: The Data School