This project involves a detailed analysis of Crunchy Corner's sales data using Power BI, incorporating both basic ETL techniques and advanced DAX measures. I explored key metrics such as Net Profit, category performance, SKU, EBITDA, and Gross Profit, providing valuable insights for the business.
Crunchy Corner is one of India's largest Fast Food restaurant chain and serving millions of customer dauly across various cities in India with more than 1000 restaurant and have largest SKU in the industry.
- Financial Overview Metrices
- Optimization of Business
- Financial Planning and Budgeting
Protein Packs emerged as a high-growth area with strong profitability margins, highlighting their strategic importance for Crunchy Corner. Analysis of various metrics such as Net Profit, category performance, and Gross Profit provided a comprehensive understanding of the business's financial health and areas for potential growth.
ETL Techniques in Excel Filtering: Cleaned the data to remove unnecessary information. Data Cleaning: Ensured the data was accurate and consistent. XLOOKUP: Used to provide unique IDs for better data management. Advanced Measure Statements in Power BI Utilized DAX formulas to create advanced measures for calculating different profitability metrics. Created visualizations to display the data insights effectively.
The analysis covered the following areas:
- Comprehensive overview of key financial metrics like Overall Sales, Gross Profit, Ebitda, Pat, SKU.
- Analyzed the year-over-year change to identify trends and growth patterns.
- Examined the sales trend alongside PAT and PAT percentage to evaluate performance.
- Visualized the contribution of each metric to the overall financial performance via using 100% stacked Coloumn Chart.
- Detailed breakdown of sales across different categories and locations.
- Analyzed sales distribution across various channels.
- Evaluated the volume and trend of sales by category to identify high-performing areas.
This project was a significant learning opportunity for me, allowing me to apply and expand my skills in data analysis and visualization using Power BI.