Skip to content

Latest commit

 

History

History
57 lines (36 loc) · 3.38 KB

File metadata and controls

57 lines (36 loc) · 3.38 KB

Data Analytics Portfolio | EmyCodes 👋

Industrial Mathematics Graduate & Data Analyst


📊 Excel & Automation Projects

High-impact business solutions built with Advanced Excel, VBA, and Google Workspace.

📌 WPM-DWR-Automation-2025: Digitized a manual monitoring system for Word Point Ministries, transforming 92+ responses into a strategic dashboard.

  • Impact: Identified the University of Ilesa as the engagement lead (48 submissions) and isolated low-performing centers for strategic follow-up.

📌 WordAlive-Tracker-Testing: Automated community engagement tracking for 100+ members using custom Google Sheet pipelines.

  • Metric: Segmented users by 50% and 60% submission rates to provide data for targeted retention strategies.

🗄️ SQL & Relational Database Projects

Relational database management, complex data extraction, and urban analytics.

📌 Chicago-Public-Data-SQL-Analysis: Engineered a relational database to investigate the intersections of crime, education, and socioeconomic conditions.

  • Technical Achievement: Solved 10 complex relational problems using subqueries and joins with 100% accuracy.
  • Strategic Insight: Quantified the correlation between hardship indices and crime concentration, identifying Austin as the primary crime-prone hotspot.

📌 Retail-Sales-SQL-Analysis: (Upcoming): Using MySQL to perform window functions and CTEs for sales performance reporting.


🐍 Python & Research Projects

Exploratory Data Analysis (EDA), Interactive Dashboards, and Mathematical Modeling.

📌 Automobile-Sales-Analytics: Developed an interactive web dashboard to analyze 40 years of automobile sales data across recession and growth periods.

  • Technical Achievement: Engineered a reactive callback system in Dash to toggle between "Recession Period" and "Yearly" statistics.
  • Strategic Insight: Identified a 4–5% unemployment threshold that triggers a demand collapse in premium vehicle segments.

📌 Python-Stock-Revenue-Analysis-2026: Automated extraction and visualization of live stock price and revenue data using APIs and web scraping.

  • Strategic Insight: Quantified the historic decoupling of GameStop (GME) stock price from fundamental revenue during early 2021.

📌 Global-Fitness-Market-Analysis: Time-series analysis of search trends (2018–2023) to identify market hotspots in the US and Philippines.

📌 Numerical-Methods-Modeling: Order 6 numerical algorithm development for ODEs—the foundation of my analytical precision.


📈 My "Practice to Perfection" Journey

I am a 3MTT Fellow and ForbesBLK Member dedicated to technical excellence in Data Analytics. I focus on "learning in public" by documenting technical workflows, data integrity processes, and automation logic.


📫 Connect with me:

  • LinkedIn: linkedin.com/in/emycodes
  • Role Interests: Data Analyst, Business Intelligence Analyst, Product Analyst, Operations Research.

"Data is most powerful when it serves as a clear, honest bridge between raw numbers and strategic growth."

©️ EmyCodes | 2026