Skip to content
MN Mark Anthony Nene Data Manager · Data Quality & Reporting Systems
Home Projects Results About Contact Resume
Projects

Selected Data Projects

Case studies in data cleaning, reporting, SQL analytics, dashboard design, and workflow documentation. Each project includes the problem, approach, tools used, and output.

PCA scatter of two subnational economic resilience clusters (93 vs 24 units) Statistical Modeling

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.

RMANOVAPCAHierarchical Clustering
View case study → View the R analysis on GitHub
Lead funnel and ROI-by-source visualization for a real estate pipeline RevOps Analytics

Real Estate Lead Analytics

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.

PythonPandasData CleaningFunnel & ROI
View case study → View the code on GitHub
TMDb data engineering workflow architecture preview Data Engineering

TMDb Data Engineering Workflow

Structured a movie analytics dataset by cleaning nested metadata, organizing entities, and documenting the workflow for reporting use.

ExcelETLJSON ParsingDocumentation
View case study → View documentation PDF
360 sales performance dashboard preview Dashboard Analytics

Sales Performance Dashboard

Built a sales performance dashboard for a $5M+ dataset to review revenue trends, discount behavior, and category performance.

DashboardSalesInsightsExcel
View case study → View PDF
MySQL retail analytics workflow preview SQL Analytics

MySQL Retail Analytics Project

Used MySQL, CTEs, and window functions to analyze customer behavior, revenue patterns, and retail performance.

SQLCTEsWindow FunctionsAnalytics
View case study → View PDF
Pima diabetes data audit and repair preview Statistical Data Cleaning

Pima Diabetes Data Audit and Repair

Audited and repaired missing, invalid, and outlier values in a healthcare dataset while keeping the cleaning process documented.

Data CleaningOutliersImputationJASP
View case study → Methodology PDF

Mark Anthony Nene

Data quality, analytics support, reporting workflows, and audit-ready documentation.

GitHubLinkedInEmail