Explanation

Good forecasting requires properly organized historical data.

Recommended Structure

Date

Sales

01-Jan-2026

40000

01-Feb-2026

45000

01-Mar-2026

48000

01-Apr-2026

52000

01-May-2026

55000

01-Jun-2026

60000

Important Requirements

  • Dates should be in chronological order.
  • Time intervals should be consistent.
  • Values should be numeric.
  • Avoid unnecessary blank rows.
  • Use clear column headings.

Practice

Prepare a 12-month sales dataset suitable for forecasting.