Walmart Retail Analyzer

This project offers a comprehensive analysis of Walmart Superstore's sales and profitability, providing actionable insights for strategic decision-making and operational optimization. The dynamic dashboard, designed in Microsoft Excel, visualizes key performance indicators (KPIs) and analyzes sales and profitability across various dimensions.

---

---

Key Features:

• Identifying KPIs with Sparklines: Utilize Sparklines to visually represent crucial KPIs like total sales revenue, profit margin, sales growth rate, and average transaction value, offering quick insights into performance trends.

• Segmentation Analysis: Analyze sales and profitability data by customer segments, product categories, markets, and regions to identify trends and opportunities for optimization.

• Top-performing & Underperforming Categories: Pinpoint top-performing product categories driving revenue and profitability, while identifying areas of underperformance for targeted improvement efforts.

• Geographic Distribution of Sales & Market Share: Visualize sales and market share distribution across different regions to identify growth opportunities and expansion potential.

• Sub-category Contribution Analysis: Evaluate the contribution of various sub-categories to overall sales to understand product preferences and optimize inventory management and marketing strategies.

• Market Share Evaluation by Region: Assess market share by region to inform resource allocation, expansion strategies, and market penetration efforts.

• Category & Sub-category Wise Metrics: Generate detailed insights into performance at a granular level, enabling targeted actions for improvement.

---

Usage Instructions:

1. Download the Excel File:

   • Click on the "Code" button on the GitHub repository.
   • Select "Download ZIP" to download the entire project.

2. Open the Excel File:

   • Extract the downloaded ZIP file.
   • Open the Excel file in Microsoft Excel.

3. Explore the Dashboard:

   • Navigate through different sheets and tabs to access various charts and analyses.

4. Interact with Charts:

   • Hover over data points to view details.
   • Adjust filters or parameters to customize your analysis.

---

Visuals:

Explore the complete dashboard by following the usage instructions provided above.

---

Feedback and Contributions:

---

Connect With Me

For any inquiries or collaboration opportunities, please feel free to reach out via LinkedIn. Your feedback and suggestions are highly appreciated.

Happy analyzing!