- This bot can handle data with a trend and explicitly supports univariate time series analysis with a seasonal component.
- The bot takes in the CSV file as input and performs the Seasonal ARIMAX and provides output in Excel.
- Help in performing seasonal time series analysis for a marketer to make data driven business decisions.
This bot forecasts trends such as seasonality for traffic, purchases, or other data you need to plan your business.
- An organization looking to forecast Daily, Weekly, Monthly product sales while being cautious of seasonality.
- A retail store planning inventory levels based on sales forecasts and seasonal variations.
- Path: Path of the CSV file. Ex.: C:~sales data-set.csv
- Column Count: Count of columns available in CSV file being provided with input data
- Input Column Names: Name of columns being provided in CSV file. For example 'Month', 'Sales'
- Input Column Data Type: Data Type of columns being provided in CSV file in the same order as column names. For example 'string', 'Date', 'Numeric'
- Missing Number Value Replacement: A value that can be used by the model in case CSV file has blank fields or missing numerical values
- Missing Date Value Replacement: A value that can be used by the model in case the CSV file has a blank field or missing a date value. This parameter should have value in the YYYY-MM-DD format. Ex: 2020-01-01
- Ignore Columns: Names of the column that model shall ignore while estimating forecasting. For example 'Sno'
- Retail Sales data of 105 months (1964-01-01 to 1972-09-01)
- The bot takes a CSV file as an input, performs the time-series analysis using SARIMAX algorithm and provides an output in Excel to forecast sales.
- Excel file
- Seasonal time series with predictions including upper and lower limits
- Bot Security Program
- Business Process
- Finance & AccountingMarketingSales
- Cognitive AutomationInsightsProductivity
- Automation Type
- Last Updated
- December 11, 2020
- First Published
- April 9, 2020
- Community Version
See the Bot in Action
Download the Bot and follow the instructions to install it in your AAE Control Room.
Open the Bot to configure your username and other settings the Bot will need (see the Installation Guide or ReadMe for details.)
That's it - now the Bot is ready to get going!
Requirements and Inputs
- Path: Path of the CSV file.