Python for Business Forecasting Training Course

Duration 10 days 18 modules · 65 contact hours
Level Intermediate Certificate on completion
Who attends Financial Analysts, FP&A Managers and others
Fee from USD 2,200 KSh 190,000 for Kenyan organisations
Where 52 cities + online See dates by city
Next start 16 Nov 2026 Course code SD-DA-114

Before you join: Participants should be comfortable working with tables of business data and interpreting basic charts, percentages, growth rates and summary statistics.

Dates & prices

Two start dates a month in every city, and live online on weekdays or weekends. Fees are per participant; classroom fees include tuition, materials, lunch and refreshments, and the certificate.

Suggest a date or city

Showing the next six months. Later dates, other cities and private deliveries for your team are available on request.

Course overview

Business plans, budgets, supply commitments and investment decisions depend on forecasts that can be explained, tested and revised as new evidence arrives. Spreadsheet-based projections often obscure assumptions, fail to handle multiple drivers consistently and become difficult to audit. Python provides a practical environment for joining operational, financial and market data; producing repeatable forecasts; measuring forecast error; and testing management scenarios under stated assumptions.

This course teaches participants to build business forecasting and scenario-analysis workflows using Python. Participants prepare time-series data, explore trend and seasonality, establish benchmark forecasts, and apply methods including moving averages, exponential smoothing, ARIMA, regression and Prophet. They assess forecast accuracy with MAE, RMSE, MAPE and bias, select models against business requirements, and convert driver assumptions into base, upside and downside scenarios. The course also addresses hierarchical forecasts, intermittent demand, forecast governance, model monitoring and communication for non-technical decision-makers.

Instruction combines concise technical briefings with worked cases based on sales planning, cash forecasting, demand planning and workforce capacity. Participants write and review Python notebooks, interpret model output, test scenario assumptions and present forecast recommendations. They leave with a reusable forecasting notebook structure, validation checklist, scenario model and reporting template that can be adapted to their own datasets after the course.

The course suits analysts and managers who already work with business data and need to move from static projections towards documented, repeatable forecasting processes. It is particularly relevant to finance, commercial, operations, supply-chain and planning teams responsible for forecasts that influence decisions.

What you will be able to do

  • Prepare business time-series datasets using pandas, reproducible cleaning rules and documented data assumptions
  • Build baseline forecasts using naïve, seasonal naïve, moving-average and exponential-smoothing methods
  • Fit and interpret ARIMA, regression and Prophet models for business forecasting
  • Evaluate competing forecast models using MAE, RMSE, MAPE, bias and holdout validation
  • Construct driver-based base, upside and downside scenarios with transparent assumptions
  • Diagnose seasonality, outliers, structural breaks and intermittent-demand patterns in forecast data
  • Produce forecast reports with prediction intervals, model rationale and management recommendations
  • Present a validated Python forecasting and scenario-analysis model for a business decision

Benefits of attending

For you

  • Build repeatable forecasts rather than manually maintained spreadsheet projections
  • Defend model selection with documented accuracy evidence and business assumptions
  • Translate uncertain market conditions into quantified management scenarios
  • Identify forecast bias, model drift and unreliable demand signals earlier
  • Create Python notebooks suitable for portfolio evidence and workplace reuse

For your organisation

  • More consistent forecasting methods across finance, sales and operations teams
  • Clearer links between management assumptions and projected financial outcomes
  • Earlier visibility of forecast error, demand shifts and planning risks
  • Reduced manual rework through reusable Python-based forecast workflows
  • Better documented evidence for budget reviews, inventory decisions and investment cases

Course modules

18 modules over 10 days

Participants can frame a business forecasting question and organise a reproducible Python analysis workflow.

  • Forecast purpose, horizon and decision owner defined before model selection
  • Python environments, notebooks and package management for reproducible analysis
  • Business forecast workflow from source data to management decision
  • Granularity choices across product, customer, region and planning horizon
  • Actuals, forecasts, budgets and targets distinguished for reporting
  • Forecast assumptions recorded in a structured model specification

Participants can prepare usable time-series datasets from common business data extracts.

  • Pandas DataFrames created from CSV, Excel and database extracts
  • Date parsing, frequency alignment and calendar completeness checks
  • Missing observations treated using documented business rules
  • Duplicate transactions, returns and cancelled orders handled consistently
  • Aggregation from transactions to weekly or monthly forecast series
  • Data dictionaries capture fields, sources, transformations and known limitations

Participants can identify patterns and data issues that affect forecast design.

  • Line charts reveal level shifts, trend, seasonality and volatility
  • Seasonal plots compare recurring monthly, weekly and quarterly patterns
  • Rolling averages separate short-term noise from underlying movement
  • Outliers investigated using transaction evidence and operational context
  • Autocorrelation plots identify lagged dependence within demand series
  • Business events mapped against anomalies and structural changes

