Executive Sales & Profitability Review (Cookies Case Study) 

Project Overview

This project presents an executive-level analysis of sales, profitability, and margin performance across a consumer goods product portfolio, using a cookies sales dataset covering multiple markets and product categories.

The objective was to identify revenue drivers, margin efficiency, and geographic performance patterns, and to translate these findings into clear, decision-ready insights suitable for board review.

Tools & Skills Demonstrated

• KPI definition and interpretation

• Product, category, and geographic performance analysis

• Margin and profitability analysis

• Executive-level data storytelling and reporting

 Business Context & Objectives

Consumer product businesses often face trade-offs between volume, pricing, and margin efficiency. This analysis was structured to answer the following leadership-level questions:

• Which products and categories drive the majority of revenue and profit?

• How do margin efficiencies differ across product tiers?

• Are high-volume products also high-profit products?

• Which markets contribute most strongly to overall performance?

• How stable is margin performance over time?

This project successfully delivered a clear, executive-ready assessment of product, category, and geographic performance across the cookies portfolio.

Specifically, the analysis produced:

• Product performance charts identifying:

  • The highest revenue-generating product

  • The highest profit-generating product

  • Products with disproportionately high margin despite low revenue

• Category-level comparisons showing:

  • A dominant core category driving the majority of total revenue

  • Strong margin efficiency within lower-priced (budget) categories

• Geographic performance visuals highlighting:

  • The UK and India as the strongest contributing markets

  • Clear variation in revenue contribution by region

• Margin trend analysis demonstrating:

  • Remarkably stable overall margin percentages across the time period

  • Hidden variation at product and category level beneath that stability

Together, these outputs allowed the project to move beyond surface-level sales reporting and instead evaluate margin quality, product efficiency, and market contribution.