Reports on Datawiz BI service The "Brand Sales" report is designed to analyze all brands represented in the chain. It contains two tabs: Report and Sales Structure. Report The "Report" tab represents the main sales metrics in the chain brands. The functionality of the report allows to: view the required data for two periods: "Chosen" and "Previous", comparing them with each other. analyze data at different levels, from brand to categories and SKU; visually track the dynamics of key

Reports on Datawiz BI service The "Store Card" report summarizes the basic information on the store and allows to analyze it in dynamics, comparing several

Reports on Datawiz BI service The "Product Card" report summarizes the basic information on the product and allows to analyze it in dynamics, comparing several

Builder - visualization constructor on Datawiz BI service Creating a visualization page is designed to generate analysis data and select their further display. You can go to this page from the Home page. At the top of the page Creating a visualization the location of the created visualization is displayed: Dashboard group name → Dashboard name → Visualization name. To create a new visualization you need: add dimensions and

Reports on Datawiz BI service The "Basket Analysis" report allows to identify a typical shopping basket at different times, prices and qty.  It contains tabs: 2 dimensions and 3 dimensions. Tabs summarize information about sales categories and products, showing typical patterns of client behavior. Tabs functionalities allow you to: determine what clients buy at different times of the day and days of the week; form targeted marketing activities; adjust the display of products in the trading place. Note! The "2 dimensions" tab displays the baskets where the

Reports on Datawiz BI service The "Quadrant Analysis" report allows to quickly analyze how a change of one metric affected the change of the other metric of product (brands, producers, shops) sales. It allows to divide the sections into quadrants on two metrics and conduct a detailed analysis. The functionality of the report provides the opportunity to: choose a pair of interdependent

Reports on Datawiz BI service The "Sales Change" report is designed to quickly find the reasons for the decline, or increase sales metrics at all levels, from shops/categories, and down to the SKU. It contains charts showing changes in chain sales. Clicking on a visualization element forms a chart of the next lower level, and such a fall allows you to identify which categories, shops, or products caused a change in performance. Two fields are intended for visualization build-up: Metrics Axis 1 - allows you to choose the following

Builder - visualization constructor on Datawiz BI service Builder is an online service for creating customized dashboards for chain business processes. Such personalized reports will allow users to optimize the control process and speed up grounded decisions. Dashboards can be designed for each employee, taking into account their tasks and goals. For example: for top managers - to create dashboards with the main business metrics and their dynamics; for store managers - with

Reports on Datawiz BI service The "Category Managers" report is designed to analyze the performance of each category manager by its main KPI. Using the report you can: view the necessary data for two periods: "Chosen" and "Previous", comparing them with each other; analyze data at different levels, going down from the category manager to the categories and SKUs that are assigned to them; visually track the dynamics of the main managers’ KPI; evaluate the contribution of each category manager to the overall sales

Reports on Datawiz BI service The "Supplier Analysis" report is designed to analyze key metrics for all suppliers in the chain. It contains two tabs: Report and Sales Structure. Report The "Report" tab summarizes the main suppliers’ sales metrics in the chain. Using the report, you can: view the necessary data for two periods: "Chosen" and "Previous", comparing them with each other; analyze data at different levels, going down from supplier to categories and SKU; visually track the dynamics of key

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

Reports on Datawiz BI service The "Category Card" report summarizes the basic information on the category and allows to analyze it in the dynamics, comparing several metrics at once. There is general information on categories at the top of the report. There is a block of execution of the plans on three

Reports on Datawiz BI service The "Product Sales" report summarizes the metrics for each product and provides an opportunity to conduct ABC and XYZ-analysis of the range for each product group. It contains the following tabs: Report, Cumulative Curve, ABC Distribution, ABC Analysis by Categories. Note! The last two tabs appear after setting the ABC and XYZ analysis parameters in the report filters. Report The "Report" tab contains the main

Reports on Datawiz BI service The "Store sales" report is designed to evaluate the performance of each store and the chain as a whole. It contains two tabs: Report and Sales Structure. Report The "Report" tab shows the main

Reports on Datawiz BI service The "Category Sales" report is designed to evaluate the main metrics of sales in the context of chain categories. It contains two tabs: Report and Sales Structure.  Report The "Report" tab contains a table with the main metrics of the category sales. Using the report you can: view the necessary data for two periods: "Chosen" and "Previous", comparing them with each other; analyze the main

