How Does the Forecasting Module Calculate Time Periods and Handle Seasonality Settings?
The forecasting module in Confido provides robust tools for calculating forecasts across different time periods and managing seasonality settings. Below is an overview of how these functionalities work:
Overview of Forecasting Calculations
The forecasting module calculates data for various time periods—month, quarter, and year—by summing the days that fall within each respective time frame. This ensures accurate aggregation of data for each period.
Time Period Calculations
Monthly View: Data is aggregated based on all days within the specific month.
Quarterly View: Data is summed for all days within the three months of the quarter.
Yearly View: Data is calculated by summing all days within the calendar year.
Seasonality Matrix Application
The seasonality matrix in the forecasting module is designed to simplify the application of seasonal adjustments across years. If a seasonality matrix is already set in the Forecast Settings for a prior year, it automatically applies to subsequent years. This eliminates the need for manual reloading unless changes to the matrix are required.
Key Points on Seasonality
The seasonality matrix is predefined and applies automatically to future years.
Manual adjustments are only necessary if you wish to modify the existing matrix.
To configure a seasonality matrix, access the seasonality configuration settings, define the seasonality factors for each period (e.g., months or quarters), and save the matrix to apply it automatically to all future forecasts.
If the Seasonality Index field is greyed out at the customer level, delete the existing seasonality configuration and re-upload the data using the bulk upload template. During the upload, selectively apply seasonality to specific customer groups or forecast versions as needed.
Automation and Predefined Settings
The forecasting module emphasizes automation to reduce manual effort. By leveraging predefined settings, such as the seasonality matrix, users can ensure consistency and accuracy in their forecasts without additional configuration. By understanding these functionalities, users can effectively utilize the forecasting module to manage and analyze data across different time periods and ensure accurate seasonal adjustments.
Best Practices for Seasonality Management
Regularly review and update seasonality matrices to reflect changes in patterns or trends.
Use the bulk upload feature for efficient updates, especially when managing large datasets.
Test changes in a sandbox environment before applying them to live forecasts.