Udacity Data Analytics Nanodegree Project 01 - Exploring Weather Trends using Excel and SQL
Selected cities: Istanbul (TR) & London (UK)
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.
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.
- SQL: Query was used to extract data from Udacity database.
- MS Excel: It was used to calculate moving average, plotting line chart and making observations.
- MS Word: It was used for writing project document.