Presentation Title Here
April 30, 2015
MBGH Panel Using Data to Track the Right Measurements and Outcomes
Jack Sullivan Director – Health Care
1
Union Pacific Data Analytics Current State and Future Direction • Benefits: Data Warehouse (since 2005)
– Medical, Rx, Wellness Assessment, Enrollment – Custom Fields for Reporting
• Department, Service Unit, Work Location, Cost Center
– Added Disability and Dental
• HR Data Analytics: Decision Support Staff
– Past – ad hoc reports; manual, time consuming and reactive – Future – efficient, user-friendly tools, dashboards with drilldown – Purchased Oracle tool – advanced predictive analytics; visualization for storytelling; data from multiple sources; proactive – Focus on Workforce Planning and Human Capital Management, but opportunity to leverage with broader data integration
• Future Direction
– Addition of nontraditional data sources to Oracle tool
• External – census, surveys, other • Internal – possibly compensation, performance review, safety, others?
– Robust role-based security
2
Union Pacific Data Analytics Challenges • How Data Warehouse and Oracle Tools can be leveraged together? – Desire to connect Human Capital Management data with Benefit data – Example: Do average prospective risk scores or compliance with evidence-based medicine guidelines impact operational performance, absence, or safety for a work unit? • Increase visibility of Health/Wealth impacts on business objectives
– Early in the process of looking at how to do this
• Challenges – Benefit plan use of data limits? • HIPAA (payment, treatment and healthcare operations) • Retirement plans – plan fiduciary concerns?
80% of the effort is in data preparation
– Prioritization of data to integrate – Security administration – Ability to tell the story in language of the business units
3
MBGH Panel Using Data to Track the Right Measurements and Outcomes
Jack Sullivan Director – Health Care
1
Union Pacific Data Analytics Current State and Future Direction • Benefits: Data Warehouse (since 2005)
– Medical, Rx, Wellness Assessment, Enrollment – Custom Fields for Reporting
• Department, Service Unit, Work Location, Cost Center
– Added Disability and Dental
• HR Data Analytics: Decision Support Staff
– Past – ad hoc reports; manual, time consuming and reactive – Future – efficient, user-friendly tools, dashboards with drilldown – Purchased Oracle tool – advanced predictive analytics; visualization for storytelling; data from multiple sources; proactive – Focus on Workforce Planning and Human Capital Management, but opportunity to leverage with broader data integration
• Future Direction
– Addition of nontraditional data sources to Oracle tool
• External – census, surveys, other • Internal – possibly compensation, performance review, safety, others?
– Robust role-based security
2
Union Pacific Data Analytics Challenges • How Data Warehouse and Oracle Tools can be leveraged together? – Desire to connect Human Capital Management data with Benefit data – Example: Do average prospective risk scores or compliance with evidence-based medicine guidelines impact operational performance, absence, or safety for a work unit? • Increase visibility of Health/Wealth impacts on business objectives
– Early in the process of looking at how to do this
• Challenges – Benefit plan use of data limits? • HIPAA (payment, treatment and healthcare operations) • Retirement plans – plan fiduciary concerns?
80% of the effort is in data preparation
– Prioritization of data to integrate – Security administration – Ability to tell the story in language of the business units
3