Builder - visualization constructor on Datawiz BI service Activity history - a report that allows to track who, when and where viewed the dashboard. To go to it, select "Activity History" next to the name of the dashboard in the list of actions (on the right side of the Dashboard View page).  The dashboard for which "Activity History" is open and its' location are displayed at the top: Dashboard group name > Dashboard name > Activity history. For dashboards shared with the user: Dashboard name > Activity history. In columns right above the table

Reports on Datawiz BI service The "Producer Analysis" report is designed to analyze the main metrics for all chain producers. It contains two tabs: Report and Sales Structure. Report The "Report" tab summarizes the main sales metrics created by chain producers. 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 producer to category and SKU; visually monitor the dynamics of key

Reports on Datawiz BI service The "Stocks Monitoring" report summarizes data on products that were sold as zero balances at least once during the period. The functionality of the report allows to: find products with incorrect balances; determine when an error in the data could occur; visually track the dynamics of sales and stocks of "problem" products. The report is formed for each store separately and for the chain as a whole. To choose a store click on "Chosen Stores" field on the left above the table and choose the necessary store from the pop-up

Reports on Datawiz BI service The Main Page of the solution shows the results of the chain and allows to view the main metrics: for the last day of available data on the solution; for the last week; for the last month (30 days); for the last 90 days. To change the time interval click on the necessary tab at the top of the page. There is the number of stores in the upper right corner of the page for chosen data (according to the access rights granted). The analytics and

Reports on Datawiz BI service The "Unsaleable products" report summarizes the data on products that were not sold during the chosen period and their stocks are quite sizeable. The functionality of the report allows to: find products that are not in demand; determine which products should be removed from the assortment; visually track the dynamics of sales and stocks on slow-moving products. The report is formed for each store separately and for the chain as a whole. To choose a store click on "Chosen stores" field on the left above the table, and choose the

Reports on Datawiz BI service The "OoS Prediction" report contains data on products the stocks of which will soon run short and they need to be ordered in the near future. The functionality of the report allows to: identify the products of the main assortment (the ones sold at least twice a week), the stocks of which should be urgently replenished; visually track the dynamics of sales and stocks on current products to prevent "gaps in stocks"; avoid losses in sales caused by the lack of popular products. The report evaluates the situation for future periods only

Reports on Datawiz BI service The "24-Hour Analysis" report analyses chain sales metrics in terms of a day, week, and hour. It contains the following tabs: Hour Trend, 24-Hour Analysis. Hour Trend The "Hour Trend" tab contains a visual breakdown of key sales

Reports on Datawiz BI service The "Products Movement" report contains data on documents of chain product transactions. The functionality of the report allows to: view information on each invoice, deploying it to the SKU; filter documents according to required transaction types; compare different types of documents to identify work gaps in staff and suppliers. Metrics "Columns" button allows to choose the necessary

Reports on Datawiz BI service The "Effectiveness of cashiers" contains basic information on the cashiers of the chain which allows to assess the effectiveness of their work, identifying the most and least productive employees. The functionality of the report allows to: analyze each chain cashier’s KPI; identify problem areas in the cashiers’ performance; control and optimize cashiers’ work schedule. In the report the cashier's performance is deployed to the assigned terminal. The report is formed for each store separately and for the chain as a

Reports on Datawiz BI service The "Products for adjustment" report contains data on products stocks of which should be adjusted. The report includes products that were not sold for three or more days consecutively in the selected period and were on the stocks at this time. The functionality of the report allows to: identify products that need to be checked for their actual stocks; find out the period when the inaccurate stocks of products were appeared; compare visualizations of sales and products stocks to identify incorrect stocks. The report is formed for each store

Reports on Datawiz BI service The "POS-terminal Traffic" report contains sales

Reports on Datawiz BI service The "Sales Plans" report is designed to analyze plans for key sales metrics and the effectiveness of their completion. It contains three tabs: Plan on Stores, Plan on Categories, Plan on Category Managers. Note! Sales plans can be created and modified with a Data Console solution. If you do not have access to the Data Console solution contact your administrator.   Plan for Stores/Categories/Category Managers The tabs represent the main planned

