📊 Profitability Optimization Dashboard – Data-Driven Decisions for Growth

Client Profile

An international coffee retail brand operating across multiple regions, offering a diverse product portfolio including coffee, tea, and herbal beverages. Despite strong brand recognition, the company faced profitability challenges due to underperforming products and inconsistent market strategies.

Industry Context

The Food & Beverage (Coffee Retail) industry is highly competitive, with profit margins influenced by product mix, pricing strategies, regional preferences, and marketing effectiveness. The client required a data-driven approach to reverse declining profits and optimize business performance in a saturated market.

Project Objective

To identify root causes behind profitability issues and develop actionable strategies by leveraging data analytics and visualization tools. The goal was to enable executive-level data-driven decision-making and support sustainable growth through optimized marketing and sales strategies.

Problem Statement

• Declining profitability across multiple product categories.

• Lack of visibility into product performance, marketing ROI, and regional sales trends.

• Difficulty in prioritizing marketing spend due to missing performance insights.

  
  

Solution Framework

The engagement followed a structured consulting methodology:

1. Data Ingestion & Preparation

✔ Consolidated multiple datasets (Sales, Products, Location, Marketing) into a unified fact table.

✔ Cleaned and validated data for accuracy and consistency.

2. Diagnostic Analysis using Tableau

Built interactive dashboards to analyze:

• Product-level profitability & sales performance.

• Market-wise profit contributions.

• Impact of marketing spend on profitability.

• Correlation between sales, margins, and profits.

3. Strategic Recommendations

• Marketing Optimization: Allocate additional spend to underperforming yet high-potential products.

• Product Strategy: Review and reposition products with negative margins.

• Regional Strategy: Launch localized campaigns in East and West markets to match Central region performance.

• Pricing & Margin Adjustments: Set optimal pricing strategies aligned with profitability goals.

  
  

Tools & Technologies

• Visualization & BI: Tableau

• Data Preparation: Excel, Tableau Data Blending

• Analytics Techniques:

  ✔ Profitability Analysis

  ✔ Correlation Analysis (Sales vs Profit, Margin vs Profit)

  ✔ Market Segmentation & Performance Benchmarking

Key Findings & Insights

✔ Certain tea products had negative profit margins, requiring repositioning or discontinuation.

✔ Premium coffee products emerged as top performers, driving the majority of profit.

✔ Products with low marketing spend consistently underperformed, proving a strong correlation between marketing and profitability.

✔ The Central region outperformed others, highlighting the need for regional strategies in East and West markets.

Impact Metrics (Projected Business Benefits)

✔ +15% Profit Margin Improvement through better allocation of marketing spend and margin optimization.

✔ +20% Marketing ROI Growth by focusing budgets on high-potential SKUs.

✔ 10% Revenue Uplift expected from region-specific campaigns and targeted product promotions.

Business Value Delivered

• Developed a C-level Tableau Dashboard for real-time profitability tracking.

• Enabled data-driven strategic planning, replacing guesswork with actionable insights.

• Delivered business recommendations aligned with revenue growth and operational efficiency.

Why This Project Matters

This case demonstrates my ability to bridge analytics with strategy, delivering consulting value that directly impacts profitability. I specialize in turning raw data into profitable decisions, helping organizations in F&B and beyond thrive through data-driven insights.