Alex Doster

Featured Projects

Selected Work

Healthcare Analytics · Power BI

Providence Health Portfolio

13 live demo dashboards, rebuilt with synthetic data, spanning revenue cycle, clinical operations, staffing, and finance, modeled on production work for a major Pacific Northwest health system. Over 75 built in production at Providence Health.

View Dashboards

Live Product · AI Analytics · Public Data

AskCostReports.com

A live, public product, not a demo. Real visitors ask real questions against CMS Medicare cost report data for ~6,000 US hospitals, refreshed automatically every week, with zero backend to maintain. In-browser SQL via DuckDB-WASM, Anthropic API for the natural-language layer. Designed, built, and shipped solo.

Try It Live

Consulting · AI Demo · Healthcare

Healthcare AI Analytics Demo

A pre-sales prototype for a multispecialty clinic evaluating AI-powered analytics, built on synthetic data so the conversation stays safe before any real data changes hands. The in-browser SQL engine (DuckDB-WASM) was a deliberate choice: it mirrors how Snowflake Cortex resolves queries in production, so the demo also proves the architecture will translate to their actual stack.

Password protected to manage API costs. Email me for access.

Launch Demo

Consulting · Google Apps Script · Web App

Chef Scheduling App

A full scheduling and demo management web application built for a multi-location food service client. Handles chef demo visit scheduling across retail locations, tracks session data, and provides operational reporting. Scoped, built, and delivered as an independent consulting engagement.

View App

Dashboard Library

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.

Other Dashboards

Live Demo Power BI Basic Training App An interactive end-user training tool built to drive self-service analytics adoption across the Oregon region, covering navigation, filtering, and report interaction. Open report → Live Demo Subscription Based Company Mock-Up A fully synthetic SaaS company financial and operational dashboard built to demonstrate Power BI design patterns outside the healthcare domain. Open report → Live Demo Scheduling Demo A Power BI reporting layer built alongside a chef scheduling application, demonstrating how operational app data flows into an analytics layer. Open report →

Data Disclaimer