jitu123890/Customer-shopping-behavior-analysis-using-Python-SQL-Power-BI- ? reverse-engineered prompt

Build me an end to end customer shopping behavior analysis project from this dataset.

I want a Python notebook that cleans the customer shopping data, explores it, and creates useful charts and summaries about things like demographics, product categories, discounts, reviews, seasons, payment methods, and shopping channels. Then I want the cleaned data turned into SQL ready analysis with a set of queries that answer business questions about customer segments, loyalty, repeat purchases, and what drives buying decisions.

Also create a simple Power BI dashboard idea that shows the main trends, key KPIs, customer groups, and product performance in a way a business team could understand quickly. Please include clear findings and short business recommendations based on the analysis, like how to improve sales, engagement, and customer loyalty.

If anything in the data or tooling needs current best practice, look up the latest docs online and use that. Keep everything organized so it feels like a polished portfolio project.