Data Disclaimer

All datasets used in this portfolio's healthcare dashboards have been randomly generated for demonstration purposes. They do not contain any real patient information or protected health information (PHI). Any resemblance to actual names, locations, or data is purely coincidental.

Portland, Oregon

Alex Doster

Enterprise Analytics

16 years in healthcare IT, 6+ in enterprise analytics: Power BI, Snowflake, Epic/Clarity, and AI-powered data tools.

Technical Consulting

End-to-end project delivery for organizations that need more than a report: scheduling tools, data apps, workflow automation.

Analytics Engineering & Technical Consulting

Alex Doster
Power BI DAX Power Query / M Snowflake Snowflake Cortex (AI) SQL Epic / Clarity Python Google Apps Script Star Schema Design Anthropic API GitHub Pages Healthcare Analytics Healthcare Domain Knowledge Semantic Layer Governance

Power BI Work at Providence Health

13 dashboards built with synthetic data are available to view now. The remaining dashboards below were built for production use at Providence Health & Services and are listed for reference.

Acute / Hospital
Live Demo Heart Failure Risk Analysis Identifies patients at risk for heart failure based on clinical criteria and medication patterns, supporting proactive intervention by care teams. Open report → Live Demo Women's Ferritin and HGB Tracks ferritin and hemoglobin lab completion rates and distributions across pregnancy episodes at Providence Women's Clinics, with logic handling first and second trimester lab windows. Open report →
Cancer Diagnosis VolumesTracks oncology diagnosis volumes across service lines and facilities to support capacity planning and program performance monitoring.
Children's Vitals AssessmentsMonitors pediatric vital sign documentation compliance and completion rates across clinic encounters.
Live Demo Heart CVL Volumes Tracks cardiovascular lab procedure volumes using a custom DAX ranking system backed by a dimension table to replicate a complex business-specific counting methodology. Open report → Live Demo Heart Imaging & Rehab Volumes Tracks imaging study volumes and cardiac rehab utilization across Providence heart program service lines. Open report →
Heart Procedural Lab VolumesMonitors procedural volume trends across cardiac catheterization and electrophysiology labs for operational and financial planning.
Hospital Charge DetailProvides line-level charge visibility across hospital encounters to support billing review and revenue integrity workflows.
Hospitalists Team AssignmentsTracks provider team assignments and patient panel distribution across the hospitalist program to support staffing balance and coverage planning.
Hospitalists wRVU ReallocationSupports wRVU reallocation workflows for the hospitalist program, enabling accurate productivity attribution across shared patient encounters.
Live Demo Women's Due List Surfaces patients with overdue preventive care and screening milestones across the women's health program to support proactive outreach. Open report →
Women's Hospital PSCUMonitors postpartum and surgical care unit throughput and patient flow metrics across the women's hospital service line.
Live Demo Women's Maternity Tracks maternity program volumes, delivery trends, and outcomes across Providence women's health facilities. Open report →
Women's New BeginningsTracks enrollment and engagement metrics for the New Beginnings prenatal support program across the Oregon region.
Live Demo Women's Surgeries & Procedures Monitors surgical and procedural volumes across the women's service line for operational planning and capacity management. Open report →
Clinic Operations
Live Demo All Clinic Visits Tracks new, scheduled, and canceled patient visit volumes across Oregon region clinics. Open report → Live Demo All Provider Fill Rates Monitors appointment slot fill rates by provider across Oregon region clinics to support scheduling efficiency and capacity planning. Open report → Live Demo Patient Experience Survey Analysis Analyzes patient satisfaction survey results across clinics and providers to surface experience trends and improvement opportunities. Open report → Live Demo Rooming and Check-Ins Optimization Analyzes date and time patterns across rooming and check-in workflows to support appointment scheduling and clinic throughput improvements. Open report → Live Demo Time to Close Encounters Tracks the time between patient visits and encounter closure across providers and departments to support documentation timeliness and billing workflows. Open report →
Pharmacy Specialist CollabTracks collaborative pharmacy specialist activity and medication management touchpoints across clinic encounters.
RN Quality & Patient SafetyBuilt at Providence Health · Multi-source proof of concept combining 8 to 10 reports into a unified executive summary
Live Demo E-Consultation Analysis Analyzes e-consult request volumes, response times, and specialty routing patterns to support telehealth program performance and access improvement. Open report →
E-Services VolumesMonitors patient-initiated digital touchpoints including MyChart messages, e-visits, and online scheduling activity across the Oregon region.
Genesys Primary Care VolumesTracks primary care visit volumes and provider utilization across Genesys-aligned clinics to support capacity and access planning.
Nutrition & Diabetes Education Fill RateTracks appointment fill rates and slot utilization for nutrition counseling and diabetes education programs across Oregon clinics.
Missed Referral OpportunitiesIdentifies patients with unfulfilled or lapsed referrals to support care coordination follow-up and reduce lost revenue from unscheduled specialty visits.
Financial Reports
Live Demo Cancer P&L Analysis Tracks oncology service line revenue, costs, and margin across facilities to support financial performance monitoring and planning. Open report → Live Demo Hospitalists Missed Charges Surfaces hospitalist encounters with missing or incomplete charges to support billing integrity and revenue recovery workflows. Open report → Live Demo Surgery Financial Analysis Analyzes surgical service line financials including volume, revenue, and margin by procedure type, surgeon, and facility. Open report → Live Demo Unbilled Procedures Identifies completed procedures where charges have not yet been submitted, supporting timely billing and reducing revenue leakage. Open report →
Coding ChangesTracks diagnosis and procedure code modifications post-encounter to support coding accuracy review and revenue integrity monitoring.
Coding Document ImprovementSurfaces documentation gaps and coding improvement opportunities to support clinical documentation integrity programs across the Oregon region.
Infusion Volumes & MarginTracks infusion therapy visit volumes and financial margin by drug, payer, and location to support service line profitability analysis.
OB Panel ReportProvides provider-level panel visibility for OB patients including gestational milestones, visit completion, and care gap identification.
Payments & AdjustmentsTracks payment posting and contractual adjustment trends by payer and service line to support revenue cycle performance monitoring.
Unbillable EncountersIdentifies encounters flagged as unbillable due to documentation or coding issues, supporting revenue recovery through targeted follow-up.
Unbilled EncountersSurfaces encounters where charges have not yet been submitted, supporting timely billing and reducing days in AR across the Oregon region.
Physician Compensation (wRVU)
Dual Production wRVUTracks wRVU production across providers with split or shared panel arrangements, supporting accurate compensation attribution in dual-role scenarios.
Oregon wRVUsRegional provider productivity dashboard tracking wRVU performance against targets across Oregon clinics, departments, and service lines.
Women's North wRVU ReallocationSupports wRVU reallocation workflows for the Women's North service area, enabling accurate productivity attribution across shared and co-managed encounters.
Women's South wRVU ReallocationSupports wRVU reallocation workflows for the Women's South service area, mirroring the North solution with region-specific logic and provider panels.

Building analytics systems that get used

I'm a Program Manager and Principal BI Engineer based in Portland, Oregon. With 16 years in healthcare IT and 6+ in enterprise analytics, I've been building the infrastructure that health systems rely on to make operational decisions, from the data model up through the dashboard a department director opens every Monday morning.

My work at Providence Health spans revenue cycle, surgical operations, clinical staffing, patient experience, and finance, with over 75 dashboards governed across the Oregon region. I also work directly with Epic's Clarity database and maintain the semantic layer that keeps reporting consistent across Oregon Operations and Finance.

On the consulting side, I take on projects where organizations need more than a report. That means scoping the problem, architecting the solution, building it, and handing off something that runs. The chef scheduling app is one example of that model in practice.

I'm open to full-time analytics leadership roles and consulting engagements in healthcare and adjacent industries.

16
Years in healthcare IT
6+
Years in enterprise analytics and BI
75+
Power BI dashboards governed
13
Live demo dashboards in this portfolio

Open to the right opportunity

Whether you're hiring for an analytics leadership role or need a technical consultant who can scope and build, reach out directly.