Skip to content

Latest commit

 

History

History
17 lines (13 loc) · 1010 Bytes

README.md

File metadata and controls

17 lines (13 loc) · 1010 Bytes
Raw

UdacityProject_ExploreWeatherTrends

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

Selected cities: Istanbul (TR) & London (UK)

Overview

I am from Turkish Republic and live in London, United Kingdom. I defined the cities of this project as Istanbul where I was born and London where I live in. I have analyzed the local temperatures of Istanbul and London in accordance with global temperature date and compared them by using Udacity database portal. I have extracted, managed and visualized the data as shown in the following goals.

Goals

Step 1. Extracting the data from Udacity database portal and exporting to CSV file. Step 2. Making a chart visualization on extracted data from database. Step 3. Observations based on schema.

Tools

  1. SQL: Query was used to extract data from Udacity database.
  2. MS Excel: It was used to calculate moving average, plotting line chart and making observations.
  3. MS Word: It was used for writing project document.