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.
What you'll learn
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.
Table of contents
- Complete 100% of the Work 80% of the Time 3m
- Downloading Statistical PERT 4m
- Demo: Introducing the Agile Forecast Tab (SPERT Normal Edition) 7m
- Demo: Forecasting with Higher Probabilities 3m
- Demo: Examining the Normal Distribution 3m
- Demo: Forecasting for Established Teams 2m
- Demo: Release Forecasting 1m
- Demo: Forecasting with Hard Delivery Dates 2m
- Demo: Introducing the Agile Forecast Tab (SPERT Beta Edition) 3m
- Module Summary 1m
- Forecasting for Established Teams 3m
- Demo: Calculate a Standard Deviation from Historical Data 5m
- Demo: Forecast a Single Iteration 2m
- Demo: Setup for a Multiple Iterations Forecast 2m
- Demo: Forecast Multiple Iterations 4m
- Demo: Calculate a Finish Date Manually 1m
- Demo: Forecast Using Most Recent Team History 4m
- Demo: Forecast for a Team's Varied Capacity 2m
- Module Summary 1m
About the author
William W. Davis works in the IT industry promoting personal and organizational agility and sharing innovative tools/techniques with fellow agilists, project managers, developers, functional managers, and organizational leaders. William has 30 years experience working in IT as a software developer and technical project manager for numerous IT projects. More recently, though, William is a Scrum Master and an organizational agilist -- creating/delivering customized agile/Scrum training, offering a... more
