My analysis projects
Murder Data Analysis
A an exploratory analysis in Python, using open source FBI data provided by murderdata.org, and population data from the U.S. Census Bureau. Final deliverable is a Tableau Storyboard.
Marketing Strategy for an Online Grocery Store
A Python analysis, using open source data provided by the online grocery store company Instacart, supplemented with fictional data from CareerFoundry. Final deliverable is an Excel report.
Answering Business Questions for an Online Video Rental Company
A SQL analysis, using fictional data provided by CareerFoundry. Final deliverables include a data dictionary, a Google Slides presentation, an Excel file with SQL queries for technical colleagues, and visualizations in Tableau.
Preparing for Flu Season in the U.S.
An Excel analysis using flu death data from the CDC and population data from the U.S. Census Bureau to help a fictional medical staffing company prepare for the upcoming flu season. Final deliverable is a Tableau story board.
YouTube Ad Data KPI Dashboard
A challenge from Silvertone Analytics using an Excel file of YouTube ad data. The final deliverable is a KPI dashboard in Tableau.
Video Game Sales Trends Analysis
A descriptive analysis, using Excel. The data for this analyis was taken from VGChartz, an industry research firm. The final deliverable is a PowerPoint presentation.
Health Analytics Code Debugging
A basic SQL debugging exercise to answer business questions about Health Co users