PenBev — Business Intelligence Suite

Multi-dimensional CCPB (Consumer Channel Price-by-Brand) analytics platform for PenBev.
4 self-contained dashboards covering business performance, product health, and SKU master data.

---

⚡ At a Glance

📊 4 dashboards	🏷 SKU-level product master
📦 Channel mix analysis	💰 Trade spend ROI tracking
🏥 Product health scoring	🗂 Opens in browser — no install needed

---

📊 Dashboard Overview

1. Business Intelligence Dashboard

dashboards/penbev_ccpb_business_dashboard.html

What you'll see
Channel revenue breakdown (mass retail, trade, e-commerce)
Trade spend vs ROI by channel
Period-over-period KPI tracking
Outlet distribution and penetration rates

---

2. Product Health Dashboard

dashboards/penbev_ccpb_health_dashboard.html

What you'll see
Weighted distribution scores by SKU
Off-take velocity by category
Promo vs base revenue split
Category health index

---

3. Product Master

dashboards/penbev_ccpb_product_master.html

What you'll see
Full SKU catalog with channel pricing
Pack size and format hierarchy
Product grading (A / B / C / D)
Listing status by retailer

---

4. Executive Summary

dashboards/penbev_dashboard.html

Consolidated KPIs across all functions in a single executive view.

---

🚀 Quick Start

# No server, no install required
1. Clone or download this repo
2. Open any file in dashboards/ directly in your browser

# Windows
start dashboards\penbev_ccpb_business_dashboard.html

# Mac / Linux
open dashboards/penbev_ccpb_business_dashboard.html

---

📁 Repo Structure

PenBev-Analytics/
├── dashboards/
│   ├── penbev_ccpb_business_dashboard.html   # Revenue & channel performance
│   ├── penbev_ccpb_health_dashboard.html     # Product health metrics
│   ├── penbev_ccpb_product_master.html       # Full SKU catalog
│   └── penbev_dashboard.html                 # Executive summary
└── data/
    ├── penbev_product_master.csv             # SKU-level master data
    ├── PenBev_Sample_Data.xlsx               # Sample dataset
    └── PenBev.xlsx                           # Full workbook with pivot tables

---

Anthony Apollis · Data Engineer & Analytics Specialist · South Africa