Built a 'Forcast model' in excel to create 3 year prediction on time-related data. Forecasting is an area of particular interest for data analysts.
- Downloaded a .csv 'sales data' file from kaggle.
- Transform data in .xlsx
- Apply forcast sheet
- Set confidence Interval at 95%
- Set seasonality pattern and timeline range
