We may earn an affiliate commission when you visit our partners.
William Davis

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.

Read more

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.

Enroll now

Here's a deal for you

We found an offer that may be relevant to this course.
Save money when you learn. All coupon codes, vouchers, and discounts are applied automatically unless otherwise noted.

What's inside

Syllabus

Course Overview
Why Do We Forecast Agile Development Efforts?
Estimate Your Product Backlog
Using Statistical PERT’s Agile Forecast Tab
Read more
Creating More Refined Forecasts
Improving Your Forecasts
Communicating Your Forecasts to Stakeholders

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Teaches Microsoft Excel, which is strongly relevant to industry
Taught by William Davis, who is recognized for their work in facilitating agile teams and increasing developer productivity through statistical modeling
Develops skills and knowledge that are highly relevant to agile software development
Teaches a strong foundation in statistical modeling for agile teams
Builds from introductory knowledge of agile and statistical modeling
Does not provide a certificate of completion

Save this course

Save Forecasting for Agile Teams to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Forecasting for Agile Teams with these activities:
Review basic statistical concepts
Ensure a solid foundation for understanding forecasting techniques.
Browse courses on Statistics
Show steps
  • Review notes or online resources
  • Practice solving simple statistical problems
Compile a glossary of forecasting terms
Build your understanding of key forecasting concepts.
Show steps
  • Gather definitions from course materials and other sources
  • Organize the terms alphabetically or by category
  • Review the terms regularly
Follow Microsoft Excel forecasting tutorials
Enhance your Excel skills specifically for forecasting.
Browse courses on Microsoft Excel
Show steps
  • Search for online tutorials or courses
  • Follow the instructions and complete the exercises
  • Apply what you learn to your own forecasting projects
Seven other activities
Expand to see all activities and additional details
Show all ten activities
Review Agile Estimation and Planning
Gain insights into agile estimation and forecasting from an industry expert.
Show steps
  • Read the book
  • Take notes and highlight key concepts
  • Discuss the book with colleagues or a study group
Estimate Software Development Effort
Practice estimating the effort required to complete software development tasks to refine your forecasting skills.
Browse courses on Story Points
Show steps
  • Identify and define the scope of the development task.
  • Break the task into smaller, manageable subtasks.
  • Estimate the effort required for each subtask.
  • Sum the effort estimates for all subtasks to estimate the total effort.
Join a study group
Discuss course materials with other students to synthesize your understanding.
Show steps
  • Locate a group or form your own
  • Set regular meeting times
  • Review course materials in advance
  • Take turns leading discussions
Create Excel Pivot Tables and Charts
Create and format Excel pivot tables and charts to refine your forecasting skills.
Browse courses on PivotTables
Show steps
  • Open a spreadsheet with raw data.
  • Insert a pivot table and customize to visualize data.
  • Create pivot charts based on pivot table data.
Solve practice problems
Reinforce your understanding of statistical forecasting techniques.
Browse courses on Statistical PERT
Show steps
  • Locate practice problems online or in textbooks
  • Set aside dedicated practice time
  • Review solutions to check your work
Discuss Agile Forecasting Techniques
Engage with peers to discuss various agile forecasting techniques and best practices to expand your knowledge.
Show steps
  • Join or create a study group or online forum focused on agile forecasting.
  • Initiate discussions on different agile forecasting techniques and their applications.
  • Share experiences, insights, and challenges in using these techniques in real-world projects.
  • Collaborate on developing and refining your own agile forecasting approach.
Develop a custom forecast template
Tailor statistical forecasting to your specific agile team's needs.
Show steps
  • Identify the key metrics to track
  • Design a spreadsheet or use Statistical PERT
  • Test and refine the template
  • Implement the template for your team

Career center

