Ethan Tai
Ethan had already generated his passion for data during his schooldays when he had a school project in exploring Google Data. He’s got a double degree in Commerce and Information System from University of New South Wales. He used to play basketball but now he watches it as his hobby. He’s got some interesting story behind why he’s become a huge fan of Charlotte Hornets. He chose to support them because they were the worst team in the league when he first go into the sport. His favorite player is Stephen Curry. He loves to eat chocolates and would eat them for the rest of his life if he could. He’s visited many countries and he also likes to play video games.
Dashboard Week – Season Finale
The final day of dashboard week is upon us! Today we were given data from the Food and Agriculture Organization of the United Nations (FAO). The data received was about the prices of agricultural goods. Data Preparation The data we were given was given in a...
Dashboard Week Day 4 – Legatum Prosperity Index
Dashboard week day 4. Unlucky for some. Unlucky for me since I was flooded in at home. The data received for today was from the Legatum Prosperity Index, a measure of the overall quality of life in different countries. Data Preparation The dataset from Legatum...
Dashboard Week Day 3 – London Fire Brigade
For today’s challenge for dashboard week we were given data about calls made to the London Fire Brigade. We were tasked to supplement some other data about London and make a dashboard out of it. For me, this was a lesson in knowing when to give up. When I first looked...
Dashboard Week Day 2 – YouTube Trending
For day 2 of dashboard week, we were given data based on the trending YouTube videos in various countries. With this data, I decided to take an interesting focus. I supplemented data of the members from Hololive Productions, a V-tuber talent group. To avoid this being...
Dashboard Week – Day 1
It’s finally here! The infamous Dashboard week. Although personally I wasn’t dreading the coming of Dashboard week as I quite enjoyed presentation days. For me it was more of a mild excitement. For the first day we were tasked with making a dashboard out of the...
Tips for Presenting an Alteryx Workflow
When presenting a dashboard in Tableau, it’s can be easier to see or to tell the story in the data. In Alteryx, most of the screen is icons connected by lines. So how do I present this to someone? Especially if I don’t have a dashboard to show from it? Well, here are...
Tips for Joining Data – Prevent Unwanted Data Loss and Data Duplication
Joins are an essential part of data preparation. In addition to that they are essential to do correctly otherwise data is lost or duplicated. Here I will outline some issues that can occur when joining data and some tips to fixing them. Data Loss This occurs when...
Using Batch Macros in Alteryx to Union Difficult Data
This week at the Data School we learned about Batch Macros. These can be used to union sheets of data that don’t easily come through in a wildcard union. With this knowledge I decided to revisit one of my first presentations at the Data School where I tried to merge...
Differences between Tableau Prep vs Alteryx
Tableau has released its own data preparation tool called Tableau Prep. How does it fare against Alteryx? Advantages of Tableau Prep over Alteryx Grouping similar rows is much easier in Tableau Prep When you want to group similarly spelt rows together in Alteryx, you...
My First Week at The Data School
After a long time of waiting, the first day of my Data School journey had finally arrived. And what a week to kick it off! Day 1 – the introductions The first day was all about introductions. Introductions to the people in the cohort, introduction to the coaches,...