This portfolio project demonstrates SQL queries, Python, and visualization with Tableau. The queries are called in python code as strings, but also supplied here in a separate SQL file for easier visualization. Dataframes are exported as csv and loaded into Tableau.
SQL | Python | Tableau
The SQL queries are running on the public weather data provided by NOAA, the Global Surface Summary of the Day Weather Data in BigQuery. I'm using this data to focust on the heatwave that occurred in western Canada in 2021. You can read more about the heatwave on Wikipedia.
- Find all the stations in Canada (basic query)
- Get temperatures in Lytton, BC and Kamloops, BC during June and July 2021 (JOIN, LIKE, BETWEEN)
- Get historical max temperature per month, historically, for Lytton stations (UNION)
- Check the date and temperature on Lytton's hottest day (nested query)
- Count the days for all stations in Canada where the temperature was 35 or greater (window function)
Interactive version on Tableau Public
