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 4-NHL Playoff Games vs Regular Season

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 2-Household Crime Analysis

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

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,...