Python Data Analysis and Visualization
Over the course of the covid-19 pandmemic several media platforms, governments, and even the World Health Organization have been pointing fingers at China with accusations of intentionally underreporting covid data. What does the data say? Is it just politics? China is the most populous country on the globe. Underreporting would greatly skew international understanding of infection rates resulting in more infections, deaths, and lowered precautions. The aim of this project is to provide an unbiased analysis of the data in comparison to actual events.
Data Cleaning, Analysis, and Dashboard in Excel
DIVVY is a bikeshare company aiming to convert casual users to annual members. Excel is used to clean, analyze, and create a dashboard to find out how. Further analysis and a storyboard is created in Tableau.
In this project SQL Server is used to clean raw housing data detailing real estate transactions in the Nashville area to make it more usable for analysis.
Data Exploration With SQL
In this project NFL data is web scrapped, cleaned, and prepped in Excel then imported into SQL Server for exploration. Looking at players production in the terms of a standard fantasy points scoring system, AAV per production unit, and any correlations to team success.
Tabeleau projects with interactive dashboards and storyboards across varying datasets.
In this project python is used to create a webscraper to compile pricing data from Amazon with automated email for notification of when a product hits a target price.
Data Exploration With SQL
In this project SQL Server is used to explore Johns Hopkins global covid-19 data.