This project focuses on analyzing customer shopping behaviour using Data Analytics, SQL, Python, and Power BI. The aim of the project is to identify customer purchasing patterns, spending habits, product preferences, and generate meaningful business insights through interactive dashboards and visualizations.
The project helps businesses understand customer behaviour and make data-driven decisions to improve sales, customer satisfaction, and marketing strategies.
- Customer shopping behaviour analysis
- Data cleaning and preprocessing
- SQL-based business insights
- Interactive Power BI dashboard
- Data visualization using Python
- Customer segmentation and trend analysis
- Sales and purchasing pattern analysis
- Python
- Jupyter Notebook
- Pandas
- NumPy
- Matplotlib
- SQL
- Power BI
- Git & GitHub
The dataset used in this project contains customer shopping behaviour information such as:
- Customer demographics
- Purchase amount
- Product categories
- Shopping frequency
- Payment methods
- Customer ratings
customer_behaviour_analysis/
│
├── customer_shopping_behavior.csv
├── data_analyst_portfolio_project.ipynb
├── BUSINESS_INSIGHTS.sql
├── SQLQuery1.sql
├── Customer_behaviour_analysis.pbix
├── POWER_BI_DASHBOARD_GUIDE.md
├── POWER_BI_REPORT_SPEC.md
├── Reports/
├── Images/
└── README.md