Reports on Datawiz BI service

The "Marker Comparison" report is designed to analyze user-created product markers.

A Marker is a group of products that includes products with a certain common characteristic. For example, "Lactose-Free Products" marker will include products that do not contain lactose.

The report helps to:

• view the required data for two periods: "Chosen" and "Previous", comparing them with each other;
• analyze data at different levels, going from higher to lower markers and SKU;
• visually track the dynamics of key metrics.

---

Creating a Marker

You can create and edit markers in the Data Console solution. You can find more detailed information on this in the DC Markers tutorial section.

---

Metrics

  "Columns" button allows to choose the metrics required by the user to generate a report. All metrics are divided into subgroups:

• Sales
• Sales Change
• Sales Change, %
• % of total Sales 
• Change % of total Sales 
• Sales of LP
• LP Sales Change
• LP Sales Change, %
• LP Sales % of total

• Sales Qty
• Sales Qty Change
• Sales Qty Change, %
• % of total Sales Qty
• Avg Sales Qty
• Avg Sales Qty Change
• Avg Sales Qty Change, %
• Sales Qty of LP
• Sales Qty of LP Change
• Sales Qty of LP Change, %
• Sales Qty of LP % of total

• Receipt Qty
• Receipt Qty Change
• Receipt Qty Change, %
• Avg Receipt Qty
• Avg Receipt Qty Change
• Avg Receipt Qty Change, %
• Receipt Qty of LP
• Receipt Qty of LP Change
• Receipt Qty of LP Change, %
• Receipt Qty of LP % of total

• Avg Receipt Price
• Avg Receipt Price Change
• Avg Receipt Price Change, %
• Avg Receipt Price of LP
• Avg Receipt Price of LP Change
• Avg Receipt Price of LP Change, %

• Stock Qty at the end of the day
• Stock Qty at the end of the day Change
• Stock Qty at the end of the day Change, %
• Stock price at the end of the day
• Stock Price at the end of the day Change
• Stock Price at the end of the day Change, %
• Stock Qty at the beginning of the day
• Stock Qty at the beginning of the day Change
• Stock Qty at the beginning of the day Change, %
• Stock Price at the beginning of the day
• Stock Price at the beginning of the day Change
• Stock Price at the beginning of the day Change, %

• Profit
• Profit Change
• Profit Change, %
• % of total Profit
• Profit of LP
• Profit of LP Change
• Profit of LP Change, %
• Profit of LP % of total

• Cost of sales
• Cost of sales Change
• Cost of sales Change, %

• VAT
• VAT Change
• VAT Change, %
• Excise
• Excise Change
• Excise Change, %

• Identifier
• Barcode
• Qty of active SKU
• Qty chаnge of active SKU
• Qty chаnge of active SKU, %
• % of active SKU Qty

• Planned Sales
• % completed Planned Sales
• Planned Sales Qty
• % completed Planned Sales Qty
• Planned Profit
• % completed Planned Profit
• Planned Margin
• % completed Planned Margin

Metrics highlighted in purple or red are clickable. Clicking on them opens a window with a flow chart of the chosen metric.

 "Templates" button - saves the configured report columns as a template.

On the right above the table a context menu is opened where the user can select the following actions:

• "Lock the total row" - fixes the "Total" row in the top row of the table.
• "Save XLS" - saves table data to an xls-file.

To quickly find the necessary marker, enter the first letters/symbols of the marker name in the search field. The search works automatically, leaving all found matches in the table.

To reset the search results, click on the cross in the search field.

---

Filters

The selection of filters makes it possible to carry out the analysis within the specified conditions.

Filters button is placed on the right side above the report. Clicking on it opens a modal window with the following filters:

• Period
• Previous Period
• Stores
• Categories
• Products
• Day of the week
• Interval
• Assortment Types
• Product Markers
• Types of LP clients
• Bonus Types
• Like for Like