Learners who complete Forecasting for Agile Teams will develop knowledge and skills that may be useful to these careers:
Software Development Manager
A Software Development Manager leads a team of software developers in designing, developing, and delivering high-quality software products. This course can provide the foundational knowledge and skills needed to make forecasts for agile software development projects, which can be essential for planning and managing development efforts. By completing this course, you will gain a deeper understanding of the forecasting process and be able to use statistical techniques to create more accurate forecasts, which can help you as a Software Development Manager in making informed decisions and successfully leading your team.
Agile Coach
An Agile Coach facilitates and guides agile software development teams in adopting and implementing agile practices and principles. By taking this course, you will learn how to forecast using Microsoft Excel and a freely-licensed spreadsheet file called Statistical PERT, which can help you as an Agile Coach in providing valuable insights and guidance to teams on how to improve their forecasting processes.
Project Manager
A Project Manager plans, executes, and closes projects, ensuring they are completed within the defined scope, time, and budget. This course can help you gain a solid understanding of the forecasting process and how to use statistical techniques to create accurate forecasts. By completing this course, you'll be better equipped to manage project timelines and budgets, and make informed decisions throughout the project lifecycle.
Business Analyst
A Business Analyst gathers and analyzes business needs and requirements to define solutions that meet the needs of the organization. This course can provide you with the necessary skills to create forecasts for agile software development projects, which can be crucial for understanding and communicating the potential impact of business decisions. The knowledge gained from this course can help you make informed recommendations and support decision-making processes within the organization.
Data Analyst
A Data Analyst collects, analyzes, and interprets data to identify trends and patterns. This course can provide you with the foundation to use statistical techniques to analyze data and create more accurate forecasts. By completing this course, you will gain a deeper understanding of data analysis and be able to use statistical methods to extract valuable insights from data, which can be highly valuable in your role as a Data Analyst.
Software Tester
A Software Tester evaluates software products to ensure they meet quality standards. This course can help you build a foundation in forecasting for agile software development projects, which can be beneficial in planning and executing testing activities. By completing this course, you will gain a better understanding of the forecasting process and be able to use statistical techniques to create more reliable forecasts, which can contribute to the successful delivery of high-quality software products.
Product Manager
A Product Manager defines the vision and roadmap for a software product, and works closely with the development team to ensure the product meets the needs of the users. This course can be useful in understanding the forecasting process and how to use statistical techniques to create accurate forecasts. By completing this course, you will gain a deeper understanding of agile development methodologies and be able to use statistical methods to estimate and forecast project outcomes, which can help you prioritize features, make informed decisions, and effectively manage the product roadmap.
Scrum Master
A Scrum Master facilitates and supports agile software development teams in adopting and implementing Scrum principles and practices. This course may be helpful in gaining a basic understanding of agile forecasting and how to use statistical techniques to improve forecasts. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical methods to analyze data, which can assist you in supporting teams in planning and executing sprints, and continuously improving the development process.
Software Developer
A Software Developer designs, develops, and implements software systems. While this course may not be directly related to the technical skills required for software development, it can provide a basic understanding of forecasting for agile software development projects, which can be beneficial in understanding project timelines and milestones. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical techniques to analyze data, which can contribute to better collaboration with other team members and a better understanding of the overall development process.
Quantitative Analyst
A Quantitative Analyst uses mathematical and statistical models to analyze data and make predictions. This course may be useful in gaining a basic understanding of forecasting and how to use statistical techniques to analyze data. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical methods to analyze data, which can contribute to your ability to develop and implement quantitative models.
Business Intelligence Analyst
A Business Intelligence Analyst analyzes data to identify trends and patterns, and provides insights to support decision-making. This course may be useful in gaining a basic understanding of forecasting and how to use statistical techniques to analyze data. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical methods to analyze data, which can contribute to your ability to identify trends and patterns, and develop predictive models.
Data Scientist
A Data Scientist uses scientific methods, processes, algorithms, and systems to extract knowledge and insights from data. This course may be useful in gaining a basic understanding of forecasting and how to use statistical techniques to analyze data. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical methods to analyze data, which can contribute to your ability to identify trends and patterns, and develop predictive models.
Market Researcher
A Market Researcher conducts research to understand market trends and customer behavior. This course may be useful in gaining a basic understanding of forecasting and how to use statistical techniques to analyze data. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical methods to analyze data, which can contribute to your ability to conduct market research and develop effective marketing strategies.
Financial Analyst
A Financial Analyst analyzes financial data to make investment recommendations. This course may be useful in gaining a basic understanding of forecasting and how to use statistical techniques to analyze data. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical methods to analyze data, which can contribute to your ability to make informed investment decisions.
Operations Research Analyst
An Operations Research Analyst uses mathematical and analytical techniques to solve complex business problems. This course may be useful in gaining a basic understanding of forecasting and how to use statistical techniques to analyze data. By completing this course, you will gain some knowledge of the forecasting process and be able to use statistical methods to analyze data, which can contribute to your ability to develop and implement optimization models.

