AtliQ Hardware Excel Project

This project analyzes customer and market performance data for AtliQ Hardwares (2019-2021). It provides insights into sales trends, customer growth, and revenue distribution across different stores and platforms.

🔍 Sales Analysis

Objective:

• Tracks year-over-year (YoY) net sales per customer.

• Highlights % growth (2021 vs. 2020) to assess performance.

• Identifies top-growing and declining customers.

📌 Business Impact:
Optimizes sales strategy by focusing on high-value customers, re-engaging declining ones, tailoring marketing efforts, and forecasting sales trends for better pricing.

💰 Finance Analysis

Objective:

• Tracks YoY market sales and % achievement vs. target.

• Identifies high-performing vs. underperforming markets.

• Highlights sales trends for strategic planning.

📌 Business Impact:
Helps allocate resources to high-growth markets, improve weak ones, refine sales targets, predict market trends, and optimize expansion plans.

📈 P&L Market Analysis

Objective:

• Tracks sales, costs, and profitability across different markets.

• Highlights gross margin % to identify high/low-profit markets.

• Helps optimize pricing and cost strategies.

📌 Business Impact:
Focuses on profit optimization by prioritizing high-margin markets, reducing costs, adjusting pricing strategies, and investing in high-performing markets.

🚀 Key Features

✅ Sales Growth Analysis - Compares yearly revenue changes and trends.
✅ Top Customer Insights - Identifies high-revenue customers like Amazon & Flipkart.
✅ Market Trends - Highlights growing and declining customer segments.
✅ Excel Analytics - Used formulas, pivot tables, and charts to drive insights.
✅ SQL Queries - Ready-to-use SQL scripts for deeper data exploration.

Checkout the Project Here: https://github.com/swaroopsamuel/AtliQ-Hardware-Excel-