ridhima183/Retail-StreamLit-ETL-SalesDashboard ? reverse-engineered prompt

Build me a retail sales analytics project that pulls data from a MySQL source database, stages it, checks data quality, and loads it into a clean warehouse I can trust.

I want the pipeline to read from tables like customers, products, orders, order items, payments, employees, and departments, then move everything into staging tables first, validate it with Great Expectations style checks, and only then load a star schema warehouse with customer, product, category, employee, department, and date dimensions plus sales and payment fact tables.

Please also include watermark and row hash tracking so it only processes new or changed data, plus batch tracking and a reconciliation view that compares source and warehouse counts. On top of that, make a simple Streamlit dashboard with Plotly charts for sales, customers, products, and payments, so someone can browse the insights without writing SQL.

If you need to, look up current docs online for any library details.