Alex Chan
Alex has a background in Engineering, having attained a Bachelor’s degree in Renewable Energy Engineering, as well as a PhD for his work on solar cells. He enjoyed analysing research data, but did not want to pursue an academic career. Drawn by the analytic potential of Tableau and Alteryx, he applied to the Data School. In his free time, Alex enjoys playing real-time strategy games and planning his next travel.
Prep-ping for the S(e)Q(ue)L to my Tableau & Alteryx Experience
I recall a time not long ago, where Microsoft Office and basic charting software were the limits of my data visualisation skills. A chance encounter with an ad about the Data School program led me down a journey of discovery. Having learnt about Tableau mere...
Reconstructing Coordinates in Different Frames of Reference
If you haven't read Part 1 of this blog post, check it out here I recently worked on a client project where I converted latitude and longitude (GPS coordinates) into a customised coordinate system. The new coordinates must reflect distances and direction...
Converting GPS Coordinates to a Customised Coordinate System
The inspiration for this series of blog posts came from a recent client project where I had to convert latitude and longitude (GPS coordinates) into a customised coordinate system. The new coordinates had to reflect distances relative to an origin point. In...
Tips on Visualising in Power BI
Whilst Tableau is the focus of training at the Data School, we also learn Power BI. A couple of my colleagues have also written blogs on using Power BI. I recommend this blog on switching measures and titles dynamically. In this blog post, I explore...
Downloading Google Analytics Data in Alteryx
In today's blog post, I will provide a general guide to using the Google Analytics Tool in Alteryx. In addition, I discuss how and why I used a batch macro to download Google Analytics data as well as common error messages encountered using this tool. ...
Dashboard Week Day 5 : Museum Revenue in the US
On Day 5 of Dashboard week, we were given a data set from Enigma Public. This website contains a broad collection of public data. In the data set is general information of museums and related organisations in the U.S. I found the initial data lacking in terms...
Dashboard Week Day 4 : Visualising Demographics and Energy Usage via World Bank Open Data
Following on from yesterday's theme, today's challenge is to prepare a dashboard using only Tableau Prep and Tableau. The data sets come from the World Bank Open Data website. I started the day by first deciding on a preliminary objective. This was important to...
Dashboard Week Day 3 : Surviving the Titanic Task of Visualising in Power BI
To bolster our skills in Power BI, day 3's challenge is to prepare and manipulate the Titanic data set using Power BI. This is then followed by visualising this maritime disaster via Power BI. An extra challenge was to find a way to determine what would happen if...
Dashboard Week Day 2 : Punting on Racehorses with Alteryx and Tableau
Day 2 of dashboard week has arrived. In today's challenge, we have to scrape data on horse racing statistics from a selection of sports betting websites. I used this website to scrape data for (hopefully) predicting the outcome of the Melbourne Cup race. Compared to...
Dashboard Week Day 1 : Lessons Learnt in Timeboxing
On the first day of Dashboard week, we were tasked with scraping data from the Transport NSW website and finding insights that can be visualised in Tableau. A wide variety of content exists on the website. This includes live road and maritime traffic data as well as...