Reports on Datawiz BI service The "Promotion Analysis" report summarizes the main metrics of the chain promotional activity. The report contains two tabs: Report and Promo Comparison. Report The "Report" tab contains basic information on sales of promotional products in the chain. Its functionality allows to: evaluate the results of each promotion, expanding it into categories and SKU; track the "behavior" of promotional products during the promotional and non-promotional period; analyze the dynamics of key

Reports on Datawiz BI service The "New SKU" report summarizes the main sales metrics for new products in the chain to determine the feasibility of their introduction into the assortment. The functionality of the report allows to: review the sales quantity of new SKUs at different levels (regions, areas and certain stores); quickly know the total quantity of new products in the chain and the sales generated by them; visually track the main sales metrics for the entered product items. There are information cards with

Reports on Datawiz BI service The "Effectiveness of Loyalty Program" report summarizes the key

Reports on Datawiz BI service The "Promotion Card" report summarizes the main data on promotion and allows to analyze them in dynamics, comparing several metrics in the promotional and non-promotional period. There are information cards with the metrics at the top. They display basic information about the

Reports on Datawiz BI service The "RFM-Analysis" report allows to distribute and analyze all clients by parameters: Recency - shows how long ago a client has made a purchase. Frequency - shows how often the client visits the store. Monetary - shows what is the average amount of money the client spends. The report helps to know which clients, when, and with what offers it is necessary to address to maintain their interest in further purchases of products and services. The RFM-Analysis allows to: minimize the cost of time and resources to motivate clients; increase the

Reports on Datawiz BI service The "Statistic of Loyalty Program" report displays basic loyalty program data.  There are information cards with

Reports on Datawiz BI service The "Customer Loyalty Segmentation" report allows to divide LP clients into groups according to the required characteristics and analyze them in detail. The functionality of the report allows to: form different segments of LP clients; analyze group sales metrics, determining the most profitable ones; study the most typical purchases of each of the segments; increase the effectiveness of marketing activities for each group of clients. There are information cards with

Reports on Datawiz BI service The "Loyalty Card" report summarizes the basic data by the loyalty program client and allows to analyze the dynamics of their purchases. General client’s information is displayed at the top of the report: LP Card Number Phone Number Date of Birth First Visit Last Visit The "Purchase Statistics" table systematizes the metrics of purchases of these clients by category. Each category is deployed to a separate SKU. The "Purchase Dynamic" visualization shows the value of chosen

Reports on Datawiz BI service The "Comparative Dynamic" report is designed to compare the dynamics of sales by category and product at the same time. It contains 3 graphs: Selected Period, Previous Period, and Change in absolute units. Graphs show the dynamics of sales by chosen categories and products. Functional graphs allow to: track how the sales have changed in the chosen and previous periods; identify periods when there has been a decrease or increase of sales; establish patterns of sales of various categories and products. You can choose the following when

Reports on Datawiz BI service The "Receipts" report is designed to generate and display a list of receipts by required characteristics. The functionality of the report allows to: track the entire sales history for the chosen period; estimate the frequency of products in the buyers’ receipts; analyze data at the level of products included in the receipt. At the top there are information cards with

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Sales". Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.   Sales the amount of cash receipts from sales of products for the specified period. Sales Change the difference between the sales metrics for the selected and previous periods. Sales Change, % the difference between the sales

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Profit". Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.   Profit  the difference between the monetary proceeds from the product sales (turns) and the product primecost for the selected period. Note! The metric is not calculated on the service, but is transmitted by the client. Profit Change the difference between the profit

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Receipt Qty". Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.   Receipt Qty the total qty of receipts for the sale of products (excluding the qty of receipts for returns) for the selected period. Receipt Qty Change the difference between the receipt qty metrics for the selected and previous periods. Receipt Qty Change, % the difference between the receipt qty

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Stocks". Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.   Stock Qty at the end (beginning) of the day the qty of products are available in the store and/or storage at the end (beginning) of the last day of the selected period. Stock Qty at the end (beginning) of the day Change the difference between the stock qty at the end (beginning) of the day

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Price". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Primecost of sales". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Avg Receipt Price". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Finance metrics". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Turns". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Loyalty". Access to viewing metrics, according to the user's role, is determined by the administrator. To expand access, contact your administrator.   Card number of LP the numerical card number of the LP clients, which gives them certain advantages when making purchases. Total Qty of LP clients qty of all chain LP clients for the entire data upload period. Total Qty of LP Change the difference between total qty of LP

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Plans". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Refunds". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Postings". Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.   Posting in absolute units the posted products qty that were found as a result of the inventory for the selected period. Posting in absolute units Change the difference between the posting in abs. units

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Relocation". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Discount". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Laboratory". Access to viewing

