Teaching & Consulting
Healthcare analytics resources, report modernization consulting, and academic teaching.
Analytics for Small Healthcare Organizations & Nonprofits
For therapy centers, small clinics, and nonprofits that collect data but don't have a dedicated analytics team — I can help you make sense of it. From identifying trends in patient engagement and program outcomes to building simple dashboards that give your team clear, actionable visibility into what's working.
Updating Legacy Reports & Documents
Have reports stuck in old Word, Excel, or PDF formats? I can redesign and rebuild them into clean, consistent, and reproducible formats — whether that's a structured Excel workbook, a polished Word template, or an automated reporting pipeline.
Replacing Manual Workflows
If your team is spending hours every quarter manually copying data into reports, I can help automate the process using Python or SQL — producing consistent, auditable outputs with significantly less effort.
Building Analytics Foundations
For organizations earlier in their analytics journey, I can help establish KPI definitions, design reporting frameworks, and set up the data infrastructure needed to support consistent performance monitoring.
Interested in working together? Reach out and let's talk about what you need.
Get in touchGetting Started with SQL for EHR Data
Core SQL concepts — SELECT, WHERE, JOIN, GROUP BY — applied to clinical encounter data. No prior experience required.
CTEs and Window Functions for Clinical Reporting
How to use CTEs and window functions to calculate follow-up rates, identify gaps in care, and build reusable reporting logic.
Building a Patient Follow-up Tracking Query
Step-by-step walkthrough of a real-world follow-up compliance query — from raw encounter data to a reportable metric.
Python & Pandas for Clinical Data
Introduction to data manipulation with Pandas — loading, cleaning, filtering, and summarizing clinical datasets.
Automating Recurring Reports with Python
How to replace manual Excel workflows with reproducible Python scripts — from data extraction to formatted Excel output.
Building KPI Calculation Pipelines
Structuring Python scripts to calculate standardized KPIs — depression remission, access timeliness, screening rates — across programs.
Power BI for Behavioral Health Reporting
Building operational dashboards in Power BI — connecting to data sources, writing DAX measures, and designing for clinical audiences.
Understanding KPI Frameworks in Healthcare
How to define, standardize, and validate KPIs for clinical and operational programs — from conceptual framework to reportable metric.
Working with PHI and HIPAA-Aligned Data
Practical considerations for working with protected health information — de-identification strategies, minimum necessary standard, and HIPAA-aligned workflows.
Instructor of Record
- 2022–Spring 2025 — Graduate Teaching Instructor, SOC 150: Self and Society, University of Kansas (Online & In-person).
Teaching Assistant
- Spring 2024 — SOC 160: Social Problems and American Values, University of Kansas (Instructor: Jarron Saint Onge, Ph.D.).
- Winter & Fall 2023 — Event History Analysis, KOSSDA (Online; Instructor: BongOh Kye, Ph.D.).
- 2019–2022 — SOC 104: Elements of Sociology, University of Kansas (Instructor: Lisa-Marie Wright, Ph.D.).
| Course | Description | Link |
|---|---|---|
| SOC 150: Self and Society — Syllabus | Course overview, grading, policies, and weekly schedule. | |
| SOC 160: Social Problems and American Values — Syllabus | Course overview, grading, policies, and weekly schedule. | |
| SOC 104: Elements of Sociology — Syllabus | Course overview, grading, policies, and weekly schedule. | |
| Event History Analysis — KOSSDA Lab | Course overview, grading, policies, and weekly schedule. |