Čokobanka

The goal is clear: uncover the money black hole

Čokobanka is a Czech online shop selling gourmet chocolate from family-owned chocolatiers, which has grown at a double-digit rate over the last 3 years and has a turnover of over CZK 8m. As the product range and customer base expanded in a relatively short time, the e-shop ran into obstacles that led it to almost philosophical questions:

• Why is the company's turnover growing, but the bank account doesn't show it?
• How to have more visibility on the profit margin on products with retail and wholesale customers?
• What order values are profitable?
• How to calculate more realistically all shipping, payment and marketing costs for each product?
• When is it worthwhile to offer free shipping?

"I make decisions every day. The feeling of being able to rely on my own, up-to-date and real data has brought me great relief. I expect a lot from the new corporate reporting: it will give me a detailed look beneath the surface of things, a deeper knowledge of the whole business, and also the ability to identify problems early on, not after I've spent thousands on them." 

Petr Veselý, owner of Čokobanka

All the data on a silver platter...

There is truth in data. To get to it and turn it into action at Čokobanka, we had to lay the foundation for business intelligence reporting, because that's where it all starts and ends. How did we proceed? We started with a data warehouse, where we brought in all the data from Shoptet and an external fulfilment database. We set up rules of operation and transformation for all the data and gave it structure.

The result is this:

• ready-made and clear dashboards in the Power BI platform, which the client no longer has to laboriously create himself.

"We knew we needed to optimize our chocolate selection in the e-store. But which ones should we remove from the offer? A year ago, we would have made such a decision based on incomplete outputs from Shoptet, Excel spreadsheets, and a mix of intuition and our own experience. Thanks to Databy, all the data was available in a few clicks. We could immediately see which products were just tying up resources unnecessarily and selling at virtually cost price with zero profit."

Petr Veselý, owner of Čokobanka

We don't just look for problems, we solve them immediately.

Working effectively with data has led the client to a better understanding of what is happening in their business at any given moment. It significantly reduced the time between problem recognition and correction. As a result, he can better work with his product portfolio and customer base, and more easily optimise profitability, find new revenue streams, and identify areas for future growth. 

What specific changes has Databy brought about?

Greater visibility into product profitability

for retail and wholesale

Easier calculation of order profitability

and its minimum values for determining free shipping

Uncovering financial black holes

and removing unprofitable products from the offering

Insight into customer behaviour

and the structure of the customer base

Real-time business results

with reports available at a single click

Data-driven decision making

and the ability to react quickly, flexibly and agilely