• No results found

Dashboard Overview Webinar

N/A
N/A
Protected

Academic year: 2021

Share "Dashboard Overview Webinar"

Copied!
38
0
0

Loading.... (view fulltext now)

Full text

(1)

Regional Information for Shared Excellence

(RISE) Initiative

Dashboard Overview Webinar

Jerry Lassa, MS Statistics

May 15 & May 17, 2012

(2)

Do You Ever…

Spend a lot of time reviewing data trying to make sense out of it?

Wonder how you did last month, last quarter or last year as a reference

point?

Wonder how well you’re doing compared to your colleagues,

y

g

p

y

g

,

competitors, the state or the country?

See a change in data from one month to the next and wonder whether

you should take action or not?

you should take action or not?

Make a decision based on gut instinct or prior experience because you

don’t have data to support the decision?

See a relationship between clinical care and operational functioning of

your clinic but can’t quantify it?

Feel knowledgeable about performance data in your organization but

g

p

y

g

others don’t?

(3)

Agenda

g

RISE Background

1

Baldrige Performance Excellence Framework

2

Dashboard Reporting & Use: Best Practices

3

Data Validation Basics

Beginner Dashboard Design

4

5

Beginner Dashboard Design

(4)

Big Changes in the Industry

g

g

y

Vendor selection

- Vendor selection

- Workflow redesign

- Hardware/software

N t

k

- Network

- Training

- Implementation

- Data-driven culture

- Performance measures

- Link to EHR fields

EHR

C

hange

- Optimization

- System use, data integrity

- Reports, dashboards

- Training

EHR

Implement

Data

Management

C

Training

- Optimization

Management

& Analytics

Ti

Time

(5)

Then and Now

Then and Now

Then:

Physician DOS Patient ID Avg A1c BP LDL Foot Exam

Smith 4/12/2011 2949983 6 YES YES YES Smith 4/12/2011 9851498 4 YES YES NO Smith 4/10/2011 3134878 10 YES YES YES

Now:

Smith 4/10/2011 3134878 10 YES YES YES Smith 4/12/2011 8866369 6 NO NO YES Smith 4/12/2011 2007528 7 YES YES NO Smith 4/13/2011 9070925 6 YES YES NO Smith 4/13/2011 1438507 8 YES YES NO Smith 4/13/2011 4871361 8 YES YES YES Smith 4/10/2011 8549370 7 YES NO NO Smith 4/10/2011 2458352 4 YES YES YES Jackson 4/13/2011 6187972 4 YES YES YES Jackson 4/13/2011 305191 6 YES YES YES Jackson 4/13/2011 554553 7 YES YES NO Jackson 4/13/2011 554553 7 YES YES NO Jackson 4/12/2011 4968186 5 YES YES YES Jackson 4/12/2011 7947836 10 YES NO YES Jackson 4/12/2011 8331051 10 YES YES NO Jackson 4/13/2011 1320313 6 YES YES YES Jackson 4/13/2011 7647899 6 YES YES NO Jackson 4/10/2011 7724504 8 YES NO NO Jackson 4/10/2011 5041785 7 YES YES YES

(6)

Is Your Organization Ready

f

th T

i f D t ?

(7)

RISE Initiative

Background

ƒ

Over the past decade, clinics have worked to enhance quality

Over the past decade, clinics have worked to enhance quality

improvement efforts, transform culture, information systems, and care

delivery

ƒ

Significant work in tracking and reporting key performance measures to

Significant work in tracking and reporting key performance measures to

assess the quality of patient care

ƒ

Several statewide projects have supported this work

ƒ AQICC Tools for Quality other regional efforts

ƒ AQICC, Tools for Quality, other regional efforts

ƒ Results: definition of standardized clinical and operational measures,

enhancement of quality improvement processes and implementation of HIT, including registries, to collect and report on quality data

including registries, to collect and report on quality data

ƒ

RISE Initiative:

ƒ Runs October 2011 to December 2012

ƒ Continued data collection reporting and use work with a focus on Data

ƒ Continued data collection, reporting and use work with a focus on Data Sharing Communities and accelerating improvement of clinical and operational performance by supporting data-driven management

(8)

RISE Initiative

Project Description

ƒ

Data Sharing Communities (DSCs):

Data Sharing Communities (DSCs):

Super Region Data Sharing Communities

North North Coast Clinic Network (Super Region Lead) Alliance for Rural Community Health Health Alliance of Northern California Bay Areay Redwood Community Health Coalition (Super Region Lead)y ( p g ) Community Health Center Network Community Health Partnership San Francisco Community Clinic Consortium Central Valley Central Valley Health Network (Super Region Lead) DSCs organized by measure South Community Clinics Health Network (Super Region Lead) Coalition of Orange County Community Clinics Community Clinic Association of Los Angeles County

