The Sales Management System is designed to manage customer sales, payment tracking, pending amounts, and branch-wise sales operations efficiently using SQL Server, Python, and Streamlit.
This project automates sales calculations, payment status updates, and analytical reporting for better business management.
- SQL Server
- Python
- Streamlit
- Pandas
- GitHub
- Customer sales management
- Branch-wise sales tracking
- Pending amount calculation
- Automated status updates using triggers
- Payment tracking
- Analytical SQL queries
- Dashboard reporting using Streamlit
- branches
- customer_sales
- payment_splits
- users
- CREATE TABLE
- PRIMARY KEY & FOREIGN KEY
- BULK INSERT
- GROUP BY
- Aggregate Functions
- CASE Statements
- SQL Triggers
- Joins
- Analytical Queries
Sales-Management-System/ │ ├── SQL/ ├── Python/ ├── Dataset/ ├── Documentation/ └── README.md
- Role-based authentication
- Email notifications
- Cloud database integration
- Export reports to Excel/PDF
This project demonstrates practical implementation of SQL Server, Python integration, trigger automation, and dashboard development for real-world sales management operations.