Udacity DAND Project1 - Explore Weather Trends

Udacity Data Analyst Nanodegree Project 01 - Exploring Weather Trends using MS Excel and SQL

Description

Analyze local and global temperature data and compare the temperature trends where I live to overall global temperature trends.

• Create a visualization
• Prepare a write up describing the similarities and differences between global temperature trends and temperature trends in the closest big city to where I live.

Steps

1. Data Extraction

   • Use SQL to extract the data from the database

2. Data Manipulation

   • Use MS Excel to calculate moving average

3. Data Visualisation

   • Create line chart with MS Excel

4. Observation

   • Use line chart to make observation about the similarities and differences

Files

• SQL-queries.sql contains the SQL query used for this project with step by step explanations of what I did.
• Extracted-Singapore-&-Global-Avg-Temp-Data.xlsx is the result from running the SQL query above with moving average calculated.
• Project1-Explore-Weather-Trends.pdf is the final report.