John Fan
John Fan is a highly driven individual with a diverse background and a passion for data analysis. Originally from China, John has spent nearly two decades living in Australia, immersing himself in the cultural and professional landscape of the country.
John’s completed a Bachelor’s degree in Commerce and later pursued a Master’s degree in Management & Marketing at The University of Melbourne. After graduating, John embarked on a career in a high-tech coal energy company which caused him to develop a keen interest in working with data.
In his spare time, he enjoys spending time with his family, playing table tennis and video games like Dota2.
Dashboard Week Day 4: API – SpaceX
Second last day of the dashboard week! Time flys! Introduction Today's challenge is to obtain data through API and then make it into a dashboard. We were initially given data about Prime Minister transcripts, but unfortunately, the access to the data is blocked and we...
Dashboard Week Day 3: Star Trek data collation
It is now Day 3 of the dashboard week! Introduction The data for today is about Star Trek. There have been so many pieces of media for this IP. TV, movies, books, and comics written and developed over the last 50 years. Our aim is to figure out a way to keep track of...
Dashboard Week Day 2: CPU & GPU evolution
Here comes Day 2 of the dashboard week! Introduction Today, we are provided with a dataset about CPUs and GPUs that have been released over the last 20 years. We are missioned to visualize the evolution of technology developments with CPU and GPU. We also need to...
Dashboard Week Day 1: Crime in Los Angeles
The exciting dashboard week finally starts! Introduction What an exciting dataset to start with! Today, we are provided with Los Angeles crime dataset. The dataset includes crime cases recorded by the Los Angeles Police Department from 1 Jan 2020 to July 2023. It has...
How to use Soundex in Alteryx to correct misspelling/typo?
When dealing with text data such as e-mails, it is common that people misspells or make typos. We do not want to exclude them and it is also difficult to exclude them when there are lots of data. The Soundex function in Alteryx could help us to solve the problem. How...
Creating Dynamic API Input using API Output
On the second week of learning Alteryx, we learnt how to use API to extract data from websites. When creating Analytical APP from Alteryx, we often use the Drop Down tool to allow the user to select from a list to filter and view the result. To input the list, it is...
How to Dynamically rename multiple columns in Alteryx
When it comes to column headers, it is either already there or we would manually type it in (e.g. with formula tool to create new columns; use select tool to rename columns etc.). What if we need the column names to be dynamic from another input? Let's start with an...
A tip for first week Alteryx presentation
As you may know or may not know, with a week of exposure to Alteryx, we will be doing a presentation on the Friday. Alteryx presentation is somewhat different to a typical presentation with Tableau where we can show all the fancy charts and graphs. With Alteryx, we...
How to do Top N for each category
Hello everyone In Tableau, we can do Top N in the filter to view the Top N items (e.g. Categories) based on the measure we select (e.g. sum of sales). What we will get is the Top N items across the entire dataset. But what if we want to see the top 3 items for each...