Subnational Economic Resilience
Classified 117 Philippine provinces and cities into two resilience typologies using seven years of official economic accounts — validating the structure with MANOVA before clustering.
Case studies in data cleaning, reporting, SQL analytics, dashboard design, and workflow documentation. Each project includes the problem, approach, tools used, and output.
Classified 117 Philippine provinces and cities into two resilience typologies using seven years of official economic accounts — validating the structure with MANOVA before clustering.
An end-to-end Python pipeline that cleans a messy real-estate lead export, measures marketing ROI by source, and ranks leads into a data-driven call-first list — built on synthetic data to protect private records.
Data Engineering Structured a movie analytics dataset by cleaning nested metadata, organizing entities, and documenting the workflow for reporting use.
Dashboard Analytics Built a sales performance dashboard for a $5M+ dataset to review revenue trends, discount behavior, and category performance.
SQL Analytics Used MySQL, CTEs, and window functions to analyze customer behavior, revenue patterns, and retail performance.
Statistical Data Cleaning Audited and repaired missing, invalid, and outlier values in a healthcare dataset while keeping the cleaning process documented.