# Johnny Kenton Data Analysis Portfolio


## Posts

- [Hello world!](https://seashell-lobster-598231.hostingersite.com/hello-world/): Welcome to WordPress. This is your first post. Edit or delete it, then start writing!

## Pages

- [Program Evaluation & Data Strategy | Public Sector Portfolio](https://seashell-lobster-598231.hostingersite.com/): Framing Note: This portfolio presents two applied analytics projects built using fully simulated data from public-sector and institutional contexts. Each project is grounded in its original domain and designed to demonstrate transferable approaches to research data management, structured data modeling, and reproducible analytical workflows in complex, human-centered systems. The emphasis is on how well-documented data structures, relational databases, and transparent analytical pipelines can support evaluation, outcome monitoring, and responsible decision-making in environments where data may be incomplete, stakes are high, and rigor and transparency are essential. No workforce or employee data is represented. All examples focus on data governance, documentation,
- [Program Evaluation & Outcomes Analysis (SQL) | Child Welfare](https://seashell-lobster-598231.hostingersite.com/child-welfare-program-evaluation-sql/): Quick Scan DomainChild welfare program evaluation (simulated data) Primary QuestionHow can structured, well-documented data be used to examine relationships between program funding, service delivery, and permanency outcomes across regions and programs? What This Project DemonstratesRelational data modeling • Documented SQL workflows • Outcome and cost-per-outcome evaluation • Audit-ready analytical logic ToolsSQL • Relational database design Transferable InsightThe underlying data model and SQL workflows mirror research data management patterns used across regulated, human-centered domains to support transparent evaluation, reproducibility, and reuse beyond a single program or context. Program Evaluation & Outcomes Analysis (SQL) This project demonstrates how structured data analysis can support
- [Institutional Effectiveness & Equity Analytics | Public Sector](https://seashell-lobster-598231.hostingersite.com/institutional-effectiveness-equity-analytics/): Quick Scan DomainInstitutional effectiveness and equity analytics (simulated data) Primary QuestionHow can structured data, clear documentation, and reproducible pipelines support identification of differential outcomes or elevated risk that may warrant further review? Analytics DemonstratedReproducible data pipelines • Equity-focused evaluation metrics • Interpretable predictive modeling • Executive-facing, auditable reporting ToolsPostgreSQL / SQL • Python (scikit-learn) • Power BI / DAX Transferable insightThe methods demonstrated emphasize data governance, documentation, and interpretability, reflecting the research data management practices needed to responsibly support evaluation, equity assessment, and decision-making across academic and public-sector settings. Portfolio Showcase: Auditable Intelligence for Policy This project demonstrates the successful transformation


[comment]: # (Generated by Hostinger Tools Plugin)