Big Data - Top Ingredient to Improve Healthcare
summary
Describes a working pipeline that pulls HIS/EMR flat files into a staging SQL Server, runs validation and stored‑procedure processing, scores accounts with SQL Server Analysis Services models and custom C# tools, drives dashboards and work queues via cubes (about 136 measures, ~100 dimensions, ~2 billion rows) and SSIS orchestration. Claims include a deployed Presbyterian system across 8 hospitals and 30 clinics serving 660,000 people that yields a 3% revenue lift, 150% productivity increase and 11:1 ROI while enabling SSIS pipelines and readmission risk scoring for pneumonia AMI and heart failure.
AI-written summary · about
chapters (10)
- 0:00Big data in healthcare intro
- 1:46Healthcare reimbursement models
- 5:22Outcomes-based reimbursement shifts
- 10:03Healthcare operations data systems
- 15:25SQL Server for healthcare analytics
- 21:26Presbyterian Healthcare case study
- 26:44Merging clinical and financial data
- 30:32Patient segmentation with clustering
- 35:10Readmissions predictive modeling
- 38:17Healthcare's data-driven future
related talks
22mBuilding Predictive Analytics Data Warehouses in Healthcare
08mRevolutionizing Healthcare with Big Data and ML
10mTransforming Population Health with Predictive BI
11mEnsuring Reliability in Healthcare Data Engineering
15mTransforming Healthcare with BI & AI
48mAI for Healthcare
24mBuilding Cloud-based Solutions in Healthcare
21mMake sense of health data with Amazon HealthLake