Public resources for the book Team Guide to Metrics for Business Decisions by Mattia Battiston and Chris Young (http://bizmetricsbook.com/)
We have created some example spreadsheets to demonstrate what we are talking about in the book. Feel free to use them, copy them, edit them as you like - they should help you get started with metrics for your business decisions!
You can find them all in this public folder in google drive: example spreadsheets
The folder contains the following spreadsheets:
- Are my story points predictable? Many teams rely on story points to give them predictability and answer questions like "How long will this story take? When are we going to complete these stories? How much can we achieve in the next two weeks?". But is that really giving you any predictability? Use this spreadsheet to verify whether there is correlation between your estimates (story points) and how long stories actually take (lead time).
- Throughput - Stats & Trend Find out how many stories you're completing in each iteration/sprint and analyse your data to make better business decisions. Answer questions like "How many stories can we complete in the next iteration?" and "Are we improving?"
- Throughput - Simple Project Forecasting Use your throughput to make simple predictions and answer questions like "When will this project/functionality be done?" and "Which stories can we complete in the next iteration?"
- Probabilistic Forecasting Use your past throughput to forecast the future. Answer questions like "How long is it going to take to complete these N stories?" "What can I get in the next X sprints?" "Is this feature going to be ready by sprint X?" "Which feature should we work on next?"
- Forecasting number of stories Sometimes it's not feasible to break down all the requirements upfront to find the total number of stories to complete, especially for big projects. Just break down a few epics (5-7 is good enough to get started) and then use this spreadsheet to forecast how many stories you are going to have in total.
(note: the examples are a read-only version. In order to use them use the menu "File/Make a copy" to copy them)
- Example Trello Board We have created an example Trello board that demonstrates how you can track information for your stories, including the sprint when they were completed to easily calculate your Throughput.