Yi Gao
Yi has a master’s degree in data science from The University of Sydney and a background in engineering and manufacturing. She is passionate about finding insights from large and diverse datasets and applying them to real-world scenarios.
In her previous role at Daimler China, she analysed vehicle usage data, provided recommendations and created dashboard for internal customers.
In her spare time, she enjoys photography, especially of animals and her two sons, and cooking traditional Chinese food.
Dashboard Week Day 5-Oscar Award Category Analysis
Today is dashboard week day 5. Our task is to create a Oscar related dashboard and publish in Tableau Public. The data is ready to use without cleaning. As we only have several hours to prepare, my strategy is "First story is best story". In the data table, I find...
DAX-Which country won the most FIFA world cup champion?
Do you want to know which country win the most champions in FIFA world cup? I guess you can easily find the answer in the wiki page, but let's do it in a more complex way-DAX! You can download the data here. Step-1: Connect the data First, you need to connect to data...
Using Alteryx to get all Starlink satellites via SpaceX API
Do you consider subscribing Starlink? In this blog, we will use Starlink API to get all the satellites data. SpaceX API provides an all-in-one endpoint to query all Starlink satellites at one time, with no pagination, authentication etc. So, in the first "Text Input"...
Alteryx Webscraping Example: get all historical powerball data
Have you ever bought powerball? Do you know if you analyze the trend of the ball, you would get slightly higher chance of winning? Today, I will show you how to use Alteryx to get the historical powerball data in one table. What we need?...
Dashboard week day 4-NHL Playoff Games vs Regular Season
This is the 4th day in dashboard week. Today our topic is NHL ice hockey. Data Cleaning This is another Power BI dashboard, and the same as last one, I still clean the data in Power Query. However, I find that when dealing with large table (like the shots table in the...
Dashboard Week Day 3-The Hills Shire Library Program Analysis
Today is dashboard week day 3 and the data source we got today is Public Library Statistics (nsw.gov.au). The moment I got this data, I started to look for the data of the council I lived in. And my focus shifted from books to the program they had, as I always felt...
Dashboard Week 2-Household Crime Analysis
Today is the 2nd day of dashboard and the topic is crime data. We can select the topic from Crime and Justice data from ABS and the topic I choose is Crime Victimisation. From this data, the analysis aspect is just for the household crime in 2021-2022 which is the...
Dashboard Week-Twitch Top Game Analysis
Today is the first day of Dashboard week, and our challenge is getting data from twitch IGDB API, making a Tableau dashboard and publishing to Tableau Public. Twitch is an interactive livestreaming service that spans various content genres, including gaming,...
15 Examples of Tableau LOD – Population Difference
This blog is inspired by blog: Top 15 Tableau LOD Expressions (Practical Examples). Tableau LOD (Level of Detail) Expression is one of the most powerful tools to achieve amazing results in building dashboards. In this series of blogs, we will walk through 15 different...
15 Examples of Tableau LOD – Percentage of Total
This blog is inspired by blog: Top 15 Tableau LOD Expressions (Practical Examples). Tableau LOD (Level of Detail) Expression is one of the most powerful tools to achieve amazing results in building dashboards. In this series of blogs, we will walk through 15 different...