Data Analysis in Action: How Lithuanian Retailer Ukmergė RVK Improves Efficiency with Datawiz BI

A 35-store retail chain in Lithuania moved from manual spreadsheet analysis to automated BI reporting: enabling faster decisions, better supplier negotiations, and more efficient store operations.

Company - Ukmergė RVK

Industry - Grocery Retail

Store count - 35+ locations

Geography - Lithuania

Solution - Datawiz BI

Key outcomes

• Automated financial and sales reporting across all stores
• Optimized product assortment per trading location
• Reduced manual data work; one analyst can now do what previously required a team
• Stronger supplier negotiations backed by data
• Real-time visibility into stock movement and store KPIs
• Fewer human errors in reporting and task generation

The challenge of managing 35 stores without real-time data

Running 35 retail locations means managing a high volume of data daily: sales performance, stock levels, supplier terms, and staff productivity. Before Datawiz BI, Ukmergė RVK relied heavily on manual data processes and spreadsheets to track these inputs across stores.

• Reporting depended on manual data entry and Excel, making analysis slow and error-prone
• No unified view of assortment performance across individual trading locations
• Supplier negotiations lacked structured data to support commercial decisions
• Employees spent significant time collecting and formatting data rather than acting on it
• Limited visibility into real-time store KPIs made it difficult to respond to changes quickly

How Ukmergė RVK automated reporting and assortment planning

Ukmergė RVK adopted Datawiz BI as its central analytics platform. The economic activities team now runs a range of structured reports: from hourly sales tracking to supplier analysis and inventory quadrant reviews within a single interface.

• Sales, hourly, and goods reports are now generated automatically without manual data entry
• Inventory and adjusted balance reports are used to shape assortment decisions per store
• Supplier analysis is integrated directly into commercial negotiation workflows
• Dashboards shared across teams, giving each role access to the data they need
• Trading terminal and staff productivity monitoring are built into the operational review

"With Datawiz BI, we analyze our financial data to adapt reports for forming sales goals and increasing the efficiency of sales points. Inventories, adjusted balances, suppliers, and quadrant analysis help us form assortments that align with our business objectives."

Vaida Jakučiūnienė — Manager for Economic Activities, Ukmergė RVK

What changed after switching to automated BI reporting

The shift from manual reporting to automated BI had a measurable effect on how the team works. Tasks that previously required multiple people to compile are now handled by a single analyst, with results presented visually and shared directly with relevant team members.

"Human errors are minimized in the generated tasks, making reports more accurate than before. With BI software, one employee can analyze data and present it visually. Each team member can conveniently access the information they need, saving both their own and colleagues' time."

Vaida Jakučiūnienė — Manager for Economic Activities, Ukmergė RVK

Supplier negotiations became more evidence-based, with structured analysis replacing ad hoc comparisons. Store-level assortment planning improved as teams could see which products performed across specific trading locations and adjust accordingly.

"Supplier analyses are particularly useful during negotiations, allowing us to create better cooperation conditions. BI reports provide detailed insights into trading locations, enabling us to make accurate and informed future plans."

Vaida Jakučiūnienė — Manager for Economic Activities, Ukmergė RVK

How quickly the team adopted Datawiz BI, and what helped

The team found the platform straightforward to integrate into existing workflows. Support from Datawiz was noted as responsive and effective when issues arose, an important factor for a team managing live retail operations.

"The BI program is user-friendly and adaptable to our needs. In the event of a problem, highly competent support managers are available to help, creating a comfortable and visually attractive work environment."

Vaida Jakučiūnienė — Manager for Economic Activities, Ukmergė RVK