How roshika1235/customer_behaviour_analysis works
This project turns customer transaction data into cleaned, engineered data, PostgreSQL business analyses, and an interactive Power BI dashboard. The README documents the cleaning, feature engineering, database load, ten SQL questions, and dashboard KPIs and analysis views. The notebook and dashboard internals were not sampled, so their nodes represent documented responsibilities; the documented database-to-dashboard connection is shown without detailing its implementation.
Main entry points: customer_behaviour_analysis.pbix Power BI dashboard · customer_behaviour.ipynb Clean and engineer · customer_behaviour_analysis_sql.sql Business queries
Components 9
Data preparation
- Clean and engineer
customer_behaviour.ipynb
SQL analysis
- PostgreSQL
- Business queries
customer_behaviour_analysis_sql.sql
Business intelligence
- Power BI dashboard
customer_behaviour_analysis.pbix - KPIs and revenue
customer_behaviour_analysis.pbix - Customer analysis
customer_behaviour_analysis.pbix - Product analysis
customer_behaviour_analysis.pbix
Other components
- Transaction data
- Business decision-maker
Connections 8
- Transaction data → Clean and engineer: provides records
- Clean and engineer → PostgreSQL: loads cleaned data
- Business queries → PostgreSQL: queries
- PostgreSQL → Power BI dashboard: supplies data
- Power BI dashboard → KPIs and revenue: presents
- Power BI dashboard → Customer analysis: presents
- Power BI dashboard → Product analysis: presents
- Business decision-maker → Power BI dashboard: explores