Post EDW Installation How to Take Your Analytics Game to the Next Level John Wadsworth Vice President Technical Operations Health Catalyst How much should I invest in equipment Equipment doesnt win games ID: 325300
Download Presentation The PPT/PDF document "Session D:" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Session D:Post EDW InstallationHow to Take Your Analytics Game to the Next Level
John Wadsworth, Vice President, Technical OperationsHealth CatalystSlide2
How much should I invest in equipment?Slide3
Equipment doesn’t win games
Skill and discipline drive outcomesCompetency framework can scalePresentation ObjectivesSlide4
What makes a great soccer player?
Ball controlPassing
Shooting/scoring
Attacking
Defending
Field vision
Physicality - fitnessSlide5
Soccer Skill Continuum
Rank skills on scale of 1-51 = Recreation player5 = Professional playerEffective application of skills validates the ranking (experience)Slide6
Soccer Player Skill Comparison
Skill LevelSlide7
Time to Practice!
Ball control - Juggling Use any part of your body except your arms/handsCount your consecutive jugglesPrizes for top 3
15 second warm-up
30 second round - determine finalists
30 second round – determine winners
Everyone head to the courtyard
…
https://www.youtube.com/watch?v=XZh1C-tbS5oSlide8
Initial EDW Game Plan
Essentials Apps
Infrastructure
Integrated Data
Discovery Applications
Source-to-EDW Data
Essentials Layer
Advanced Applications
HW
Access
Source Marts
Infrastructure
Starting Month
Month 1
CAP
Costing (DSS)
Essentials Layer Mapping
KPA
Population Explorer
Cohort Builder
Claims
EMR (Epic)
Pharmacy
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Breast Cancer
Comorbidity Analyzer
Equipment needed to play the game
Scrimmages, conditioning, building your team
Winning games
Advanced ApplicationsSlide9
Recreation League - Getting Started
9Essentials Apps
Infrastructure
Data Architect
= DA
Essentials Layer
Advanced Applications
HW
Access
Source Marts
Starting Month
Month 1
CAP
Costing (DSS)
Essentials Layer Mapping
KPA
Population Explorer
Cohort Builder
Claims
EMR (Epic)
Pharmacy
Month 2
Month 3
Month 4
Month 5
Month 6
Month 7
Breast Cancer
70% DA
20% SDA
10% TD
Field Positions
75% DA
20% SDA
5% TD
40% DA
50% SDA
10% TD
50% DA
30% SDA
20% TD
20% DA
60% SDA
20% TD
Comorbidity Analyzer
Senior Data Architect
= SDA
Technical Director
= TD
PlayersSlide10
Data Architect – Skill Continuum
Skill LevelSlide11
Don’t Confuse Equipment with Capabilities
CapabilitiesETLConsistent, efficient, audit logsData ModelingPrincipled
‘Meaningfully relational’
SQL
Set theory (inclusion/exclusion)
Data Analysis
Insightful
actionable
Statistically sound
BI Development
Visually intuitive
‘Non-techie’ consumable
Tools (Equipment)
SSIS (ETL)
SSMS (DDL, DML, t-SQL)
BI Development (
Qlikview
)Slide12
Competition League - Sustaining
12Essentials Apps
Infrastructure
Data Architect
= DA
Advanced
Applications
Source Marts
Month
Month 8
HR
GL Explorer
Surgery Explorer
External lab
Pat Sat
Time
Month 9
Month 10
Month 11
Month 12
Month 13
Month 14
80% DA
10% SDA
10% TD
Field Positions
75% DA
20% SDA
5% TD
20% DA
60% SDA
20% TD
ACO Explorer
Senior Data Architect
= SDA
Technical Director
= TD
Players
Sepsis
Professional billing
CAUTI
Duplicate Rx orders
OR Turnover Time
CLABSI
Knowledge Manager
= KM
EDW Manager
= EM
KM
EM
ES
Governance and Prioritization
Sr. Outcomes Analyst
= SOA
Outcomes Analyst
= OA
Executive Sponsor
= ESSlide13
Major League - Advancing
13Essentials Apps
Infrastructure
Data Architect
= DA
Advanced
Applications,
Program
Development
and
Governance
Source Marts
Month
Month 15
Ext Rx
NursingTime
ADT Explorer
Benchmk
Month 16
Month 17
Month 18
Month 19
Month 20
Month 21
80% DA
10% SDA
10% TD
Field Positions
75% DA
20% SDA
5% TD
20% DA
60% SDA
20% TD
Rev Explorer
Senior Data Architect
= SDA
Technical Director
= TD
Players
Sepsis
Duplicate lab orders
OR Turnover Time
Knowledge Manager
= KM
EDW Manager
= EM
KM
EM
BPM
DS
PI
ES
Governance and Prioritization
Clinic
3
4
5
Professional Billing
3
4
CLABSI
3
4
5
CAUTI
3
4
5
BI Program Manager
= BPM
Sr. Outcomes Analyst
= SOA
Outcomes Analyst
= OA
Executive Sponsor
= ES
Diabetes
Breast Cancer
3
4
Dept. Sponsor
= DS
KPA
Pop Ex
Cohort Builder
Comorbidity
GL Explorer
SurgerExplorer
AC Explorer
Duplicate Rx
3
4
3
Prostate
Hypertension
Process Improvement
= PISlide14
Primary Care Clinical Program
Recreation
Ext Rx
N. Time
ADT
Exp
Bench
20
21
Rev
Exp
Duplicate lab orders
Discharge no
final bill
Governance and Prioritization
Clinic
3
4
5
3
4
3
4
5
3
4
Diabetes
3
4
5
3
4
Prostate
Hypertension
HR
GL Explorer
Surgery
Exp
lab
Pat Sat
Time
ACO Explorer
Sepsis
Professional billing
CAUTI
Dup Rx orders
OR Turnover Time
CLABSI
Governance and Prioritization
HW
Access
CAP
Costing (DSS)
Claims
EMR (Epic)
Pharmacy
KPA
Pop Explorer
Comorbidity
Breast Cancer
19
18
17
16
15
14
13
12
11
10
09
08
07
06
05
04
03
02
01
Cohort builder
3
4
Competition
Major League
Service Lines
Finance
Oncology Clinical Program
Patient Safety and Quality
System-wide BI Governance Slide15
Poll Question #1
15
Where is your organization along this skill continuum
?
Recreation level
Competition level
Major League level
Not sure
Slide16
Poll Question #2
16
What does your organization need to move to the next level
?
Equipment
More advanced skills (SQL, ETL, data modeling, etc.)
More players
Coaching
Not sure
Slide17
Poll Question #3
17
In what phase is your game plan to move to the next level
?
None
Conceptual
Starting engagement
Early implementation
Advanced implementation
Slide18
Success is no accident. It is hard work,
perseverance, learning, studying, sacrifice and most of all, love of what you are doing or learning to do.~ PeleSlide19
Lessons Learned
18Assess capabilities across skill spectrum
Build a core team covering the skill spectrum
Get 3-4 wins and share the news
Invest in bench depth to establish permanence
Discipline + capabilities
predictable, positive
outcomes
Slide20
Analytic
Insights
A
Questions &
Answers
19Slide21
Choose one thing…20
Write down one thing will you do differently after hearing this presentation
Slide22
Thank You
21
Slide23
23
Session Feedback Survey
On a scale of 1-5, how satisfied were you overall with this
session?
Not at all satisfied
Somewhat satisfied
Moderately satisfied
Very satisfied
Extremely
satisfied
What feedback or suggestions do you have?Slide24
Upcoming Sessions
Pre-Summit Sessions 2 (4:25 PM – 5:10 PM)Panel: How to Maximize your EDW and Analytics Investment with a Service-Value Approach
Panel: Patient Safety and Patient Injury Prevention Best Practices
Panel: ACO and Population Health Best Practices
Panel: Our Most Advanced Customers: How to Meet the Growing Demands of Increased Success
24
Location
Envoy
Savoy
Murano
Venezia
E
)
F
)
G
)
H)