Mark Long
Holding a Bachelor of Computer Science and coming from an IT background, Mark’s love of data can be traced back long ago to his Software Developer career stage. Dealing with SQL database, writing SQL to help troubleshooting the coding outcome had been his daily task. Also, before joining The Data School, Mark had over 3+ years’ experience in teaching Scratch and Python coding for children. By creating and constantly refining the course contents, his logical thinking ability had been further elevated, helping him gain more readiness in his new data analysis adventures. By joining The Data School, he found the catalyst for his passion for finding insights from complex data and solving technical challenges.
When away from the screen, Mark loves exploring the lakes and beaches for a productive fishing spot. He also enjoys gardening, cooking, and travelling, and won’t miss a change to have relaxed chats and walks with friends.
Thoughts and Reflections from DSAU 15
As the four months of training at The Data School Down Under draws to an end, each member from cohort DSAU15 offers their thoughts, reflections and advice on their training. In no particular order: Mark's simple, yet meaningful tip When first seeing a new dataset,...
Creating Dynamic Tooltips in Tableau
During a client project week in The Data School, I had this task of creating dynamic tooltips on a cross table in Tableau. By saying dynamic tooltips, I mean three goals to achieve for this project. Tooltips only show for a specific column in the cross table. Apart...
Dashboard Week Day 5 — AFL Data: A Use Case for Curved Timeline
We have the AFL data for our last day in the Dashboard week. It has the data of win or lose for each game in the last ten years, which make this dataset a perfect use case for a curved timeline chart. So let's have a look of the finished dashboard first. The dashboard...
Dashboard Week Day 4 — Renting Guide by Census Data
On the 4th day of the dashboard week, we are working on the 2021 Census data from ABS. Although we have worked with this data set during the training, to finish this challenge we still need a lot more work to be put into data exploring and data cleansing. Preparing...
Dashboard Week Day 2 — CPI and Wages
The second day of the Dashboard week saw us working with CPI and Wages data from the ABS. ABS has a unique way to organise their data, whcih demands a data preparation process before you can start analysing the data. So here I will first talk about the Alteryx...
Dashboard Week Day 3 — Working with the Star Wars API
The data we get for dashboard week day 3 is the Star Wars data from the online API. The API has the data related to the first two trilogies of the Star Wars Movies. We can find the data for all the six movies, including the films themselves and the People, Planets,...
Dashboard Week Day 1 — Global Power Plant
Finally we are here, the Dashboard week. A dashboard challenge each day. Day 1 we have the Global Power Plant dataset to work with. I'll break this blog down into two parts to summarize the key things I did to make the dashboard for this analysis. Data preparation In...
A Solution for the Alteryx Weekly Challenge #13 using the Regex Tool – Part II: Rest of the Workflow
After we've made the Regex expression ready, we can then put it into a Regex Tool. Since the result is just a sequence of Strings, the easiest way to store them is by doing a Tokenize action and split the different string into rows: As we can see...
A Solution for the Alteryx Weekly Challenge #13 using the Regex Tool – Part I: The Regex Expression
1. The objective of the Alteryx Weekly Challenge #13 Following is the description from the Alteryx Weekly Challenge Page. The objective of this challenge is basically a Web Scraping by Alteryx, grabbing a table's content out from a web page. The use...
Alteryx first encounter – Reflection on what I’ve learned the first week in The Data School
For most of us new Data Schoolers, the first week learning was both challenging and fun as we had the first encounter with a whole new tool - Alteryx. Thanks to our amazing coaches, all of us were able to produce a meaningful workflow to present in our first...