Participants can create benchmark forecasts and judge whether added complexity earns its place.

  • Naïve forecasts use the latest observed value as baseline
  • Seasonal naïve forecasts repeat values from comparable prior periods
  • Moving-average forecasts smooth short-term variation using selected windows
  • Drift forecasts extend historical movement over the planning horizon
  • Forecast value added compares process steps against simple benchmarks
  • Baseline performance establishes a minimum standard for advanced models

Participants can validate forecasts using appropriate error measures and time-based test designs.

  • Train-test splits preserve temporal order and prevent future-data leakage
  • Rolling-origin evaluation tests models across multiple forecast origins
  • MAE measures average absolute error in business units
  • RMSE assigns greater weight to large forecast misses
  • MAPE limitations assessed when actual values approach zero
  • Forecast bias identifies persistent overforecasting or underforecasting patterns

Participants can apply exponential-smoothing models to level, trend and seasonal business series.

  • Simple exponential smoothing forecasts stable series without trend
  • Holt's trend method estimates level and directional movement
  • Holt-Winters models represent additive and multiplicative seasonality
  • Smoothing parameters selected through out-of-sample forecast accuracy
  • Damped trends prevent implausible long-range extrapolation
  • Prediction intervals communicate expected ranges around point forecasts

Participants can fit, diagnose and interpret ARIMA-family models for suitable time series.

  • Stationarity assessed through plots, differencing and statistical tests
  • ARIMA orders represent autoregressive, differencing and moving-average components
  • Seasonal ARIMA captures repeated patterns at fixed calendar intervals
  • ACF and PACF plots inform candidate model specification
  • Residual diagnostics test independence, normality and remaining structure
  • Information criteria support parsimonious model comparison decisions

Participants can build regression forecasts that connect outcomes to measurable business drivers.

  • Driver hypotheses link sales, demand or costs to operational variables
  • Lagged variables represent delayed effects from campaigns and pricing
  • Calendar regressors capture holidays, paydays and trading-day effects
  • Multiple regression estimates driver contributions while controlling confounders
  • Multicollinearity checked using correlation analysis and variance inflation factors
  • Coefficient interpretation distinguishes association from operational causation

Participants can configure and assess Prophet models for series with multiple seasonal effects.

  • Prophet data format prepared using date and target columns
  • Trend changepoints model shifts in underlying business performance
  • Weekly, monthly and annual seasonalities configured from business evidence
  • Holiday effects model known events with distinct demand patterns
  • External regressors incorporated where future driver values are available
  • Cross-validation compares Prophet settings against benchmark forecast performance

Participants can select forecasting approaches for product-level demand and portfolio planning.

  • ABC analysis prioritises forecast effort by commercial value
  • Product lifecycle stages shape suitable history and model choices
  • New-product forecasts combine analogues, launch plans and judgement
  • Portfolio forecasts reconcile item-level and category-level demand signals
  • Promotional uplifts separated from baseline demand where evidence permits
  • Cannibalisation risks documented when product ranges change materially

Participants can diagnose intermittent demand and define suitable treatment for sparse series.

  • Intermittent demand identified through zero frequency and order intervals
  • Croston's method separately estimates demand size and arrival frequency
  • SBA adjustment reduces Croston forecast bias for sparse demand
  • Service-level requirements inform treatment of slow-moving stock items
  • Exceptions routed using thresholds for error, value and operational impact
  • Human overrides recorded with rationale, owner and expiry date

Participants can construct time-based cash forecasts from operational and financial drivers.

  • Receipts forecast from invoicing profiles, payment terms and collection rates
  • Payroll, supplier payments and tax dates mapped to cash timing
  • Working-capital drivers link inventory, receivables and payables assumptions
  • Thirteen-week cash forecasts distinguish committed and discretionary outflows
  • Revenue forecasts reconciled with cash receipts through collection lags
  • Liquidity headroom assessed against facilities, covenants and downside scenarios

Participants can create structured scenarios that show the effects of uncertain business drivers.

  • Scenario scope defines decision, forecast horizon and affected measures
  • Base case documents approved assumptions and central forecast values
  • Upside and downside cases vary plausible drivers consistently
  • Sensitivity analysis changes one driver while holding others constant
  • Two-way data tables show interactions between critical assumptions
  • Scenario narratives state triggers, consequences and management responses

Participants can quantify forecast uncertainty using simulation and probability-based measures.

  • Probability distributions selected from historical evidence and business constraints
  • Monte Carlo simulation generates ranges from uncertain driver assumptions
  • Correlation assumptions prevent implausible independent risk combinations
  • Percentile outputs express downside exposure and planning contingencies
  • Tornado charts rank drivers by effect on forecast outcomes
  • Simulation results translated into risk thresholds and decision actions

Participants can reconcile forecasts across organisational and product hierarchies.

  • Forecast hierarchies map corporate totals to regions, categories and products
  • Top-down allocation distributes aggregate forecasts using defined proportions
  • Bottom-up aggregation combines detailed forecasts into management totals
  • Middle-out methods balance category planning with local detail
  • Reconciliation checks ensure forecast totals agree across reporting levels
  • Allocation keys reviewed when customer mix or territories change

