Designing a Performance Dashboard

Mauro Cardarelli
mauro.cardarelli@jornata.com

Thoughts:

You cannot manage what you do not measure

What gets watched get's done

Probably the most difficult part is getting clean data

Two ways to measure and watch performance; scorecards and dashboards.

A scorecard is an individual indicator that monitors one type of information. A dashboard is a compilation of multiple scorecards, charts, graphs and documents.

A dashbord does the following:

• Measures performance
• Consolidates multiple real time feeds
• Can be event driven
• Contains

• Scorecards
• Charts
• Graphs
• Documents/Feeds
• Reports

Dashboard lifecycle:

• Design
• Manage (Design Data In/Develop Data Out)
• Synthesize (Make sure data is right)
• Store
• Deliver

Tools:

• Presentation:
  • MS Web Components
  • ChartFX
  • Dundas
  • MS Business Scorecard Manager
  • MS Reporting Services
• Storage:
  • MS SQL Server Analysis Services(SSAS
  • SQL Server
  • Excel
  • Manual