Data Analytics Projects
Welcome! These are the most recent projects that I've worked on. Each project has a high-level overview of the tools and skills I used.
Layoff Logic
Examining Age & Tenure in Workforce Reductions with R
R | HR Layoff Analysis
​
â—¾ Analyzed employee demographics and layoff data using R.
â—¾ Created boxplots, scatter plots, and correlation matrices to visualize potential biases.
â—¾ Performed Welch Two Sample t-tests to statistically assess claims of ageism and tenure-based discrimination in layoff decisions.
Decording Turnover
Data-Driven Insights Into Retaining Top Talent
SQL & Tableau | HR Analytics
​
â—¾ Analyzed a synthetic HR dataset to identify drivers of employee turnover.
â—¾ Used SQL to explore performance ratings, department-specific termination rates, and overtime impact.
â—¾ Built a Tableau dashboard to visualize key findings and present actionable insights to the COO.
Charting The Course
Data-Driven Strategies for MA Schools
Tableau | Data Visualization
​
â—¾ Created a dashboard evaluating 1,800 different schools' performance across 100's of features
â—¾ Used Scatter Plots, KPIs, Bar Plots, & Area charts to visualize performance differences
â—¾ Presented dashboard to stakeholders via recorded video
The Data Behind The Dollars
An SQL Look at World Bank Loans
SQL | Exploratory Data Analysis
​
â—¾ Data-mined 1.2M real bank transactions to find financial outliers, patterns, & trends
â—¾ Used SQL clauses such as SELECT, WHERE, FROM, GROUP BY, AVG, MIN/MAX, SUM, AND, etc
â—¾ Created written report highlighting findings
The Data Behind The Discharge
Analyzing Hospital Data with SQL
SQL| Exploratory Data Analysis
​
â—¾ Analyzed what affects hospital stay length in MySQL
â—¾ Created a histogram using SQL (weird, I know)
â—¾ Real data from over 101,000 hospital patients
From Foul Outs To Findings
Analyzing NBA Data
Tableau | Dashboarding
â—¾ Analyzed the 2022 NBA season statistics
â—¾ Created Stacked Bar Charts, Heatmaps, Treemaps & Bubble Charts
â—¾ Built a Tableau story & shared via written report
From Ore To Iron
Analyzing Metal Extractions With Python
Python | Dashboarding
​
â—¾ Analyzed time-series data from an iron ore mining operation.
â—¾ Created line plots, scatter plots, and correlation matrices to visualize variable relationships.
â—¾ Identified a significant inverse correlation between Silica and Iron concentrate, pinpointing a critical anomaly on June 1st, 2017.
