Module name
Screenshot
Value
The Traffic Forecast sheet is the sheet used to make forecasts on dispensary traffic.
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 estimate the impact of an event on pharmacy traffic
You want to carry out advanced analyzes on a market
Data source
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
Staut
Subscription
Freemium
Objects present in the sheet
Functional cartridge
Dispensation / Volume / Volume per dispensation / GTIN per dispensation selector button
Mode selector button from Additive / Multiplicative decomposition
Learning period selector
Time selector
Confidence level slider
Prescription type selector
Forecast curve
KPIs for cumulative supernumerary for volume and dispensations
Average supernumerary KPIs for volume per dispensation and GTINs per dispensation
Supernumerary Analysis Bar Graph
Limitation
Quarterly and yearly forecasts do not have enough training data to be reliable enough
It is imperative to choose a learning period to obtain a visualization
Versions
Addition of different temporalities, granularity to the product
Added KPIs, changed sorting of bar chart
First version