Michael Michelini
Having pursued a Bachelor of Science degree at Latrobe University, Michael specialized in Statistics and Mathematics. His academic journey was instrumental in nurturing a diverse skill set that amplified his prowess as an analytical thinker and effective problem solver. Early exposure to a range of technologies not only underscored his commitment to becoming a data analyst but also equipped him with practical knowledge. Presently, Michael stands as a proficient and adept developer in Alteryx, Python, and multiple BI tools reflecting his substantial experience and skill in these domains.
Alteryx quick tip: Downloading Images
You can download images directly through Alteryx. When paired with web scraping this can be a very powerful tool to automate downloading every image on a certain website. For this blog we will look at the download tool and how to download and save a single image in...
Tableau quick tip: Switching sheets with parameter
Sometimes you want to view the same data with 2 different charts. However this can take up a lot of space on the dashboard. One way to deal with this problem is using a parameter to give the user the ability to swap between charts. In this blog I'll explain how to...
Tableau quick tip: Linking to google maps by Lat and Lon
The viz Giving the user the ability to link to google maps based on latitude and longitude, allows users to get more context on interesting points in a visualisation. In this blog I will walk through how I made a clickable map that links to google maps. First we need...
Dynamic sorting in Tableau.
Tableau quick tip: Dynamic sorting in Tableau Giving the user the ability to sort by whatever measure they want can help them explore the visualisation through lenses they wouldn't otherwise be able to. Unfortunately I've never seen a way to do this, so I decided to...
Web scraping Bureau of Meteorology weather data in Alteryx
Weather data can be a great way to supplement some data sources. It allows you to view datasets from another angle and determine if the weather has an effect on your data. Our cohort had a client project where we had to do exactly this, and I've decided to write a...
Dashboard week – Day 4
For the final day of dashboard week our dataset was The Legatum Prosperity Index. The dataset has a hierarchical structure where each country has an over prosperity index. This prosperity score is made up pillars (eg. education, health) each pillar is made up of...
Dashboard week – Day 3
For day 3 of dashboard week out task was to tell a story about Australian taxation data. For my story I decided to focus on all the data related to student HELP loans to ultimately find which professions get compensated the most for their degrees. Data Prep I wanted...
Dashboard Week – Day 1: Melbourne City Council Customer Service Requests
Dashboard Week - Day 1: Melbourne City Council Customer Service Requests The first day of Dashboard Week is finally here. We’ve been hearing about this week from past cohorts and trainers since the beginning of training. Now that it’s here I’m feeling more ready than...