English Grade 5 Vocabulary and Grammar Flashcards

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 using trees dataset