(9)

RISE Initiative

Project Description cont.

1.

Regional Learning Communities

1.

Regional Learning Communities

ƒ Data analytics, including data validation, analysis, reporting and sharing data with providers through the use of dashboards

ƒ Enhancing the patient experienceg p p

ƒ Team approaches to care delivery

ƒ Patient panel management

ƒ Staff engagement/culture changeStaff engagement/culture change

ƒ Patient self-management support

ƒ Health coaching

ƒ Operational changes to increase accessOperational changes to increase access

2.

Data Analytics

ƒ The collection, review, and reporting of key metrics across project

participants Quarterly sharing of data and using it to improve patient care participants. Quarterly sharing of data and using it to improve patient care with reporting to CHCF every six months

ƒ Measures sets contain three to six measures with at least one measure in each of the clinical, operational and patient experience measure domainsp p p

(10)

RISE Initiative

Project Description cont.

3.

Dashboard Use

3.

Dashboard Use

ƒ Each DSC will use a standardized dashboard in various forums to display data, and facilitate discussions

ƒ A standardized dashboard template is available but each DSC and Super p p Region has the flexibility to customize the dashboard to suit their needs (e.g., different measure sets, display of blinded and unblinded data, variety of audiences)

ƒ Need to ensure the dashboard is populated appropriately and accurately, and disseminated to various audiences in an effective and meaningful way

4. Plan for Improved Outcomes

ƒ Each community or region has committed to improvement on at least one measure in the first year, and at least two measures in the second year of the grant

(11)

RISE Measures

Clinical Measure Meaningful 

use

UDS North Super Region Bay Area Super Region Central 

Valley SR South SR ARCH HANC NCCN CHCN CHP RCHC SFCCC ARCH HANC NCCN CHCN CHP RCHC SFCCC Hypertension: BP  Measurement  CORE T7 (control  of HTN) ✔

Tobacco Use Assess & 

Tobacco Cessation Interv.

CORE Table 6B

Adult Weight Screening & 

Follow‐Up CORE Table 6B Childhood Immunization  Status  Alternate  CORE Table 6B

Diabetes: Hemoglobin A1c Additional Table 7 Diabetes: Hemoglobin A1c 

Poor Control 

Additional 

Set

Table 7

Diabetes: Low Density 

Lipoprotein (LDL) 

Management and Control

Additional 

Set

Table 7

✔ ✔ ✔

Controlling High Blood 

Pressure 

Additional 

Set

Health Out/ 

Disparity ✔ ✔ ✔ ✔

Cervical Cancer Screening Additional 

Set

Table 6B

Percent of patients without a Percent of patients without a 

PCP visit in last 12 months ✔

+ Operational: Third Next Available Appointment (TNAA), % No-Show Rate + Patient Experience: TBD (RISE year two focus)

(12)

RISE Linked with BSCF CCAP Initiative

