Motorcycle Parts Sales Data Analysis and Visualization - SQL Project

📊 About the Project

This project delves into the sales data of a company specializing in motorcycle parts. By focusing on wholesale sales across three key warehouse locations, aim to uncover insights into the company's revenue streams. The goal is to determine the net revenue generated each month for various product lines at each warehouse, providing a clear view of sales performance and profitability.

🎯 Project Purpose

The primary objective of this project is to empower the company with a deeper understanding of its revenue streams. By meticulously analyzing sales performance across different product lines and warehouse locations, we can:

• Identify sales trends across months and locations.
• Evaluate the profitability of different product lines.
• Inform data-driven decisions to optimize operations and sales strategies.

With these insights, the company can sharpen its focus on the most profitable areas and make informed adjustments to enhance overall sales performance.

📁 About the Dataset

The dataset used for this analysis comprises detailed sales transactions of motorcycle parts. Below are the key columns included in the dataset:

• order_number: A unique identifier for each order.
• date: The date when the order was placed.
• warehouse: The location of the warehouse where the product was sold (e.g., North).
• client_type: The type of client (e.g., Retail, Wholesale).
• product_line: The category of the motorcycle part sold (e.g., Braking system, Suspension & traction).
• quantity: The number of units sold.
• unit_price: The price per unit of the product.
• total: The total revenue generated from the sale.
• payment: The method of payment used (e.g., Cash, Credit card, Transfer).
• payment_fee: The fee associated with the payment method.

This rich dataset allows us to conduct a thorough analysis and create meaningful visualizations that will highlight key insights and trends.

---

🛠️ Tools and Technologies

• SQL: For querying and analyzing the sales data.
• PowerBI: To create visual representations of the data.

🚀 Getting Started

To explore this project, follow these steps:

1. Clone the Repository:

   git clone https://github.com/shanzahassan97/Motorcycle_Parts_Sales-Data-Analysis-and-Visualization-SQL-PROJECT.git

2. Set Up Your Environment: Ensure you have SQL and any data visualization tools installed.
3. Load the Dataset: Import the dataset into your SQL environment.
4. Run the Queries: Execute the provided SQL scripts to perform the analysis.

📊 PowerBI Dashboard Visualizations