Purpose of This Portfolio
This portfolio highlights three applied data projects designed to demonstrate how evaluation, analytics, and data governance can support continuous quality improvement (CQI) and operational decision-making across regulated, high-stakes domains.
Each project uses simulated data and mirrors real-world analytical workflows used by agencies to
- Evaluate program effectiveness and outcomes
- Monitor equity, utilization, and risk
- Support leadership, compliance, and policy decisions
- Translate complex data into actionable insight
Framing Note:
This portfolio presents three applied analytics projects built using fully simulated data from healthcare, 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, and ethical use of data, while demonstrating domain-relevant analytical patterns without modeling operational or clinical decision-making.
Project Overview
1. Managed Care Analytics: Cost, Utilization & Care Management (SQL, Healthcare Focus)
This project simulates a managed care payer analytics workflow, demonstrating how enrollment, claims, and utilization data can be structured to support cost monitoring, utilization management, and care management prioritization.
Using a SQL Server and Power BI, the project emphasizes
- Member-month data modeling for accurate PMPM calculations
- Analysis of emergency department utilization
- Identification of high-cost members and rising risk trends
- Transparent, rule-based care management targeting
2. Program Evaluation & Data Analysis (SQL, Public Sector Focus)
This project demonstrates how structured data analysis can be used to evaluate the relationship between program funding, service delivery, and child permanency outcomes, including reunification, adoption, and aging out.
Using a relational data model and documented SQL queries, the project focuses on
- Developing defensible performance measures
- Linking funding to outcomes for accountability
- Identifying trends and regional variation
- Supporting leadership decision-making and federal reporting concepts
3. Institutional Effectiveness, Equity, & Predictive Risk Dashboard
This project illustrates how advanced analytics and visualization can support equity-focused evaluation, early risk identification, and executive-level reporting.
The dashboard architecture emphasizes:
- Tiered reporting for leadership, analysts, and strategies
- Measurement of disparities using statistically sound metrics
- Predictive indicators to support proactive intervention
- Strong data governance and audit-ready methodologies
How These Projects Work Together
Taken together, these projects reflect a holistic approach to analytics and data strategy across healthcare and public-sector contexts:
- Program Evaluation establishes what is happening and why
- Managed Care Analytics demonstrates how cost, utilization, and risk signals can guide operational prioritization
- Equity & Predictive Analytics help anticipate what may happen next
Across all projects, clear documentation and governance ensure findings are ethical, transparent, and defensible.
Ethical & Professional Standards
All projects in this portfolio
- Use full simulated data
- Follow principles of ethical data use and privacy protection
- Emphasize clarity and accessibility for non-technical stakeholders
- Reflect best practices in evaluation, analytics, and data governance
Intended Audience
- Program managers and directors
- Data and policy analysts
- Evaluation and compliance staff
- Healthcare and public-sector leadership
Next Steps
- Review Managed Care Analytics for payer-style cost, utilization, and care management analytics
- Explore Program Evaluation & Data Analysis for SQL-based performance measurement and funding accountability
- Examine Equity & Predictive Risk Dashboard for advanced analytics and executive reporting concepts