⬆ Back to Featured Projects

Data Analytics Project — DePaul University Admissions Dataset

Role: Team Member — Team 10 (9-person cross-functional data analytics team), Data Analytics Internship · April 2026

Project Overview

A 3-week data analytics project transforming a raw admissions dataset of 7,543 applicants across 95 countries and 132 programs into a strategic roadmap for recruitment, counselor engagement, and admissions optimization for DePaul University.

My Role

Team member on a 9-person cross-functional analytics team, contributing to data cleaning and dashboard build.

Key Responsibilities

• Diagnose data quality issues across an 80-variable admissions dataset
• Execute a staged data cleaning process (pruning, parsing, normalization, imputation, deduplication)
• Contribute to building an interactive Power BI dashboard
• Translate findings into strategic recommendations

Tools Used

Power BI · Data cleaning and analysis tooling

Key Deliverables

• 5-step data cleaning pipeline (see table below)
• 5-page interactive Power BI Dashboard
• Strategic recommendations report

Data Cleaning Pipeline