Forecasting for Agile Teams

Learn how to create an agile sprint or release forecast using the built-in statistical functions of Microsoft Excel. Assess and improve the quality of your forecasts, and learn how to share your forecasts with stakeholders.
Course info
Level
Intermediate
Updated
Sep 11, 2019
Duration
2h 48m
Table of contents
Course Overview
Why Do We Forecast Agile Development Efforts?
Estimate Your Product Backlog
Using Statistical PERT’s Agile Forecast Tab
Creating More Refined Forecasts
Improving Your Forecasts
Communicating Your Forecasts to Stakeholders
Description
Course info
Level
Intermediate
Updated
Sep 11, 2019
Duration
2h 48m
Description

In this course, Forecasting for Agile Teams, you will create and share forecasts for your agile software development effort. First, you will learn why forecasting is important. Next, you will discover how to forecast using Microsoft Excel and a freely-licensed spreadsheet file called Statistical PERT. Finally, you will explore how to improve your forecasts and effectively share them with stakeholders. When you're finished with this course, you will have the skills and knowledge of agile forecasting so you can forecast future agile-developed products.

About the author
About the author

William is an experienced Scrum Master, agilist, and project manager who creates positive transformations through training, coaching, and mentoring software development teams.

More from the author
Easily Estimate Projects and Products
Beginner
2h 51m
Mar 14, 2019
Scrum Essentials Exam Prep
Intermediate
3h 8m
Oct 8, 2018
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, I'm William W. Davis, and welcome to my course, Forecasting for Agile Teams. I'm a scrum master, project manager, and agilist living in South Florida. Forecasting release dates for agile-developed software is hard for many product owners and Agile team members. With Agile, there are no schedules, but stakeholders still want to know when they can ship or deploy new products. This course will introduce you to agile forecasting using an estimation technique called Statistical PERT. You'll find that Statistical PERT makes it easy to forecast agile release dates and determine how much work to bring in to your next planning cycle, like a scrum sprint. In this course, I'll cover these major topics: understanding why forecasting is an important skill, discovering how to very quickly estimate everything on your product backlog, using Statistical PERT to forecast possible agile delivery dates, creating more refined forecasts using your team's historical data and available capacity, and effectively sharing your forecasts with stakeholders. By the end of this course, you'll know how to create agile iteration and release forecasts using nothing more than the built-in functions inside Microsoft Excel. Before beginning this course, you should be familiar with basic statistical terms and have a working knowledge of Microsoft Excel. Please join me to learn how you can create forecasts with the Forecasting for Agile Teams course, right here at Pluralsight.