Project Overview
This repository contains SQL queries and analysis for the Codebasics Resume Project Challenge. The project focuses on solving real-world business problems using SQL to extract actionable insights. It involves analyzing sales data, customer trends, and product performance across various dimensions.
The queries are designed to address specific business questions, and the solutions are presented in a format suitable for business stakeholders, including visualizations and a detailed presentation. Objectives
The primary goals of this project are:
Solve 10 SQL-based challenges using a structured approach.
Present insights in a business-friendly format.
Create a LinkedIn post to share the experience and showcase the project.
Dataset
The dataset includes transactional information such as:
Customer details
Product details
Sales data (including discounts, gross sales, etc.)
Manufacturing costs
Temporal dimensions (year, month, quarter)
Challenges and Queries
Below are the 10 challenges solved in this project:
List of Markets: Identify the markets in the APAC region where customer "Atliq Exclusive" operates.
Unique Product Increase: Calculate the percentage increase in unique products from 2020 to 2021.
Product Count by Segment: Generate a report of unique product counts for each segment, sorted in descending order.
Segment Growth Analysis: Determine which segment had the highest increase in unique products between 2020 and 2021.
Manufacturing Costs: Identify products with the highest and lowest manufacturing costs.
High Discount Customers: Report the top 5 customers who received the highest average pre-invoice discount percentage in 2021 in the Indian market.
Customer Gross Sales: Analyze monthly gross sales trends for "Atliq Exclusive."
High-Sales Quarter: Determine the quarter in 2020 with the highest total sold quantity.
Channel Contribution: Identify the channel contributing the most gross sales in 2021 and its percentage share.
Top Products by Division: List the top 3 products by total sold quantity in each division for 2021.
How to Use
Clone this repository:
git clone https://github.com/zrhirok/SQL_Analysis_Codebasics_Challenge.git
Load the dataset into your SQL environment (e.g., MySQL Workbench).
Run the SQL queries available in the queries/ directory.
Review the generated results and charts in the outputs/ folder.
View the presentation in the presentation/ folder.