Yi Gao

User banner image
User avatar
  • Yi Gao

Posts

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

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

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

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

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

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

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

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

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

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