QSR-FMCG

Quick Service Restaurant" and "Fast-Moving Consumer Goods"

Crunchy Corner Business Optimization & Budgeting Dashboard

Project Overview

This project analyzes and optimizes the financial performance of Crunchy Corner, one of India's largest fast-food restaurant chains. The goal is to create an interactive Power BI dashboard to monitor key metrics, analyze budget variance, and identify optimization opportunities using advanced DAX calculations.

Key Objectives

• Analyze historical financial data for performance trends.
• Optimize business operations through gross profit and SKU analysis.
• Conduct budgeting and variance analysis.
• Implement dynamic visualizations (Pareto charts, Mekko charts, conditional formatting) for actionable insights.

---

Data Sources

• Unclean Data: Google Drive Folder
• Cleaned Data: Google Drive Folder

---

Presentation Overview (PPTX)

The PowerPoint deck outlines the project workflow, including:

1. Data Preparation: Cleaning and structuring raw data.
2. Financial Performance Analysis:
   • Actual vs. Budget comparisons using DAX.
   • Gross Profit Margin calculations.
3. Business Optimization:
   • Pareto Analysis (Top SKUs by sales and profit).
   • Dynamic Gross Profit vs. Volume comparisons.
4. Budgeting Analysis:
   • Variance analysis and PVM (Price-Volume-Mix) metrics.
5. Advanced DAX Functions:
   • Time intelligence (YTD, monthly sales).
   • Running totals, cumulative percentages, and ranking.
   • Conditional formatting for profit/loss visualization.

---

Dashboard Features (PBIX)

The Power BI dashboard includes:

Key Visualizations

• Financial Performance: Actual vs. Budget variance charts.
• Pareto Analysis: Top 20% SKUs contributing to 80% of revenue.
• Mekko Chart: SKU sales distribution across regions.
• Quadrant Analysis: Gross profit vs. sales volume.
• Time-Based Metrics: Monthly/YTD sales trends.

Technical Highlights

• DAX Measures:

  -- Cumulative Sales %  
  Cumulative % = 
  VAR sales = SUM(OrderBreakdown[Sales])
  RETURN
  DIVIDE(
    CALCULATE(SUM(OrderBreakdown[Sales]),
    FILTER(ALLSELECTED(ListOfOrders[State]),
      CALCULATE(SUM(OrderBreakdown[Sales])) >= sales)),
    [Total Sales])  
  

  -- Conditional Formatting for Profit  
  Conditional Formatting = 
  IF(SUM(OrderBreakdown[Profit]) > 0, "Green", "Red")  
  

• Dynamic Filters: Timeframe (Monthly/YTD), Top N SKUs, and regions.

---

How to Use

1. Data: Download the cleaned dataset from the Google Drive folder.
2. Dashboard: Open the .pbix file in Power BI Desktop.
3. Presentation: Review the PDF/PPTX for methodology and insights.

---

Conclusion

This dashboard empowers Crunchy Corner’s stakeholders to:

• Track financial health in real-time.
• Identify underperforming SKUs and regions.
• Optimize budgets and resource allocation.

---

Links Summary

• Unclean Data: Link
• Clean Data, PPTX, PDF, PBIX: Link

Contact Me

• LinkedIn: Link
• GitHub: Link