Xiaoyan (Ivy) Yin

Ivy graduated with Master of Professional Accounting from Macquarie University and discovered the power of data analytics during an internship. A friend told her about the Data School, and she did not think twice about applying. She fell in love with Tableau during the application process and has not looked back since. When Ivy is not automating workflows or creating beautiful visualizations, you can find her on the beach or in the bush hiking, while listening to her favourite K-pop songs. Ivy loves the diversity of food Sydney has to offer but in her opinion nothing beats the traditional Cantonese food.

Regex for Data Parsing

Regex for Data Parsing

I’ve been learning Regex Tool for the previous two days. It is not an easy tool, but once you know how to use it, it can save you much energy in data preparation. Here’s how I learn Regex. Watch all interactive video in Alteryx. (It is very helpful to understand the...

Reflective Blog in The Data School Down Under

Reflective Blog in The Data School Down Under

Can’t believe it’s the last day of our four-month training. I can still remember how excited I was when I applied and got accepted for The Data School. The application period was very anxious and nervous but I got a sense of fulfillment during the interviews were...

Dashboard Week Day 3. Kickstarter Projects

Dashboard Week Day 3. Kickstarter Projects

It’s the third day of dashboard week! Different from the previous two days, the task for today is mainly about visualization. For today’s challenge, we need to 1st download 2 data sets of Kickstarter Projects from Kaggle 2nd prepare data in Tableau Prep instead of...

Dashboard Week Day 2. Pirate Incidents from 2000 to 2019

Dashboard Week Day 2. Pirate Incidents from 2000 to 2019

Here comes the second day of the dashboard week. In today’s challenge, we are given a link to download the data for piracy activities. The challenging part for me is to find the supplement data and include Mapbox map into the viz.   Downloading Data   The...

Dashboard Week Day 1 – Spotify API

Dashboard Week Day 1 – Spotify API

Finally comes the much anticipated Dashboard Week! For the first day challenge, our task is to download data from Spotify using API and make a visualization out of it. Because I don’t have Spotify account, Junya generously shared her account with me. Therefore I...

Tableau Tips 1

Tableau Tips 1

In data school training, one of the most inspiring part is when cohort members share their visualisations, especially Makeover Monday. Even though we all use the same dataset, very often that we analyse them in different perspectives. We may not notice detailed...

Building Dynamic Bar Charts with Time Period Selections

Building Dynamic Bar Charts with Time Period Selections

Recreating dashboards is a very good way to practice Tableau skills. This blog post is about the key take away from Workout Wednesday week 2 in 2020 - how to create date selection parameters with last 12 months, last 13 weeks and last 14 days based on today’s date –...

Order of Operations – Context Filter

Order of Operations – Context Filter

We learned Level of Detail (LOD) in Tableau before Christmas holiday. During the whole training, Peter, our trainer, kept strengthening the importance of ORDER OF OPERATIONS (Click for more info). Because I want to figure out what each operation represents, I did some...