Skip to content

Latest commit

 

History

History
26 lines (19 loc) · 1.08 KB

README.md

File metadata and controls

26 lines (19 loc) · 1.08 KB
Raw

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.