Dairy Sales Dashboard — Interactive Business Intelligence Report

Built a fully interactive sales dashboard for a dairy company dataset containing 3,346 SKUs across 50 companies, cleaned and structured from raw messy data.

What this dashboard includes:

KPI summary cards (Total Revenue, Stock Value, Units Sold, Expiration Rate)

Units Sold & Revenue breakdown by product type (Milk, Cheese, Yogurt, Ice Cream, Butter, Cream)

Inventory Status breakdown (In Stock, Low Stock, Out of Stock, Backordered, etc.)

Price Distribution analysis across price ranges

Tools & Skills used: Python, Pandas, data cleaning, data visualization, business insight generation

Business value: Helps business owners instantly spot which products are selling, which are expiring, and where inventory risks are — without touching a single spreadsheet.

nice, keep going

Montana Inc. Marketing Campaign Analytics 2023. An Excel dashboard analysing marketing performance across Facebook, Instagram, and Pinterest channels for campaigns run across Birmingham, London, and Manchester. The report tracked total conversion value of £1.73M against a total spend of £163,250, delivering a return on investment of £1.57M. Key insights included Facebook driving the lowest conversion despite highest spend, summer campaigns outperforming fall and spring, and mobile devices accounting for 53% of total conversions. Delivered an interactive dashboard with cross-filtering by channel, city, device, ad type, and campaign season.