Time-Series Analysis

Module name

Trigram: TSA

v2011101605

Screenshot

Value

The Time-Series Analysis sheet is the sheet that allows break down your sales values and volumes into its three components:

• The trend
• The season
• Noise or residue

This sheet is based on the Python OpenSource Prophet library made by Facebook. The PyTools 5.1 connector has been integrated into QLIK to achieve this decomposition. The decomposition method used in this library is based on the ARIMA calculation method.

This module is for you if:

• You want to understand which components are the engines of your market
• You want to know the evolution of the components of your market in order to deduce their maturity

Data source

• Pharmacies data officinal
• GSA drugstore data

Geographical territories

• Metropolitan France data

Market

• No limitation on the size of the markets
• Applicable to human medicinal products, veterinary medicinal products and non-medicinal products

Status

Subscription

Sales & Marketing Advanced

Objects found in the sheet

• Functional cartridge
• Explanatory cartridge
• Turnover / Volume selector button
• Mode selector button from Additive / Multiplicative decomposition
• Company selector
• Seasonal variance rates
• Rate of variance Trend
• Rate of variance Residual
• Evolution of the coefficient of variation
• Selectors of the learning period
• Evolution curve observed
• Curve of the trend component
• Seasonal component curve
• Curve of the residual component

Indicators & measures

• Sales Volume
• Sales Value
• Variance rate

Options

• "Prescription" selector (Exclusively pharmacies data)

Compatibilities

• NA

Limitations

• The apprenticeship period must be at least 25 months
• The choice of several parameters at the same time can stop the display of the curve

Version

Current version:

Time_607g target Analysis>

• Addition of the "Data Input" Warning

versions:

Time-Series Analysis v2009141637

• Addition of the "Data Input" Warning

Analysis v2004271727

• Module accepted on version target=200 of the standard; no changes compared to the version v2004070930 of this module

Time-block> Series Analysis v2004070930

• Variability of the subscription within the cartridge.

v2001301601