by Yi Gao | Mar 20, 2024 | The Data School, Yi Gao
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...
by Yi Gao | Mar 20, 2024 | The Data School, Yi Gao
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...
by Yi Gao | Mar 18, 2024 | The Data School, Yi Gao
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...
by Yi Gao | Mar 18, 2024 | The Data School, Yi Gao
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?...
by Yi Gao | Mar 8, 2024 | Yi Gao
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...
by Yi Gao | Mar 7, 2024 | The Data School, Yi Gao
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...
