Time-Series Analysis

Break down your market into Season, Trend and Noise

Written by Anthony Cabos
Updated over a week ago

Module name

Trigram: TSA



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

Geographical 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:

  • Addition of the "Data Input" Warning


  • Addition of the "Data Input" Warning

  • Variability of the subscription within the cartridge.

Did this answer your question?