Skip to content

Latest commit

 

History

History
48 lines (35 loc) · 1.09 KB

File metadata and controls

48 lines (35 loc) · 1.09 KB

📦 Real-Time Inventory Management System

This is a web-based inventory management system built using Python, Streamlit, MySQL, and Power BI.

It helps businesses manage their stock, reduce errors, and get real-time updates using data visualization.


🚀 Features

  • 🔐 User login and registration (with SHA-256 security)
  • 📝 Add, update, view, and delete products
  • 📊 Live dashboard with Power BI integration
  • 🛒 Supplier and stock tracking
  • 📡 Real-time database updates

🧰 Technologies Used

  • Python
  • Streamlit
  • MySQL
  • Power BI

⚙️ How to Run

  1. Clone the repo or download the files
  2. Install required libraries:
    pip install -r requirements.txt
  3. Run the program: streamlit run inventory_app.py
  4. Open in browser:
    http://localhost:8501

📊 Power BI Integration

The MySQL database is connected to Power BI for live dashboards.
Charts include stock levels, product trends, and supplier performance.


✨ Future Enhancements

  • Cloud database support
  • AI-based demand forecasting
  • Mobile-friendly UI