Skip to content
Gallery
Gwendolyn Ang - BI Portfolio
Share
Explore
Part 2: Querying & Data Analysis

icon picker
Forecasting Methods Evaluation

Temporary Table

Summary Table

Moving Average with Window Size Optimization

See code for window size optimization

Exponential Smoothing with Alpha Value Optimization

See code for alpha value optimization


Seasonal Ratio

Step 1: Calculate CAGR

Seasonal Decomposition: Analyze the effectiveness of this method.
Step 3:

Step 2: Calculate seasonal indices per division

Step 3: Create forecast



Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.