Harshit-1602/Inventory_System — reverse-engineered prompt

Build me a full stack inventory analytics system for Vermin Industries that replaces their manual Excel tracking with one central place for inventory data and reporting.

I want a simple Streamlit app in Python where staff can load or manage inventory records, store everything in MySQL, and view useful analytics without touching spreadsheets. The dashboard should show things like current stock, item movement, category summaries, stock value, trends over time, and any items that need attention. Keep the interface clean and easy for a non technical user.

Also set it up so the data can be used in Power BI for more polished reporting, since there is already a Power BI report in the project. Include clear setup steps, database schema, sample data if needed, and make sure the app can run locally from scratch. Look up current docs online if you need to.