Vincent Ging Ho Yim
Vincent has always enjoyed learning new things as well as finding elegant and efficient solutions to problems since childhood. He studied linguistics at university and has subsequently worked in theatre lighting and broadcast captioning. In his previous job he found his passion working with data and decided to pursue a change in career. In his spare time he likes reading, learning languages (both human and programming ones) and playing Pic-a-Pix and sudoku. He loves laksa, sushi and burritos.
Solving days 6 to 10 – 25 Days of DAX Fridays! Challenge edition 1
Let's continue with the 25 Days of DAX Fridays! Challenge from Curbal. In this post I'll go through how I solved the questions for days 6 to 10. For more background on the overall challenge and the NorthWind data model, refer to the first post in this series:...
Useful resources for the PL-300 Microsoft Power BI Data Analyst exam
After several weeks preparing for the PL-300 Microsoft Power BI Data Analyst exam, last week I sat the exam and passed. Here are some resources I found useful. Microsoft Learn – Learning Paths in the ‘Self-paced’ section...
Solving days 1 to 5 – 25 Days of DAX Fridays! Challenge edition 1
While preparing for the Microsoft Power BI Data Analyst exam, I came across the 25 Days of DAX Fridays! Challenge from Curbal, a popular Power BI learning resource platform. There have been two editions of the challenge so far. I spent some time last week completing...
Dashboard Week day 5 – A glimpse into the Japanese Grand Prix
Coming to the end of Dashboard Week, on day 5 we worked with data on Formula One racing. Off we went back into the world of Tableau! See other posts in my Dashboard Week series: Dashboard Week day 1 – The Ascent of Starlink Dashboard Week day 2 – From the best to the...
Dashboard Week day 4 – The more you know, the happier you are?
On to day 4 of Dashboard Week! We had an inkling that one day this week we'd have to create a dashboard in Power BI instead of our usual tool of choice Tableau. This was the day. Unlike the rest of my cohort, I haven't actually had the chance to work much with this...
Dashboard Week day 3 – Can I park on the street near where I want to eat out? (City of Melbourne)
Day 3 of Dashboard Week brought with it a new set of challenges – namely, spatial data. We were free to pick any datasets we liked from the City of Melbourne Open Data website. The aim was to build a dashboard that would help the user make a decision, and spatial...
Dashboard Week day 2 – From the best to the not so good superannuation funds in Australia
On day 2 of Dashboard Week, we worked with annual fund-level superannuation statistics. The data ranged from 2004 to 2022 and came from the Australian Prudential Regulation Authority (APRA). Applicants for the next Melbourne cohort, DSAU22, who made it to the final...
Dashboard Week day 1 – The Ascent of Starlink
Finally, here comes the (in)famous Dashboard Week! On each day this week our cohort (me and the other eight of us) are given a fresh new dataset to cast our eyes on. The goal is to produce a dashboard on the data by the next morning. See other posts in my Dashboard...
Sharpen your regex skills with Regex Crossword
As a data analyst, you often have to turn input data into a consistent format in order to perform further analysis. Regular expression, or regex for short, is a commonly used tool for parsing text input. Learning regex may seem daunting at first because of its syntax....