Recently Published
English Grade 5 Vocabulary and Grammar Flashcards
English Grade 5 Vocabulary and Grammar Flashcards
Healthcare Operations Analytics: Multi-Facility Provider Utilization and Contract Performance Engine
Overview:
Healthcare delivery networks frequently suffer from severe resource imbalances—certain clinics experience scheduling bottlenecks and clinician burnout, while others operate significantly under capacity. This project demonstrates a complete data engineering and clinical operations workflow designed to automate utilization auditing.
Key Methodologies & Technologies Demonstrated:
Relational Database Simulation: Designed and built an in-memory SQLite database utilizing DBI and RSQLite to establish a relational schema of transactional EHR encounters, scheduling logs, and provider registries.
SQL Query Optimization: Engineered complex multi-table joins and Common Table Expressions (CTEs) to aggregate raw patient-facing minutes into clinical hours and map them against scheduled shift durations.
High-Fidelity Reporting: Created a highly polished, executive-ready horizontal bar chart in ggplot2 featuring explicit target thresholds, optimized color scales, and precise label alignment to instantly highlight capacity gaps.
Strategic Action Plan: Delivered actionable recommendations to shift capacity from under-utilized regions (North Mankato) and safeguard high-volume clinics (St. Cloud Urgent Care) against provider attrition.
Simple Linear Regression
Simple linear regression using trees dataset
miniDREAM challenge 2023 module 4
HTML of module 4 activity R notebook for conversion to stand alone module.