(Blue Shield California Foundation

(Blue Shield California Foundation

California Comparative Analytics Project)

Purpose:

Purpose:

Support adaptation of i2i's PoplQ software to serve the data

collection and analytic needs of community clinics and other safety

net providers who use BSCF’s self-assessment tool

net providers who use BSCF s self-assessment tool

The adapted software will help community clinics and other safety

net providers collect, compare, and share data related to

clinical

quality financial operational and patient experience

quality, financial, operational, and patient experience

performance indicators generated by the tool.

Finance measure focus:

Operating margin or net margin, Days cash on hand, Current ratio,

Revenue mix, Average cost of clinic visit, Average cost of clinic visit

by payer, Net revenue or loss by payer or Net operating margin by

payer, Collections ratio, by payer, Benefits as % of total salary or

wages, Claims quality

(13)

Importance of Smart Data Display

p

p y

Goo d

44% (Medicaid National Best)

51% (Commercial National Best)

35% (Medicaid National Average)

What’s the measure?

What’s the measure?

Time period?

Which direction is good?

Benchmark?

Goal?

Is performance level a priority? If so, what do we do? Who’s responsible? What

resources are allocated? Who and how to hold accountable for improvement?

(14)

Importance of Balanced Measures

p

Measures from multiple “domains” (e.g., clinical, operational, financial)

tell a much richer story than a single measure and better inform decisions.

(15)

So many more measures to manage…

need to have efficient reporting

need to have efficient reporting

1. HTN blood pressure 2. Tobacco use, cessation

24. Oncology breast cancer: hormone therapy 25. Oncology colon cancer: chemo for stage III

All Clinical Measures:

3. Weight screening 4. Flu vax for older adult

5. Diabetes: HbA1c poor control 6. Diabetes: LDL mgmt and control 7 Diabetes: BP mgmt

26. Prostate cancer: avoidance of overuse of bone scan 27. Smoking and tobacco cessation, medical assistance 28. Diabetes: eye exam

29. Diabetes: urine screening 30 Diabetes: foot exam 7. Diabetes: BP mgmt

8. HF: ACE/ARB for LVSD 9. CAD: beta-blocker for prior MI 10. Pneumo vax for older adult 11. Breast cancer screening

30. Diabetes: foot exam

31. CAD: drug therapy for lowering LDL 32. HF: warfarin therapy for atrial fib 33. IVD: BP mgmt

34. IVD: use of aspirin or other antithrombotic 12. Colorectal cancer screening

13. CAD: oral antiplatelet therapy 14. HF: beta-blocker for LVSD 15. Anti-depressant med mgmt 16 POAG: optic nerve eval

35. Initiation and engagement of alcohol and other drug dependence tx

36. Prenatal care: screening for HIV 37. Prenatal care: anti-D immune globulin 38. Controlling high BP

16. POAG: optic nerve eval

17. Diabetic Retinopathy: docum of macular edema 18. Diabetic Retinopathy: communication with physician

managing diabetic care

19. Asthma pharmacologic therapy 20 A h

g g

39. Cervical cancer screening 40. Chlamydia screening for women 41. Use of appropriate meds for asthma 42. Low back pain: use of imaging studies 43 IVD l li id l d LDL l 20. Asthma assessment

21. Appropriate testing for children with pharyngitis

43. IVD: complete lipid panel and LDL control 44. Diabetes: HbA1c control (<8.0%)

+ Operational Measures + Finance Measures

+ Operational Measures + Finance Measures

(16)
(17)
(18)

Baldrige National Quality Program

g

y

g

P

id

t R

ll d f

ti

l

ƒ

President Reagan called for a national

study on productivity in October 1982 in

response to declining US productivity

p

g

p

y

ƒ

This resulted in a National Quality

Award signed into law in 1987

ƒ

Baldrige Program promotes excellence

in organizational performance,

i

th

lit

d

f

Malcolm

recognizes the quality and performance

achievements and publicizes

successful performance strategies

Malcolm

Baldrige

1922-1987

(19)

Baldrige National Quality Framework

H f t How your key strategic objectives address your strategic

challenges. How you ensure strategic and operational plans are achievable and adequately scoped. How you develop and deploy action plans throughout the organization to

H i How you foster an

employee culture conducive to high performance. How d p y p g g achieve objectives. How your senior

leaders

communicate with and engage

th ti you manage and

develop your staff to utilize their full

potential. the entire workforce and encourage frank, two-way i ti communication throughout the organization Measurable results you achieved achieved. H How you “Listen

and Learn” from your key

stakeholders How you manage

and improve your organizations’ key processes. stakeholders including Customers, Community, Partners and Partners, and

(20)
(21)
(22)
(23)
(24)

How It All Fits Together

g

(25)

Example Plan

Strategy

Objective

Measurable

Strategy

“Pillars”

Objective

Statements

Measurable

Indicators

(26)

Create a strategy that fits your organization—

Don’t piece one together

Don t piece one together

Accountable

 

Care

Accountable

 

Care

Organization

  

Organization

  

Meaningful Use

Patient Centered

Medical Home

(27)

Baldrige as a Guide for Dashboard Design

g

g

Provides balanced model for organization

performance

Used heavily in health sector

Since 2005, > 50% of Baldrige award applicants are health

care

care

Provides context for data management

Measures should “align” with the industry

Measures should align with the industry

• e.g., NQF or P4P at local, state, national

Dashboard measures should “align” with organization

t t

strategy

Dashboard measures should be “balanced”

(28)

Dashboard Reporting

p

g

Best Practices

ƒ

Dashboard Formats

ƒ

Trend/time charts with internal goals and external benchmarks or

norms

ƒ

Stoplights (red, yellow, green coloring to indicate measure status)

Stoplights (red, yellow, green coloring to indicate measure status)

ƒ

Dashboard Deployment

ƒ

Use to track strategy and annual plan execution

ƒ

Use same dashboard format

ƒ

Horizontal

ƒ

Across sites, divisions, departments/specialties

,

,

p

p

ƒ

Use similar measures as relevant (e.g., TNAA applies to

all clinical departments)

ƒ

Vertical

Vertical

ƒ

BOD, senior leadership, management, staff

ƒ

Measures should “roll up” with selected “core” strategic

t t

(29)
(30)
(31)

Review of Dashboards in Meetings

g

Best Practices

ƒ

Review dashboard results

R

i

i

ƒ

Recognize improvements

ƒ

Scan trends across all measures, look for potential issues

ƒ

Discuss and prioritize opportunities

p

pp

ƒ

Develop a plan to address; establish goals for improvement

ƒ

Assign responsibility

(32)

Accountability for Results

y

A

bl S

i

d O

i

Pl

i

h

i

A measurable Strategic and Operating Plan is the main

reference point for accountability in outcomes achievement

Need alignment of goals between governance leadership

Need alignment of goals between governance, leadership,

management, and staff

Assign responsibility for specific strategy objectives and goals

to appropriate governance and management committees (e.g.,

clinical quality, finance, IT)

Incorporate performance goals and incentives into board

Incorporate performance goals and incentives into board,

leadership, and staff performance management plans and

reviews; incorporate goals into provider contracts

(33)

Public Accountability and Transparency

y

p

y

“The good will earned by accountable and transparent nonprofits is

one of, if not the most important, of its assets.”

p

--National Council of Non-Profits

Health reform through

Health reform, through

Accountable Care

Organizations,

will make accountability and

will make accountability and

transparency a business

imperative for community

health centers

(34)

Data Validation Basics

ƒ

Understand the measures (you and everyone else)

ƒ Numerator, denominator, exclusion criteria

ƒ Historical data requirements for selected measures

ƒ

Sample (paper charts) vs. Population data (EHR)

ƒ

Sample data requirements

Sample data requirements

ƒ Ensure representative and random sampling

ƒ Ensure appropriate sample size for achieving desired margin of error

ƒ UDS requirements: n=70

ƒ UDS requirements: n=70

ƒ

Population data requirements

ƒ Appropriate use of EHR queries and report writers when selecting data

ƒ follow inclusion/exclusion criteria in measure definitions

ƒ Ensure data are accurate and reliable

ƒ Run frequency tables to cross validate patient totals and system use

ƒ Identify clinical content, screen flow issues to inform EHR optimization roadmap

ƒ Ensure reliability of interfaces (e.g., lab, pharmacy)

(35)

Examples of System Use Measures

These types of

yp

measures help you

monitor data

validation issues

validation issues

(36)

Beginner Dashboard Design

g

g

ƒ

Excel basics

ƒ Worksheet tabs and optimal use of the “real estate”

ƒ Appropriate use of columns and rows with data for charts

ƒ Common commands: formulas, cell formatting

ƒ

Excel graphs

ƒ

Excel graphs

ƒ Rationale: Visual presentation of data improves user ability to interpret

ƒ Approach: Various types of charts; use column or line charts with time across x axis

x-axis

ƒ Application: Creating a column chart with a goal lines; formatting title and axis labels, column series color, data labels, y-axis

ƒ

Dashboard report formatting

ƒ Rationale: Create an efficient layout of graphs for effective use in sharing data in various forums

ƒ Approach: Alignment with organization strategy, use of internal goals and external benchmarks

ƒ Application: Arranging multiple graphs on a single page; formatting page setup including margins header/footer fitting to one page

(37)

Be Sexy with Data

“I k

i

th t th

j b i th

t 10

“I keep saying that the sexy job in the next 10

years will be statisticians,” said Hal Varian, chief

economist at Google “And I’m not kidding ”

(38)

Questions?

[email protected]

@

References

Related documents

Stimulating lending by fiscal subsidy (without assuming bank credit risks) The objective of state subsidies provided for corporate lending is to reduce lending rates and

Post workout smoothie - protein powder (See “Supplements” section), a banana, Tbsp of raw. honey, 5 frozen strawberries in water or unsweetened

PUI, and the insurance advice based on the calculated highest premium paid by users, lowest premium paid by users, and.. average premium paid by users may

partnership will break. Rahu is in pisces in 8.41 It means it is in saturn’s star utharabhadrapada. Rahu is in venus sub. The matter of this house will bematerialising, if the

Funding: Black Butte Ranch pays full coost of the vanpool and hired VPSI to provide operation and administra- tive support.. VPSI provided (and continues to provide) the

But although The Unfortunate Traveller does contain travestied elements of the genre of apocalypse (most notably in connection with Esdras of Granada),

Crude protein, crude lipid and ash of fish carcass were not significantly different between dietary treatments with the exception of crude lipid of fish fed with Diet

For example, the Verizon Data Breach Investigation Report supplemented its survey responses with information collected during investigations of data breaches.. These problems