Executive Summary & Project Overview

This project analyzed the sales, damage, and pricing data of Olucrest Beverages, a fictional beverage distribution company, to help management understand where the business is making money, where it is losing money, and what to do about it.

The outcome: A 3-page interactive Power BI dashboard that reveals a business that was growing in revenue but shrinking in profit. Despite generating ₦15.39M in revenue, net profit was only ₦1.16M because damage losses alone consumed ****67.78% of profit.

🛠 Tools used: Microsoft SQL Server · Power BI

Business Problem

Beverage distributors run on very thin margins. The challenge is that most of what eats into profit; damaged stock, poor pricing decisions, seasonal demand shifts, never shows up clearly on a basic sales report.

For Olucrest, the key questions were:

• Which products are actually profitable versus just popular?
• How much money is being lost to damaged stock, and why is it happening?
• Are supplier promotions helping or hurting profitability?
• Are their branches performing equally or not?
• Are supplier promotions helping or hurting profitability?

Why this matters: This matters because distributors like Olucrest operate on very thin margins, typically 5–15%. At that level, every naira lost to damage, every missed promo opportunity, and every poorly stocked branch directly threatens profitability. Without data visibility, decisions about stock, staffing and pricing are made on instinct rather than evidence

Data Summary & Cleaning Process

The Data

The dataset was designed from scratch to reflect real FMCG distribution challenges. It consists of 5 tables:

• Sales (800 rows) - transactions with revenue and margin per row
• Damage (300 rows) - stock loss records by product, branch, and cause
• Pricing (150 rows) - monthly pricing per product with promo activity