Reading list

We've selected 11 books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Forecasting for Agile Teams.
Provides a practical guide to agile estimating and planning. It covers topics such as how to estimate user stories, how to create a release plan, and how to track your progress. It is an excellent resource for anyone who wants to learn more about agile estimation and planning.
Provides a comprehensive overview of Scrum, an agile software development framework. It covers topics such as the Scrum roles, the Scrum process, and the Scrum values. It valuable resource for anyone who wants to learn more about Scrum.
Provides a practical guide to Kanban, an agile software development method. It covers topics such as how to create a Kanban board, how to use Kanban to track your work, and how to improve your Kanban process. It is an excellent resource for anyone who wants to learn more about Kanban.
Provides a comprehensive overview of Lean software development, a set of principles and practices for developing software more efficiently and effectively. It covers topics such as the Lean principles, the Lean tools, and the Lean mindset. It valuable resource for anyone who wants to learn more about Lean software development.
Provides a practical guide to the Lean Startup methodology, a process for developing new products and services quickly and efficiently. It covers topics such as how to validate your ideas, how to build a minimum viable product, and how to measure your progress. It is an excellent resource for anyone who wants to learn more about the Lean Startup methodology.
Save
Provides a practical guide to Scrum, an agile software development framework. It covers topics such as the Scrum roles, the Scrum process, and the Scrum values. It is an excellent resource for anyone who wants to learn more about Scrum.
Provides a practical guide to Kanban for project management. It covers topics such as how to create a Kanban board, how to use Kanban to track your work, and how to improve your Kanban process. It is an excellent resource for anyone who wants to learn more about Kanban for project management.
Provides a practical guide to user story mapping, a technique for visually representing the user stories for a software product. It covers topics such as how to create a user story map, how to use a user story map to plan your development work, and how to use a user story map to communicate with stakeholders. It is an excellent resource for anyone who wants to learn more about user story mapping.
Provides a comprehensive overview of agile software development, covering topics such as the agile principles, the agile values, and the agile practices. It valuable resource for anyone who wants to learn more about agile software development.
Provides a comprehensive overview of agile software engineering, covering topics such as the agile principles, the agile values, and the agile practices. It valuable resource for anyone who wants to learn more about agile software engineering.
Provides a comprehensive overview of software estimation, covering topics such as the different types of estimation, the different estimation techniques, and the different factors that affect estimation accuracy. It valuable resource for anyone who wants to learn more about software estimation.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Here are nine courses similar to Forecasting for Agile Teams.
Easily Estimate Projects and Products
Most relevant
Forecast Answers to Agile Team Questions
Most relevant
Judgmental Business Forecasting in Excel
Most relevant
Time Series Forecasting with Amazon Forecast
Most relevant
Forecasting Skills: See the Future Before it Happens
Most relevant
Excel Time Series Models for Business Forecasting
Most relevant
Sharing Effective Visual Forecasts
Most relevant
Conduct Sales Projections with Seasonality in Google...
Most relevant
Impute Data to Forecast Demand in Google Sheets
Most relevant
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2024 OpenCourser