This project focuses on providing deep insights into the operations of AtliQ Hardwares by addressing 10 ad-hoc business requests using SQL. The goal was to support the management in making quick and data-informed decisions by expanding their data analytics capabilities.
The objective of this project is to:
- Address 10 ad-hoc business requests through SQL queries.
- Derive actionable insights from these requests to aid management decisions.
The analysis is based on sales data from the fiscal years 2020 and 2021. The data includes:
- Sales data from various regions: NA, LATAM, EU, and APAC.
- Information about different product lines and categories.
- SQL: For querying and extracting insights from the data.
- Power BI: For visualization of the extracted insights.
Task: Provide the list of markets in which customer "Atliq Exclusive" operates its business in the APAC region.
Insight: Extracted relevant markets from the APAC region.
Task: What is the percentage of unique product increase in 2021 vs. 2020?
Insight: There was a 36.33% increase in new products in 2021, indicating a dynamic response to evolving customer needs.
Task: Provide a report with all unique product counts for each segment and sort them in descending order.
Insight: Notebooks, accessories, and peripherals constituted 83% of total manufacturing.
Task: Which segment had the most increase in unique products in 2021 vs. 2020?
Insight: The Accessories segment saw the largest growth, with a need to focus more on storage and networking.
Task: Identify the products with the highest and lowest manufacturing costs.
Insight: Identified top and bottom performers in manufacturing costs.
Task: Generate a report of the top 5 customers who received the highest average pre-invoice discount in 2021 in India.
Insight: Flipkart received the highest pre-invoice discount at 30.83%.
Task: Report on the Gross sales amount for "Atliq Exclusive" for each month in 2020.
Insight: November 2020 had the highest sales, while March 2020 had the lowest, due to the COVID-19 impact.
Task: Identify the quarter in 2020 with the maximum total_sold_quantity.
Insight: FY2020 Q1 saw the highest sales, with a rebound in Q4 post-COVID-19.
Task: Determine which channel brought in the most gross sales in 2021 and its percentage contribution.
Insight: Retailers drove 73.23% of gross sales in FY 2021.
Task: Get the top 3 products in each division with the highest total_sold_quantity in 2021.
Insight: The AQ Pen Drive series led in the N&S division, AQ Gamers Ms in P&A, and AQ Digit PC in the PC division.
This project highlights the capability of SQL in addressing specific business needs and providing actionable insights. By analyzing the given data, the management can make better-informed decisions that could drive growth and optimize operations.
You can download the detailed presentation of this project here.