Time-Series Sectorial Analysis

Break down your market into trend, season, noise

Written by Anthony Cabos
Updated over a week ago

Module name

Trigramme: TSSA




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

Geographic territories

  • Metropolitan France data


  • No limitation on the size of the markets

  • Applicable to human medicinal products, veterinary medicinal products and non-medicinal products



Sales & Marketing Advanced

Objects found in the sheet

Indicators & measures


  • "Prescription" selector (Exclusively pharmacies data)


  • NA


  • 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


Current version:

  • Added multi-converted units selector


  • Addition of the Warning "Data Input"

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

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

Time-Series Sectorial Analysis v2003201218

  • First version

Did this answer your question?