📊 Baby Care Product Analysis - Excel Project

📝 Overview

This project analyzes the performance of baby care products using Excel pivot tables and slicers. The goal is to provide a 360-degree view of business performance, helping decision-makers understand how different brands, package types, package sizes, and stock-keeping units (SKUs) have performed over time.

By leveraging data preprocessing, interactive reports, and detailed interpretation, this project offers insights into market trends, sales performance, and category growth over multiple years.

🚀 Project Objectives

✔️ Clean and preprocess raw FMCG data for structured analysis
✔️ Build interactive reports with Pivot Tables & Slicers
✔️ Compare performance of brands, package types, and SKUs
✔️ Analyze Value, Volume, and Average Price trends from 2022 to 2024
✔️ Calculate Year-over-Year Growth (YoY) for Value, Volume & Average Price
✔️ Empower decision-makers with flexible data exploration

🏗️ Steps Involved

1️⃣ Data Preprocessing

• Import and clean raw FMCG data
• Handle missing values and format data
• Ensure consistency in product categories

2️⃣ Primary Report Creation

• Set up an initial performance report
• Define key performance indicators (KPIs):
  • Value (Total sales revenue)
  • Volume (Total quantity sold)
  • Average Price (Price per unit)
• Organize data by year (2022, 2023, 2024)

3️⃣ Filling the Report with Insights

• Use Pivot Tables to aggregate:
  • Value, Volume, and Average Price across years
  • Comparison by brand, package type, and SKU
  • Category-wise and brand-wise performance analysis

4️⃣ Adding Interactive Slicers

• Implement slicers for dynamic filtering
• Enable users to drill down into specific categories
• Provide flexibility for different business queries

5️⃣ Year-to-Year Growth Analysis

• Calculate YoY Growth for Value, Volume, and Average Price:
  • 2022 vs 2023
  • 2023 vs 2024
• Identify rising and declining product trends
• Analyze how pricing changes impacted sales and revenue

6️⃣ Interpretation & Key Findings

• Analyze which brands performed best
• Identify growth trends and seasonal impacts
• Understand how package sizes and pricing affected sales
• Generate actionable recommendations based on findings

📌 Required Skills

• Intermediate to Advanced Excel
• Data Cleaning & Preprocessing
• Pivot Tables & Slicers
• Year-over-Year Growth Analysis
• Business Performance Analysis

📂 Project Files

📁 FMCG_Baby_Care_Dataset.xlsx – Raw data used for analysis
📁 Baby_Care_Analysis_Report.xlsx – Processed data and final analysis (Pivot Tables & Insights)
📁 README.md – Project documentation

📎 How to Use

1. Download the Excel files
2. Open the Baby_Care_Analysis_Report.xlsx file
3. Explore the Pivot Table dashboard
4. Use the slicers to filter key metrics
5. Analyze trends and insights for Value, Volume, and Average Price (2022-2024)
6. Check Year-over-Year Growth columns to evaluate performance

---