Reports on Datawiz BI service The Planogram Efficiency report summarizes product sales data across store planograms, helping you flexibly analyze and compare product sales. The report functionality allows to: compare the sale of products displayed on the shelves separately for each store and as a whole for the chain; view the necessary data on metrics for the selected and previous periods, comparing them with each other; visually monitor the dynamics of sales of products according to planograms. There are information cards with

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Other". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Promotional metrics". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Sales Qty". Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.   Sales Qty the qty of natural units of products/categories/brands were sold during the selected period. Sales Qty Change the difference between the sales qty metrics for the selected and previous periods. Sales Qty Change, % the difference between the sales qty

Reports on Datawiz BI service The "Lost Sales" report summarizes data of losses due to missing or low sales. The functionality of the report allows: to identify lost sales by products, categories, stores, category managers; to determine the amount of losses, including due to zero balances; to track the dynamics of sales and balances on problem products; to identify the causes of losses, problem areas at work and avoid them in the future. The report includes items that have sales or stocks. In addition, the products are checked for asymmetry in the distribution of sales

Laboratory - AI-based reports module on Datawiz BI service The Price recommendations report contains two tabs: Price Recommendations and Accepted recommendations. Price recommendations The "Price recommendations" tab allows to view a list of recommendations with predicted sales increases and accept the recommended optimal price for the product. The tab allows: to identify products for which it is recommended to change prices in individual stores of the chain, and choose the most effective pricing policy; to track the relationship between price changes and profits for

Laboratory - AI-based reports module on Datawiz BI service Laboratory is a section with experimental reports. It is designed for beta testing by users of a solution that will allow us to: establish the value of new reports for clients; bring their functionality as close as possible to the needs of retailers; improve reports based on user recommendations and feedback. Actions with reports in the Laboratory The "Laboratory" section is located on the left panel of the BI solution. Reports do not need to be added in advance and cannot be removed from the block. You can share

Laboratory - AI-based reports module on Datawiz BI service The "Recommended assortment" report is an experimental report that analyzes the sales of products by chain stores and recommends products that are appropriate to introduce into the assortment of individual stores. The functionality of the report allows to: identify products that are appropriate to introduce into the assortment of individual stores; predict product sales using recommendations; increase the chain's profit by choosing the most effective assortment policy. To generate recommendations, the

Laboratory - AI-based reports module on Datawiz BI service Lost Sales ML - using machine learning algorithms, the report analyzes the movement of products, models sales forecasts and summarizes data on sales losses due to missing or low sales. The functionality of the report allows: to identify lost sales by products, categories, stores, category managers; to determine the amount of losses, including due to zero balances; to track the dynamics of sales and balances on problem products; to identify the causes of losses, problem areas at work and avoid them in the future. Based on

Laboratory - AI-based reports module on Datawiz BI service The Price recommendations ML report is a supporting tool to create an effective pricing policy of the chain. Using machine learning algorithms, іt shows for which products and how it is appropriate to change the price to maximize chain profits. The functionality of the report allows you: to identify products for which it is recommended to change prices in individual stores of the chain, and review their sales

Metrics - group of metrics on Datawiz BI service Problems Identified The qty of products that the user moved to the "Problem products" block. Problems Identified Change the difference between the Problems Identified metrics for the selected and previous periods. Problems Identified Change, % the difference between the Problems Identified

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Availability". Access to viewing metrics according to the user's role is determined by the administrator. To expand access, contact your administrator.   Sales Availability, % Note! The calculation of the sales availability will vary at the level of categories and products. At the Category level: the

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Supplier". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Assortment activity". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Product Layout". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Order/Delivery". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "Write-offs". Access to viewing

Metrics - group of metrics on Datawiz BI service There is a list of metrics of the group "POS-terminal". Access to viewing