This project focus on generating insights on Behaviour patern of customer and visualization of the insights in a interactive dashboard that can be understood by both technical and non technical stake holders. We have used the CSV files, used pandas for generating and exploring data within Jupyter Notebook, and finally loading data into the SQL DB for Business Analysis and Dashboard is created in Power BI.
- Database: PostgreSQL
- Data Sources: CSV File
- Language: Python
customer-behaviour-analysis-PowerBI/
├── .gitignore
├── dashboard/
│ └── customer_shopping_behaviour_analysis_dashboard.pbix
├── datasets/
│ └── customer_shopping.csv
├── docs/
│ ├── documentation_business_analysis_sql.md
│ ├── documentation_connecting_to_postgres_db.md
│ └── documentation_data_exploration.md
├── Jupyter_Notebook/
│ └── customer_shopping_behaviour_analysis.ipynb
├── LICENSE
├── README.md
└── scripts/
└── customer_shopping_behaviour_analysis.sql
This Project is licensed under the MIT License. Feel Free to use and modify. :-)