Featured Projects
March Madness Tournament Simulation & Probability Analysis
Built a Monte Carlo simulation in R to model NCAA tournament outcomes across 1,000+ iterations. Developed custom probability matrices using historical matchup data, comparing linear vs exponential models against real tournament results. Created visualizations showing seed performance distributions and analyzed why #1 seeds win at twice the rate of #2 seeds. Explored conditional probability approaches for predicting tournament outcomes.
Detroit Crime Patterns & Neighborhood Analysis
Analyzed 2024 Detroit Police Department crime data to identify patterns in criminal activity across neighborhoods and time periods. Created visualizations showing crime distribution across zip codes, temporal trends, and case status over time. Built heatmaps and comparative charts examining how different offense types cluster in specific neighborhoods. Explored geographic and temporal factors affecting case resolution rates.
Automated Sales Intelligence Dashboard
Developed automated Power BI reporting system connecting Snowflake data warehouse through macro-enabled Excel files. Built data pipeline to track sales pipeline metrics, product performance, and regional KPIs with weekly automated refresh cycles. Implemented DAX measures for dynamic calculations and created drill-down capabilities for multi-level analysis. Reduced manual reporting time and enabled real-time business intelligence for decision-making. (Corporate project - visualizations not shown due to confidentiality)