Harsh-Belekar/Advance-SQL-Project-Data-Warehousing-EDA-Advanced-Data-Analytics ? reverse-engineered prompt

Build me a complete SQL project in PostgreSQL that takes messy retail ERP and CRM style data and turns it into a clean data warehouse with a Bronze, Silver, and Gold flow.

I want the scripts to create the tables, load the raw CSV data, clean and standardize it, and then build a final star schema with fact and dimension tables for reporting. Please also add basic data quality checks so I can spot bad or missing records before using the data.

After that, create a separate analysis area with SQL queries that do exploratory analysis and business reporting for customers and products. I want things like sales trends, rankings, customer segments, product performance, and useful KPI summaries.

If anything is unclear, make reasonable assumptions and keep the project easy to run from the scripts. Include clear comments in the SQL and make it feel like a polished end to end portfolio project.