I am Moonmoon Samal, a data science student at Masai School. This dataset was provided by Masai School for building a project on data analysis using SQL, Python, and Power BI.
About Project
End-to-end customer purchase behavior analysis and reporting system using SQL, Python, and PowerBI. This project will help you understand customer purchase patterns, key performance indicators, and generate insightful reports for business decision-making.
Problem Statement
Dataset containing customer purchase information for an online retail company. The dataset includes the following details:
- Transaction ID
- Customer ID
- Customer Name
- Product ID
- Product Name
- Product Category
- Purchase Quantity
- Purchase Price
- Purchase Date
- Country
The analysis will focus on the following questions:
- Calculate total purchases, total revenue, and average purchase value.
- Identify top customers and their purchasing behavior.
- Analyze purchase trends over time (monthly, quarterly, yearly).
- Identify the top-performing product categories.
The analysis will be conducted using SQL, Python programming language and library like Pandas, Numpy, Matplotlib, Seaborn. and Power BI. The results of the analysis will be presented in a report and in a series of visualizations.
I am excited to get started and I look forward to sharing the results of my analysis with you.
Note(: Please refrain from directly copying my code)
Thank You.