arijit-7612/Customer_Trends_Analysis — reverse-engineered prompt

Build me an end to end customer shopping behavior analysis project using the CSV data. I want it to clean the transaction data, fix missing review ratings in a sensible way, standardize the column names, create useful customer fields like age groups and purchase frequency in days, and remove any duplicate or redundant promo fields.

Then load the cleaned data into a PostgreSQL database so I can run business questions with SQL. Include queries that answer things like revenue by gender, best rated products, subscriber versus non subscriber behavior, shipping method spending, discount heavy products, customer segments, top selling items by category, and revenue by age group.

I also want a Power BI dashboard that makes the insights easy to understand for a business audience, with clear charts and a summary of recommendations around subscriptions, loyalty, marketing targets, and discount strategy. Please make the notebook, SQL file, and dashboard easy to rerun locally, and look up current docs online if needed.