Case Study: Automated Sales & Receivables Analysis for Marussia Beverages

Client:

Marussia Beverages Georgia

Industry:

Beverage Distribution

Project Duration:

Mar 28, 2025 – Apr 17, 2025

Service Provided:

Power BI Sales and Debtors Reporting

Overview:

Marussia Beverages Georgia, part of an international beverage distribution group, required a modern reporting system to centralize and enhance visibility over their sales, payments, and receivables. The goal was to equip their sales and finance teams with accurate, up-to-date insights to better understand performance and customer behavior.

The company previously relied on fragmented and manually prepared Excel files to track key performance indicators across multiple dimensions — including products, sales reps, channels, and regions. This made it difficult to get a holistic, real-time view and slowed down decision-making.

Additionally, monthly debtor data was stored in separate Excel files by year and month, which limited the ability to track historical patterns or conduct consolidated analysis.

DataStudio developed a suite of Power BI dashboards focused on:

Sales performance by product, region, sales channel, and individual reseller
Payment trends and debtor tracking
A built-in VAT toggle , allowing users to view figures with or without 18% VAT , supporting flexible financial analysis
A fully automated consolidation process for receivables:
Monthly Excel files are placed in a shared folder, with a naming format (eg, 012023, 022023)
The system combines and updates these files into a live debtor database, enabling dynamic receivables analysis

Case Study: Automated Sales & Receivables Analysis for Marussia Beverages

Are you ready to give real meaning to data?

Join the companies that are creating simple, automated reporting with DataStudio — without the chaos of Excel.

Contact datastudio!