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
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
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 5. 500 Cities: Local Data for Better Health
Finally, it is day 5 of dashboard week! I feel very productive this week – one dashboard and one blog every day. The biggest challenge for me is always in the morning when preparing the data. Throughout these days, the efficient way for me is to explore data form...
Dashboard Week Day 4 – Personal Consumption Expenditures
It’s the fourth day of dashboard week! The task for today is about the American Personal Consumption Expenditure. Based on requirements, we need to Download the data Clean & prepare data using Alteryx Find supplement data Make a visualization Data...
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
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
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
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
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
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...