This project focuses on analyzing sales data for AtliQ Hardware to uncover actionable insights and support strategic decision-making.
- Project Overview
- Problem Statement
- Key Objectives
- Tools & Technologies
- Data Analysis Workflow
- Key Insights
- Recommendations
- Impact of This Analysis
- Contact
AtliQ Hardware is a company in the electronics industry, operating across multiple regions and platforms. This project analyzes sales data to drive business growth and optimize product performance, discounts, and customer engagement.
AtliQ Hardware needed an in-depth analysis of its sales data to identify patterns, trends, and areas for improvement across different regions, channels, and product categories. This was crucial to making informed business decisions and staying competitive in the market.
- Understand customer and market trends.
- Analyze product performance across divisions.
- Evaluate the impact of discounts on sales.
- Identify trends and seasonal patterns.
- Provide actionable recommendations to improve profitability and customer satisfaction.
- SQL: Crafting SQL queries.
- Power BI: Data visualization.
- Data Collection: Aggregated sales data.
- Data Cleaning: Ensured data consistency and accuracy using Excel.
- Exploratory Data Analysis: Identified trends and outliers using SQL.
- Visualization: Built visuals in Power BI.
- Insights Generation: Derived meaningful conclusions for business strategies.
- Recommendations: Proposed actionable strategies to enhance performance.
- Customer & Market Insights: Identified top markets and customers contributing to sales growth.
- Product Performance: Notebooks and accessories were top-performing segments, with unique product counts increasing by 36%.
- Sales Trends: Retailer channels contributed 73% of gross sales in FY2021.
- Discount Impact: Flipkart, Viveks, Ezone, Croma and Amazon received the highest average discounts.
- Seasonality: Q1 2020 (Sept, Oct, Nov) recorded the highest total sold quantity.
- Focus on expanding product offerings in high-performing markets.
- Optimize discount strategies for greater profitability.
- Invest in the retailer channel to maintain strong sales growth.
- Align marketing efforts with seasonal peaks for maximum impact.
This project not only provided AtliQ Hardware with actionable insights to improve sales and customer satisfaction but also demonstrated the power of data storytelling. It highlighted the importance of aligning analytics with business needs to drive results.
For any queries, feel free to reach out:
Rachana Hadke