This project demonstrates a SQL analysis performed on the Atliq Hardware dataset to answer 10 critical business questions. These queries aim to provide insights into customer behavior, sales trends, product performance, and more. The analysis showcases my SQL expertise and ability to deliver data-driven insights, making it highly relevant for roles in data analysis.
- SQL Queries: A single SQL file containing 10 queries that answer the business questions, demonstrating the ability to handle complex SQL tasks.
- Business Insights: Data-driven answers to key business questions around sales, products, and customer behavior.
- Data Exploration: SQL techniques such as joins, window functions, subqueries, and CTEs to extract insights.
- SQL: Queries to analyze the Atliq Hardware dataset and deliver actionable insights.
The project answers the following business questions using SQL:
- Market Presence: In which markets does the customer "Atliq Exclusive" operate within the APAC region?
- Product Growth: What is the percentage increase in unique products in 2021 vs. 2020?
- Segment Insights: Which segments have the highest number of unique products?
- Segment Product Growth: Which segment had the most significant increase in unique products from 2020 to 2021?
- Manufacturing Costs: Which products have the highest and lowest manufacturing costs?
- Customer Discounts: Who are the top 5 customers with the highest average discount in 2021 for the Indian market?
- Gross Sales Analysis: What is the gross sales amount for "Atliq Exclusive" each month?
- Quarterly Sales: In which quarter of 2020 did Atliq Hardware have the highest sold quantity?
- Sales Channel Performance: Which channel contributed the most to gross sales in 2021 and what percentage of the total does it represent?
- Top Products by Division: What are the top 3 products in each division by total sold quantity in 2021?
Detailed explanations for each business question and the corresponding SQL query are available in the Business_Questions.md file.
Atliq_Hardware_SQL_Analysis.sql: Contains all the SQL queries that answer the 10 business questions.Business_Questions.md: Describes each business question and the associated SQL query.
- Clone this repository.
- Run the
Atliq_Hardware_SQL_Analysis.sqlfile on your SQL environment to execute the queries. - Review the
Business_Questions.mdfile to understand the context behind each query.
- Market Coverage: Found the key markets where "Atliq Exclusive" operates in the APAC region.
- Product Growth: Analyzed the percentage increase in unique products from 2020 to 2021.
- Segment-wise Analysis: Identified segments with the highest growth in unique products.
- Cost Analysis: Found products with the highest and lowest manufacturing costs.
- Customer Insights: Identified top customers by average discount in 2021.
- Sales Performance: Assessed monthly sales trends and the best-performing sales channels.