Data

King Stats – Foot Pressure Analytics & Shoe Recommendation

Senior Capstone building a smart foot-pressure mat to identify pressure patterns and translate them into shoe recommendations. I built the data layer: scraping shoe specs, cleaning/standardizing attributes, and designing a database + dashboard flow so sensor insights can connect to real product data.

Screenshots

Highlights

• Built a Playwright scraper to collect shoe specifications and normalize messy product text into consistent fields.
• Designed an analytics-ready SQLite schema that supports matching sensor outputs to shoe categories and attributes.
• Implemented cleaning + dedup logic in Pandas to keep refreshes stable and avoid repeated product records.
• Created stakeholder-friendly Power BI visuals to explore trends across shoe types and attributes.

Tech Stack