Skip to content

sureshthevar05/Inventory-Analytics-System-In-Python-Using-SQL-PowerBI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 

Repository files navigation

📦 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

About

Real-Time Inventory Analytics System A smart inventory management system built using Python, MySQL, Streamlit, and Power BI. It helps businesses track stock levels in real time, manage products easily, and make data-driven decisions using interactive dashboards. The system includes features like user login, product management, and visual reporting.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors

Languages