Data Analysis Projects

Here are my data analytics projects! Many of these were completed during my DA certification, and others from personal projects. Feel free to navigate to these projects using the table of contents or scrolling down.

Table of Contents

Boston Winter Weather Analysis

Skills Used: Tableau | Python | Excel | Data Sourcing | Data Cleaning | Presenting

Data Analysis Capstone Project.

Looked at a century of Boston-weather data to identify if there have been any recent changes in snowfall and winter weather. Extracted data from Visual Crossing and NOAA weather databases. Final findings suggest that recent years are displaying a contraction in the winter season.

Wind Power Investment Data Sprint

Skills Used: Agile Methodology | Trello | SQL | Python | Market Research

Conducted market research on wind energy market and production as part of 4-day data sprint

Wrangled over 63,000 rows of EIA data on wind turbines in the US using SQL and Python

Presented findings for mixed, mostly non-technical audience to recommend best operators and wind energy projects for private investment.

Gender Pay Gap Project

Skills Used: SQL | Data Visualization

Queried 10,174 rows of self-reported gender pay-gap data available from gov.uk to identify patterns in company pay gaps.

Analyzed companies by industry and by payment quartile to identify differences in employee representation and pay by gender.

Used local knowledge to accurately interpret geographic differences in pay in and out of major UK cities as well as in and out of London City Square Mile.   

21st Century US Presidential Election Analysis Group Project

Skills Used: Tableau | Mapping

Cleaned MIT Election Lab data on county-level popular votes for 21st century US Presidential Elections. 

Visualized county-level and state-wide election results with maps and bar charts in Tableau to compare county-wide and popular votes in each state from year to year.

Developed Tableau stories and dashboards to convey data individually and in group presentation to supplement group analyses regarding population density and election results, as well as to display changes in voting patterns over time.

AirBnb Market Analysis in Thessaloniki, Greece

Skills Used: Excel | Pivot Tables | Data Cleaning

Cleaned and visualized over 3,700 rows of Inside AirBnB data from Thessaloniki, Greece

Analyzed short-term rental market to make recommendation for potential rental property investors.