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.

Description

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. 

Agenda

  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: https://github.com/FocusedObjective/FocusedObjective.Resources/raw/master/Spreadsheets/Team%20Dashboard.xlsx

Team Dashboard Spreadsheet Screenshot

 

Similar workshops

Forecasting + Metrics Combo

Combine the Forecasting and Planning using Data and the Agile Metrics and Coaching using Data for a 2-day masterclass in using data for team coaching, organizational improvement, and planning.

More Information
Agile Metrics and Coaching using Data

Learn how to design, capture and display data for organization and team improvement.

More Information
Call: Ask Me Anything: on Metrics & Forecasting

Monthly 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

Press enter to see more results