Frank Salmon
Before joining The Data School, Frank worked in the insurance industry – specifically in recoveries for motor vehicle claims. However, it was during his honours year in Psychology at UNSW that Frank discovered the power of analytics and his passion for data. This lead to an ambition to change careers and join the Data School. When Frank isn’t working, he enjoys running and playing music on the piano and guitar.
I made an Ordering and Invoicing System Using Google Forms and Alteryx: Part 1
I'm excited to share what I've made. As the title suggests I've created an ordering and invoicing system, which is currently being used with my friend's hobby business. The customer can use google forms to place an order, then in the backend, I've created an...
Dashboard Week Day 5: CLUE Melbourne Data
It was Friday and it was the last day of Dashboard week! Today's Challenge was all about Spatial data from the Census of Land Use and Employment (CLUE) for Melbourne. I was looking forward to brushing up on spatial analysis. This time we only had 6 hours from the...
Dashboard Week Day 4: Lewis Hamilton Vs Michael Schumacher
It was Thursday and I had a decent nights sleep, considering the quality of the other nights that week. Todays challenge was the Tableau web edit challenge. The rules were simple: Build a dashboard using only Tableau server Can’t use Tableau desktop Alteryx permitted...
Dashboard Week Day 3: Planes Falling of the Sky
Planes dropping out of the sky! Today’s Challenge was to web scrape the database of http://www.planecrashinfo.com/database.htm. This included many pages of fatal crashes across the length of aviation history. This pleasant topic surely won’t induce certain phobias....
Dashboard Week Day 2: Japanese vs Scottish Whiskies
Our second day of dashboard week fell on Melbourne cup day. So what would be more appropriate than a dataset on whisky sales? Today was the API challenge, and so the task was to download the data from the Whisky Hunter API, prepare and then visualise a dashboard. Data...
Dashboard Week Day 1: Diversity of Australian Charities
Today was the first day of dashboard week. And what better way to start than analysis of Australian charitable organisations. Feel free to check out the data here. The dataset classifies the charities based on what their promoted cause is, and also has info on target...
Understanding Fixed LODs: Helpful Links
While I was preparing for my Tableau Desktop certification exam, I decided to go over a topic that went a bit over my head during training, fixed LODs. LODs (level of detail calculation) are a somewhat advanced topic in Tableau, but they are vital for certain purposes...
Web Scraping with Power BI
This week was my first introduction to Power BI. It's quite different to Tableau, with some things coming surprisingly easy like filter actions and other things harder, such as the unfamiliar syntax's DAX and M. However what I was impressed by was the ease of its...
Using Parameters to Switch Between Views – A Beginner Guide
In Tableau a parameter is a tool that can be used to add interactivity to a view or dashboard, allowing the audience to explore the data for themselves. They can also be used to help organise a dashboard. Today we’ll be looking at using parameters to switch between...
The Data School: Lockdown Style
I've just completed my first week of The Data School, DSAU10! I've been introduced to the company and my peers, and yet I have never set foot in the Sydney office. Such was the timing of the Sydney Covid Lockdown. The Challenges of Online Learning Being brand new...