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.
How To Use The Email Tool In Alteryx
This is part 3 of my series on the ordering and invoicing system I made using Google Forms and Alteryx. In the last post we went through how the app functions using advanced app chaining, which you can see here. Today we're going to go through how to use the email...
Ordering and Invoicing System Using Google Forms and Alteryx: Part 2 – Advanced App Chaining
Last time I introduced the ordering and invoicing system I made using Google Forms and Alteryx analytical apps in order to sell fruit and vegetables in a real world setting. If you haven't checked out part 1 you can see it here. In this post we'll go through the...
Ordering and Invoicing System Using Google Forms and Alteryx: Part 1 Google Forms
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...
Lessons From Dashboard Week: Story
A week and a half ago we finished dashboard week. A week of ultra high intensity dashboard creation, with a dashboard and blog to be created each day. While it was very challenging, and resulted in more than a few of late nights, it was a fantastic way to fine tune...
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...