Basic Settings of Analyses
Quant allows a number of useful analyses to be used. A majority of them can be found in the Quant Explorer – Analysis menu. The purpose of this manual is to explain frequently occurring criteria that are common to several analyses. Not all criteria available to each analysis are described here. A number of them can be found in manuals describing specific analyses as such criteria are typical of the given analysis only. Not to have to explain all criteria in each manual covering a specific analysis, we have created a document describing frequently occurring criteria.
The Basic Settings of Analyses manual provides a description of the following criteria:
Time Interval
Sales
- Value Type
- Clusters
- Booking Types
- Ignore Follower Products
- Calculate Average Cluster
- Calculate Average Days, Number of Average Days
Space
Time Interval
Start and End Periods
For each analysis remember to set the period from which Quant will take data on sales for the analysis.
Daily, Start and End Date
For Development analyses it is possible to indicate the “Daily” checkbox and then select a certain period. The analysis will then show a development of sales for each day of the period set in the Start Date and the End Date lines.
Sales
Value Type
Here you can select whether you wish to be displayed data concerning the number of sold pieces, margins or other data that you upload to Quant.
Clusters
Various clusters are uploaded to Quant. In our case always one cluster is uploaded on behalf of the specific store and therefore in the analysis we can choose the stores whose sales we want to analyse.
Booking Types
The booking type option specifies the method by which the product was sold – whether it was sold, for example, on prescription (at the pharmacies), over the counter or ordered via the e-shop and the customer only came to the store to collect it. If you distinguish booking types, you can select from the products only those that were sold over the counter and analyse only these products. On the other hand, if you upload no data on booking types to Quant, you can ignore this setting option. In such a case, the Other option will be available instead of Booking Types.
Ignore Follower Products
Products are sometimes set followers in Quant. This setting option is used if one product is being phased out and is to be replaced by a very similar product. In this case it is advisable to use the predecessor's sales history to count the sales of the new product together with the sales of the previous one to make it easier to assess how well the new product will sell.
But sometimes we need to count either only the previous or only the new products. This is enabled by indicating the “Ignore Follower Products” checkbox.
Calculate Average Cluster
We will analyse 6 clusters where each cluster represents the sales of one specific store.
- Marked = Quant counts the average value of sales for one store during the given period, i.e. the total sales are divided by 6.
When will you use marked "Calculate Average Cluster"?
If you want to calculate the average value of sales for one cluster based on all clusters analysed for the respective period.
- Not marked = Quant shows the total sales in all stores during the given period – the accumulated value of sales in all 6 stores.
When will you use not marked "Calculate Average Cluster"?
If you want to calculate the total value of sales resulting from all analysed clusters.
Setting average days
The setting always consists of two parts:
- Calculate Average Days
- Number of Average Days
Based on this setting Quant calculates the average sales for the number of days set in the Number of Average Days criterion for each month.
Set the Number of Average Days equal 1. Calculation: (All sales of the analysed products during 1 month added up / the number of days in the month) x 1. Quant calculates the average sales for 1 day.
Set the Number of Average Days equal 7. Calculation: (All sales of the analysed products during 1 month are added up / the number of days in the month) x 7. Quant calculates the average sales for 1 week (7 days).
Space
In the space section the following 4 criteria are set:
Stores
Select from the list which stores or groups of stores should be analysed.
Floorplan Date
The Store Editor creates the version of layers and sets the start date for them. When such a date arrives, the previous version of layer expires and the new version comes into force. For this reason you can choose the date to which the store space is to be analysed.
Space Type
Space type will be explained by an easy example of a planogram with one placed product whose dimensions are described in the figure on the right.
- Linear space [m] - considers only the space's width. For example, if the analysis calculates the space needed for products on a shelf and the Space Type m is selected, Quant adds up only the widths of the placed products. In our example the result for this planogram would be 9 cm.
- Width x Height [m²] - width and height are multiplied to create the space. The result in our example is 9 x 20 = 180 cm².
- Width x Depth [m²] -width and depth are multiplied to create the space. The result in our example is 9 x 10 = 90cm².
- Width x Height x Depth [m³] – width, height and depth are multiplied to create the space. The result in our example is 9 x 20 x 10 = 1,800 cm³.
- Floor area [m²] – width and depth are multiplied to create the space. This type of space is used in cases where you want to discover the area of the floorplan covered by the placed products. The result in our example is 9 x 10 = 90 cm².
- Linear floor plan space [m]- width of the product. In our example 9 cm.
Floorplan View
In Quant you can set that a certain layer or Equipment type is hidden in the Project Editor in the display for products or marketing.
Then you can select the required option in analyses and thus specify which equipment should be analysed. Display in the Store Editor always includes all items of furnishing. If you do not use this setting, you can select any floorplan view.
After all criteria have been set, click on the Report button.
Analysis Library
In Quant it is possible to save already used criteria in a so-called “Analysis Library”. The library is a very useful tool if you use the same or very similar criteria repeatedly.
If you select criteria in the library, they will be automatically displayed in the Criteria section and you can start the report immediately or just change the value that you need. Such a value will not be saved in the criteria unless you click on the Save button.
New / Save: If you change a value in already existing criteria and click on the New button, the criteria will be added to the library while the existing criteria will be preserved with an unchanged value. On the other hand, if you click on the Save button, the existing criteria will be overwritten by the new ones.