How jitu123890/customer-shopping-behavior-analysis-using-python-sql-power-bi- works
This is a retail customer-shopping analytics project. Its documented workflow turns raw shopping data into cleaned analysis, SQL business queries, a Power BI dashboard, and business insights for decision-makers. The graph uses the repository’s actual flat-file paths; some filenames differ from the README’s illustrative directory structure. Relationships are based on README statements only, since no source excerpts were provided.
Main entry points: Customer_Shopping_Behavior_Analysis.ipynb Python analysis · customer_behavior_dashboard.pbix Power BI dashboard · customer_shopping_behavior.csv Customer data · customer_behavior_sql_queries.sql Business queries
Components 8
Shopping Data
- Customer data
customer_shopping_behavior.csv
Analytics Workflow
- Python analysis
Customer_Shopping_Behavior_Analysis.ipynb - SQL database
- Business queries
customer_behavior_sql_queries.sql
Business Intelligence
- Power BI dashboard
customer_behavior_dashboard.pbix
Business Outputs
- Business problem
Business Problem Document.pdf - Analysis document
Customer Shopping Behavior Analysis.pdf
Other components
- Retail stakeholders
Connections 5
- Customer data → Python analysis: analyzes
README.md - Python analysis → SQL database: prepares data for
README.md - Business queries → SQL database: queries
README.md - SQL database → Power BI dashboard: feeds analysis
README.md - Power BI dashboard → Retail stakeholders: presents insights
README.md