Cases
Published Nov. 16, 2026

Kopiyochka: one version of the numbers for six departments and 500+ stores

Kopiyochka: one version of the numbers for six departments and 500+ stores
Vlada Karpaliuk

Vlada Karpaliuk

Marketing Manager at Datawiz

Discount chain Kopiyochka moved its analytics from Excel to Datawiz BES. Now six departments calculate metrics the same way, key reports update without analysts touching them, and margin is visible at every stage of the product’s journey.

About Kopiyochka: a discounter where margin comes from thousands of SKUs

Formatdiscount store for household and everyday goods
Stores500+, in almost every region of Ukraine
Datawiz BES solutions Datawiz BI, Custom Formulas, Store Manager, Connector, PlanoHero

 

In discount retail, profit per item is small, but there are thousands of items. The chain runs frequent short promotions and keeps growing its private labels and loyalty program. A mistake in margin or cost calculations doesn’t stay in one category here. It gets multiplied across hundreds of stores.

 

Before Datawiz BES: analytics in Excel and three problems that slowed decisions down

“Before Datawiz BES, the company mostly relied on Excel, with everything that comes with it: multiple file versions floating around in email, every department building charts its own way, and calculations that didn’t match.”

Vasyl Lozynskyi, Head of Strategic Analytics, Kopiyochka

 

For the business, that meant three things.

  • Nobody fully trusted the numbers.

If the commercial and finance teams calculate margin differently, a decision on a purchase or promo has to wait until someone reconciles the data. And when the decision is urgent, it gets made without full confidence in the data.

  • Expensive specialists were doing manual work.

An analyst spent an entire workday putting together a single inventory turnover report by hand. Every time the report was needed.

  • More reports, more confusion.

Each department built its own spreadsheets and charts. Some reports duplicated each other, and it wasn’t always clear which one to go by.

 

What changed: before and after Datawiz BES

 

 Before Datawiz BESWith Datawiz BES
Calculation methodeach department had its ownone set of analytics for the whole chain, transparent to every department
Price and cost analysismanual calculations in Excelcustom metrics in Custom Formulas: 6 types of price and cost within one category
Inventory turnover report6-8 hours of an analyst’s manual work every time1 hour to set up, then updates automatically
Number of reportsduplicates across departmentsa structured set with no duplicates
How does the company work with data?each department in its own files6 departments in one system

 

Change 1. One calculation method: the same margin in every report

In Datawiz BI, each metric has one formula, and everyone can see it. When the commercial director and the finance team open a category report, they see the same margin, calculated the same way. No more reconciling files before a meeting.

The chain calls this one of the most valuable results:

“The team gained a shared understanding of key metrics, which led to fewer discrepancies in how data is interpreted and more trust in the analytics.”

For the business, trust in data means speed. Decisions on purchasing, pricing, or promotions get made right away, without a separate meeting to double-check the numbers.

 

Change 2. Custom Formulas: see exactly where the chain is losing margin

The team doesn’t stop at out-of-the-box metrics. In the Custom Formulas module, they build their own metrics to answer their own questions. For example, within a single product category they compare six types of price and cost:

  • Custom Formulasis a Datawiz BI module where the team builds new metrics from existing ones using their own formulas and uses them in reports right away.
MetricWhat it shows
Price before discountbaseline revenue per unit
Discounted priceactual revenue per unit

Cost per unit ordered  

terms at the ordering stage
Cost per unit received  whether the terms match the actual delivery
Cost per unit in stockhow much cash is tied up on shelves and in the warehouse
Cost per unit soldreal margin on what was sold

 

Together, these metrics show the product’s full path from order to sale. If a category’s margin dips, you can see at which stage: the promo, supplier terms, or inventory. For a chain with regular promos and private labels, this is a direct way to keep profit under control.

Custom formulas

Change 3. Automated reporting

The inventory turnover report by category used to take an analyst 6-8 hours. In Datawiz BI, the team set it up, charts included, in 1 hour. From there, the report updates on its own. Every reporting cycle after that saves a specialist a full workday.

Time Optimization with Datawiz BI

 

At the same time, the chain cleaned up its reporting. Reports were organized, duplicates removed, and the total number went down. With fewer reports, it’s easier not to get lost in the numbers.

The time that used to go into pulling data together now goes into working with it:

“This lets the team focus more on analyzing results, finding the causes of deviations, and building recommendations for management decisions.”

 

Change 4. Six departments in one system: from assortment to checkout

At Kopiyochka, Datawiz BES isn’t just for analysts. Each department handles its own tasks, but on the same data.

DepartmentTask in Datawiz BESWhat it means for the business
Commercialassortment policy performancemoney goes into categories that actually earn
Operationsstore managementone consistent standard across 500 stores
Marketingeffectiveness of customer engagement through the loyalty programthe bonus budget drives repeat purchases
Financemonitoring and evaluating the cash cyclevisibility into how much cash is tied up in working capital
Loss Preventioncashier performance analysis, spotting potential abusefewer hidden losses at the register
HRcashier workload throughout the monthstaff schedules that match real workload

 

When all departments work in one system, data from one task is immediately available for another. Finance sees the same sales as the commercial team, and loss prevention and HR look at the same cashier activity from different angles.

How departaments use Datawiz BI

Business results: faster decisions and control over profit

  1. Decisions without reconciling numbers. Every department uses the same methodology, so conversations about purchasing, pricing, and promos focus on substance, not on whose file is right.
  2. A full analyst workday saved on every report. A report that used to take 6-8 hours was set up in an hour and now updates on its own. The time freed up goes into finding the causes of deviations and preparing recommendations for leadership.
  3. Margin under control at every stage. Custom Formulas show exactly where profit slips away: in promos, supplier terms, or inventory.
  4. Fewer hidden losses. Loss prevention spots anomalies in cashier activity, and HR plans schedules around actual workload.

The chain sums it up like this:

“We see Datawiz BES not just as a business intelligence system, but as a tool that helps build a data-driven management culture.”

Vasyl Lozynskyi, Head of Strategic Analytics, Kopiyochka

And on working with the Datawiz team:

“What matters to us is not only the product’s functionality, but also a partner who’s willing to listen to the business’s needs, keep a constructive dialogue going, and work with us to find the best solutions.”

Analytics and the shelf in one ecosystem: Kopiyochka’s PlanoHero case

Alongside Datawiz BI, the chain manages its shelves in PlanoHero. The results there are hard numbers: the assortment was cut by about 10%, and revenue per store grew by 8-12%. Read how they did it in the PlanoHero case study.

Share

BI

Make decisions based on real data with Datawiz BI