How gautam9798/customer_behavior_analysis works
This repository is an end-to-end customer-shopping analytics project. Its documented workflow uses Python for cleaning and exploratory analysis, SQL for business analysis and segmentation, and Power BI for interactive visualization; the README also reports findings and recommendations. The graph represents those documented stages and the available data and presentation artifacts. No source excerpts are available, so artifact-level handoffs and the presentation’s precise contents cannot be verified beyond the README’s workflow description.
Main entry points: customer_behavior_sql_queries.sql SQL analysis · Customer_Shopping_Behavior_Analysis.ipynb Python analysis · customer_behavior_dashboard.pbix Power BI dashboard · customer_shopping_behavior.csv Purchase data
Components 6
Data preparation
- Purchase data
customer_shopping_behavior.csv - Python analysis
Customer_Shopping_Behavior_Analysis.ipynb
Business analysis
- SQL analysis
customer_behavior_sql_queries.sql
Reporting
- Power BI dashboard
customer_behavior_dashboard.pbix - Analysis presentation
Customer-Shopping-Behavior-Analysis.pptx
Other components
- Analyst
Connections 5
- Purchase data → Python analysis: analyzes
README.md - Python analysis → SQL analysis: prepares for
README.md - SQL analysis → Power BI dashboard: analyzes for
README.md - Analyst → Power BI dashboard: explores
README.md - SQL analysis → Analysis presentation: informs