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.
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.
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.