Forecast the #NoEstimates Way
Forecasting the amount of work a project requires is a challenge. This course will teach you how to forecast using the #NoEstimates way, using bootstrapping as a forecasting method that you can apply using a pre-built or a blank excel model.
What you'll learn
Managers are faced with many challenges and inefficiencies, particularly in estimating or forecasting the amount of time or work it takes to complete a task or project. In this course, Forecast the #NoEstimates Way, you’ll learn to forecast using the #NoEstimates way by using bootstrapping as a forecasting technique which you can apply using a pre-built and a blank excel model. First, you’ll learn what an estimate is according to the #NoEstimates movement. Next, you’ll discover about bootstrapping as a forecasting technique including what it can and cannot do. Finally, you’ll learn how to apply bootstrapping to a pre-built and blank excel-based model. When you’re finished with this course, you’ll have the skills and knowledge of bootstrapping using excel as a forecasting technique which is needed to do forecasting through the #NoEstimates way.
Table of contents
- Bootstrapping Definition and Relevance 8m
- Bootstrap Estimates Definition 3m
- Scope of Bootstrap Estimates 4m
- Limitations of Bootstrap Estimates 4m
- Excel Functions needed to Bootstrap: Index, Average, Median, Quartile 6m
- Excel Functions needed to Bootstrap: Stdev, Frequency, Small 4m
- Demo: Identifying Scope and Limitation of Using Bootstrap Estimates 8m
- Monte Carlo Simulation Definition and Characteristics 6m
- Uniform Distribution & Definition and Illustration 2m
- Pre-built Excel-based, Monte Carlo Simulation Model, & Using Uniform Distribution 7m
- Applying Bootstrapping, Using the Pre-built Excel-based, & Monte Carlo Simulation Model: New Information 3m
- Applying Bootstrapping, Using the Pre-built Excel-based, & Monte Carlo Simulation Model: Process Demonstration 9m
- Demo: Applying Bootstrapping Using a Pre-built Excel-based Model 6m
- Setting up a Blank Excel-based Model: Inventory Control Problem 3m
- Setting up a Blank Excel-based Model: Inputs 3m
- Setting up a Blank Excel-based Model: Inventory Management Model 8m
- Setting up a Blank Excel-based Model: Inventory Cost Model 3m
- Applying Bootstrapping using a Blank Excel-based Model 5m
- Bootstrapped Forecast Definition and Evaluation Criteria 3m
- Bootstrapped Forecast Results Evaluation 4m
- Demo: Applying Bootstrapping using a Blank Excel-based Model: Case Scenario 4m
- Demo: Applying Bootstrapping using a Blank Excel-based Model: Answer for Modeling and Bootstrapping 6m
- Demo: Applying Bootstrapping using a Blank Excel-based Model: Answer for Evaluation 3m
About the author
She is the Co-founder as well as Strategy Lead of AtoANI (sustainable agriculture) and AtoANI BioPack (biodegradable packaging). She is passionate about Social Innovation and using it to contribute to the UN Sustainable Development Goals. With a Chemical Engineering and MBA Degree, her corporate experience in multinational companies involves working on various topics in the areas of Strategy, Digitalization, Innovation, Finance, Material Management, Quality Assurance, Program and Project Managem... more