Skip to main content

Forecast Analysis

The Forecast Analysis data model combines historical sales data with projected quantities for demand and revenue forecasting. It includes measures like quantity sold, dollars sold, cost of goods sold, and quantity projected. Use it to compare past sales against future projections and analyze demand patterns by item or customer.

How to use this data model​

  • Compare actual sales against projections to see how forecasted quantities line up with what was actually sold.
  • Review demand patterns by item or period to understand seasonality and plan accordingly.
  • Analyze revenue and cost trends using historical dollars sold and COGS to support budgeting and planning.

Available views​

ViewTypeWhat it shows
Forecast AnalysisWorksheetShows historical sales alongside projected quantities with dollars sold, COGS, and quantity metrics.