From CSV files to
an SQL Database
I created an SQL database using 4 different CSV files - with entries ranging from just 21, to 32 million.
From CSV files to
NYPD's Arrests in 2022 - a dashboard
This is a simple, and reuseable, dashboard to show the arrests the NYPD made in 2022.
This includes breakdown by Race, Crime, Month, Age/Sex and Borough.
Just add the latest dataset from the NYPD, and it updates.
NYC's CitiBike Customer Usage - 2020
This project placed me as an analyst for The Department of Transport in NYC where they wanted an analysis/overview of the CitiBike bike hire scheme for 2020.
Planning Healthcare staff for the 2018 Flu Season
Tasked with planning extra staff to cover the increase of patients during the Flu season. This included analysing for spikes in visitations recorded as due to Flu like symptoms.
instacart - Understanding their customers
The Instacart stakeholders want to uncover more information about their sales patterns. They are interested in the variety of customers in their database, along with their purchasing behaviours, in order to optimize their advertising strategy.
Rockbuster LLC
A movie rental company is shifting into online streaming and needs an analysis of their existing customer base, and
rental trends, to create an effective launch strategy.
My Tableau Visuals
My Reports and Dashboards, using 'Use as Filter', 'Actions', GeoJSON files and more types of charts
than you can shake a stick at.