Mayankchauhan008/Project-FORESIGHT ? reverse-engineered prompt

Build me a Streamlit dashboard for retail demand and inventory planning called FORESIGHT.

I want it to load sales and inventory CSV files, clean the columns automatically, and turn the data into simple business views that help me see what needs attention right away. The app should include an executive summary, sales analytics, demand forecasting, inventory status, risk scoring, product details, and a decision cockpit that tells me which SKUs need replenishment, which are healthy, and which might need markdowns or closer watching.

Please make the dashboard easy to use, with filters for category and SKU, clear KPI cards, interactive charts, and a downloadable CSV of the decision queue. If some columns have different names, handle that gracefully and standardize them. Use the data in the repository if it helps, and look up current docs online if you need to. I’d also like the app to show useful warnings when data is missing or invalid, so it feels ready for real business use.