Participants can establish controls for maintaining credible business forecasting models.

  • Forecast calendars define data cut-offs, review meetings and publication dates
  • Model documentation records purpose, inputs, transformations and limitations
  • Version control preserves changes to code, data and assumptions
  • Accuracy scorecards track error, bias and forecast value added
  • Drift monitoring detects changing relationships between drivers and outcomes
  • Approval controls distinguish analyst forecasts from management adjustments

Participants can communicate forecast evidence, uncertainty and recommended actions to decision-makers.

  • Executive forecast summaries state outlook, drivers, risks and actions
  • Fan charts show prediction intervals across the planning horizon
  • Waterfall charts explain changes from prior forecast to current forecast
  • Variance bridges separate volume, price, mix and timing effects
  • Assumption registers make scenario inputs visible for challenge
  • Recommendations connect forecast evidence to specific management decisions

Participants can build, review and present a complete Python forecast and scenario analysis for a business decision.

  • Business question, decision owner and forecast horizon defined clearly
  • Source data prepared with documented quality checks and transformations
  • Benchmark and selected models compared using rolling backtests
  • Driver assumptions converted into base, upside and downside scenarios
  • Forecast uncertainty, key risks and response triggers quantified
  • Management report presents recommendation, rationale and implementation actions

Exercises and examples are adapted to each cohort's sectors and roles.

What you take back to work

  1. Python forecasting notebook template
  2. Time-series data-quality checklist
  3. Forecast model validation scorecard
  4. Driver-based scenario model
  5. Forecast assumption register
  6. Executive forecast reporting template

Who should attend

  • Financial Analysts — build auditable revenue, cost and cash-flow forecasts
  • FP&A Managers — strengthen planning cycles with driver-based scenarios
  • Business Analysts — translate operational data into decision-ready forecasts
  • Demand Planners — improve volume forecasts and exception review processes
  • Supply Chain Analysts — anticipate inventory, capacity and procurement requirements
  • Data Analysts — apply Python forecasting methods to commercial datasets

Skills and tools covered

Time-series forecastingScenario modellingForecast validationPython data preparationDriver-based planningForecast communication

Tools and standards

Python, pandas, statsmodels, Prophet

How the course runs

Training methodology

The course uses short instructor briefings followed by guided Python work, case analysis, group review and structured application planning. Cases use realistic sales, demand, cash-flow and capacity datasets with missing values, promotions, outliers and changing conditions. Participants compare model outputs, challenge assumptions, interpret error metrics and communicate findings to decision-makers. Simulations introduce revised demand and cost assumptions, requiring participants to update scenarios and explain the consequences. Trainers provide feedback on notebook structure, forecast validity and reporting clarity.

Requirements and prerequisites

Participants should be comfortable working with tables of business data and interpreting basic charts, percentages, growth rates and summary statistics. Prior experience with Excel formulas, SQL queries or another analytical tool is useful. Participants should have introductory Python knowledge: variables, lists, functions, loops and reading a CSV file. They do not need prior experience with time-series modelling, machine learning, calculus, advanced statistics or Python forecasting libraries. The course explains the business purpose and interpretation of each forecasting method before applying it.

A typical training day

08:30 – 10:30First session
10:30 – 10:45Refreshment break
10:45 – 12:30Second session
12:30 – 13:30Lunch and networking
13:30 – 15:00Third session
15:00 – 15:15Refreshment break
15:15 – 16:30Workshop and daily review

Live online deliveries follow the same structure in East Africa Time, with shorter screen blocks and longer breaks.

What the fee includes

  • Instruction by a practitioner facilitator
  • Full course workbook and materials
  • Exercise files, templates and case studies
  • Refreshments and lunch on classroom deliveries
  • Certificate of completion
  • Post-course application plan

Frequently asked questions

You should be able to work with basic Python syntax, variables, lists, functions and CSV files. You do not need prior experience with pandas, statsmodels, Prophet or time-series modelling.

Bring a laptop capable of running Python and, where permitted, a small non-sensitive dataset or forecasting problem from your work. Trainers provide course datasets and setup guidance for the required software environment.

It is designed for analysts, planners and managers who produce or review revenue, demand, cost, cash-flow or capacity forecasts. It is not intended as a first course in Python programming.

The course concentrates on time-ordered business data, forecast validation, scenario assumptions and decision communication. General analytics courses may cover broader data preparation and visualisation, while machine-learning courses often focus on classification or prediction without planning-cycle controls.

Participants can adapt the notebook structure, validation scorecard and scenario model to recurring planning work. The methods apply to sales, demand, cash, staffing, inventory and operational-volume forecasts where historical data and stated assumptions are available.

Each day runs from 08:30 to 16:30 and provides about 6.5 contact hours. The first week establishes Python workflows, data preparation and core forecasting models; the second week covers scenarios, risk, governance, reporting and the capstone presentation.

Questions about this course?

Ask about dates, fees, group bookings or running it for your team. Our training team replies by email.