Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Team Metrics: Using the Team Dashboard Spreadsheet

This two-hour power-session discusses getting started and using the Team Dashboard spreadsheet offered for free by Focused Objective.


Learn how to use the  Team Dashboard spreadsheet to give teams a set of flow metrics without the hassle of managing a more complicated tool or process - you only need the story and defect start dates and finish dates. Join to hear the way this spreadsheet helps support and coach teams on how to spot flow issues, and visibly see the impact of process changes targeted by that team. By the end of this session, you will be able to set up, know what data to capture, how to interpret the charts and explain this to others. 


  1. Downloading and getting running
  2. Flow metrics 101
  3. Introduction to the Team Dashboard
  4. What do each of the charts mean
  5. Data capture good practices
  6. Excel compatibility
  7. Q & A

Learning objectives

  • How to get the spreadsheet
  • What every input means on this spreadsheet
  • The typical data capture and facilitation of teams using this dashboard
  • How to read and coach using each of the 20 different chart types
  • How to spot leading indicators and adverse trends in the dashboard
  • What settings you can change and what you shouldn't
  • Known limitations on different Excel and Google Sheets versions

About the Team Dashboard Spreadsheet

This spreadsheet generates over 20 charts from historical teams' data using just the Start Date, the Completed Date, and Type of stories or cards. The charts and dashboard computed covers all of the general flow-based metrics and some metrics you probably haven't seen before.

You can download it here for free:

Team Dashboard Spreadsheet Screenshot


Similar workshops

Call: Ask Me Anything: on Metrics & Forecasting

Zoom conference call + webinar on Metrics and Forecasting. I'll answer questions and if there are no questions I'll talk about something interesting!

More Information
Using the Monte Carlo Throughput Forecasting Spreadsheets

This two-hour online power-session discusses how to use the throughput and velocity forecasting spreadsheets. Learn how to quickly forecast.

More Information
Prioritization and Cost of Delay Calculation

Prioritization and Cost of Delay Calculation Power Session

More Information
Managing Blockers and Dependencies using "Blocked" (free)

How to capture, manage and eliminate Blockers and Dependencies using "Blocked"

More Information
Practical Metrics and Data Driven Coaching Essentials (online)

Learn how to capture, display, and coach Agile teams and organizations using data

More Information
Dependency Management Deep-Dive Workshop

Understand, plan and mange cross team dependencies better

More Information
Data-Driven Coaching for Teams Deep-Dive Workshop

How to use data to optomize team performance and flow

More Information

Press enter to see more results