Time-Series Sectorial Analysis

Module name

Trigramme: TSSA

v2011120945

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 according to your territories

• You want to know the evolution of the components of your market according to your territories in order to deduce their maturity

Data source

• Pharmacies data officinal

• GSA drugstore data

Geographic 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

• Area / Sector selectors
  

• 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

Versions

Current version:

Time-Series Analysis Sectorial v2011120945

• Added multi-converted units selector

versions:

Time-Series Analysis Sectorial v2009251424

• Addition of the Warning "Data Input"

target"> Sectorial Analysis v2005051144

• Recipe module in this standard version. No changes to report.

Time target Analysis> v2003271914

• Standardization of the placement of "Reload Time" on the SMA standard

Time-Series Sectorial Analysis v2003201218

• First version