Dashboard

Effective Dashboard Design: Choosing Your Dashboard KPIs

Neal Williams
Corda Founder, Chief Scientist, & President of Corda Services

October 29, 2007

1

Effective Dashboard Design
A dashboard can be much more than a visual reporting system. The true potential of a dashboard is to be a performance management system.

October 29, 2007

2

Effective Dashboard Design

What isthe purpose of a performance dashboard? Facilitate Execution
October 29, 2007 3

Effective Dashboard Design Execution ‘The gap between what a company’s leaders want to achieve and the ability of their organizations to deliver it’
- Larry Bossidy and Ram Charan, (2002) Execution: The Discipline of Getting things Done

‘Strategy is important, but it is execution that counts’
- Jeff Call, CEO& Founder of Focus & Execute
October 29, 2007 4

A Recent Survey of Business Leaders
What is the main barrier to your company’s success?

October 29, 2007

5

Barriers to Execution
Inability to make timely and informed decisions

October 29, 2007

6

Barriers to Execution
Inability to make timely and informed decisions

“Intelligence is the most important work, because theentire force relies on it for every move. It is the essence of strategy.” - Sun Tzu, Art of War
October 29, 2007 7

Barriers to Execution
Lack of Focus

October 29, 2007

8

Barriers to Execution
Lack of Alignment & Commitment

October 29, 2007

9

Types of Performance Dashboards
Performance Dashboards fall into one of three categories

1. Strategic Alignment
Example:Attributes: Balanced Scorecard Dashboard Long term scope, measures change infrequently

2. Organizational Management
Example: Attributes: Sales Force Management Dashboard medium term scope, measures change frequently

3. Real-Time Operational
Example:Call Center Operations Dashboard Attributes: short term scope, measures change by the second or minute
October 29, 2007 10

Effective DashboardDesign
Two different ways to design a dashboard

Bottom Up

Top Down
Execution-Plan Driven Design

Data Driven Design

October 29, 2007

11

Effective Dashboard Design
Two different ways to design a dashboard

Bottom Up

Top Down
Execution-Plan Driven Design

Data Driven Design

October 29, 2007

12

Effective Dashboard Design
The 9 Steps of Choosing Your KPIs
1.Create a Framing Statement 2. Create a list of questions that you would like the performance dashboard to answer 3. Determine your Top Level KPIs 4. Determine your indicator types 5. Remove all indicators that are not KPIs 6. Check for Corporate Compliance 7. Assign Targets, Benchmarks, and Alerts 8. Check Data Availability 9. Add Structured Navigation, and Structured Analysis
October 29, 2007 131. Create a Framing Statement
A framing statement will serve as a guide to your design process and will allow you to quickly decide which elements belong in your dashboard, and which do not.

October 29, 2007

14

1. Create a Framing Statement
Example Framing Statement
The performance dashboard for Company X’s Customer Service and Support Department will facilitate the following tasks,Improve Customer Satisfaction by providing above industry average performance in the following areas, • MTTR (Mean Time To Repair) • Backlog • Defect Ratio Increase Profit Margin to 25% by yearend 2007, and 30% by yearend 2008 by doing the following, • Achieve a Self Service Ratio of at least 30% by yearend 2007, and 40% by yearend 2008 • Achieve a Contract Renewal rate of at 90% by yearend 2007,and 95% by yearend 2008
October 29, 2007 15

1. Create a Framing Statement
A Good Framing Statement • Is Concise • Explicitly States Goals, Milestones, and Benchmark Comparisons • Has the Buy-in of your Key Team Members • Is your action plan that your performance dashboard will help your execute against
The performance dashboard for Company X’s Customer Service and Support Department will...