As the challenging dashboard week reaches its halfway point, I feel like I have gained a lot of knowledge. Today’s task involves exploring the City of Melbourne’s open data source and conducting a spatial analysis to aid decision-making,As I delve into this task, I’m excited to see what insights I can glean from the data and how I can apply them to real-world scenarios. Spatial analysis has always intrigued me, and I’m eager to apply my newly acquired skills to this project.

The Challenge and my story

As I sat down to plan my weekend, I couldn’t help but feel a sense of excitement and anticipation building up within me. With the end of the week just around the corner, I was eager to find the perfect way to kick off my Friday night. That’s when I remembered hearing about the live music scene in the city of Melbourne and how it’s a hub of entertainment for music lovers.

Without hesitation, I decided to explore the dataset available at https://data.melbourne.vic.gov.au/explore/dataset/live-music-venues/export/ to help me find the perfect venue to spend my evening. Armed with the data, I could analyze the various live music venues and their characteristics, such as their location, type, and capacity.

By diving into this data, I hoped to uncover new and exciting insights into Melbourne’s music scene and discover a venue that matched my Friday night vibe. After all, what better way to unwind after a long week than with some live music and a great atmosphere?

Data Understanding and data cleansing

After some consideration, I’ve decided to shift my focus away from Alteryx and instead concentrate on creating a spatial map using Tableau. While Alteryx is undoubtedly a powerful tool, it’s not particularly well-suited to visualizing maps or creating interactive elements.

Dashboarding and Interactivity

I have transformed my dashboard into a functional tool that enables users to find the nearest live music venues in Melbourne. Using this tool, you can simply enter your location’s longitude and latitude, which can be easily found on Google Maps, and select a radius for the buffer zone.

The map will display all the live music venues within the selected buffer zone, highlighted for your convenience. On the right-hand side of the map, you will find a list of all the venues in the buffer zone, sorted by proximity to your location. This list includes useful information such as the venue’s name, address, and type.

To learn more about a particular venue, simply click on its name to visit its website and see what’s new. With this functional dashboard, you can easily explore Melbourne’s vibrant live music scene and find the perfect venue to match your mood. So whether you’re in the mood for a bar, nightclub, or hotel, this tool has got you covered

 

The Data School
Author: The Data School