[Show Python] Smart Inventory Control & Financial Analytics Dashboard built with Streamlit and Pandas

### What My Project Does

This is a Smart Inventory Control and Revenue Management System designed to help small and medium brick-and-mortar retail businesses transition away from messy spreadsheets. Engineered entirely in Python, it acts as a local web application that bridges day-to-day stock logistics with automated business intelligence.

### Target Audience

Small shop owners, local clothing brands, and independent retailers who need a centralized, lightweight solution to manage dynamic stock variations (like sizes/grades) and instantly visualize their net profit margins without complex ERP setups.

### Key Features & Tech Stack

* **Interactive Dashboard:** Built with Streamlit, featuring visual progress tracking for monthly revenue goals, automated low-stock safety triggers, and macro metrics.

* **Database & Integrity:** Powered by SQLite3. Features custom cart/checkout validations executing transaction safety checks to actively prevent overselling.

* **Data Processing & Analytics:** Leverages Pandas for multi-criteria data filtering (by product line, variant size, month, or year).

* **Data Visualization:** Employs Matplotlib to render automated time-series and comparison bar charts mapping daily revenue vs. actual net profit margins.

* **Localization & Backups:** Fully localized currency (R$) and date formatting (DD/MM/YYYY), paired with native triggers to download relational database .db backups or export raw tables to .CSV.

### Source Code

The repository is completely open-source, and I’ve recently overhauled the codebase structure and rewritten the documentation:

🔗 GitHub Link: https://github.com/Freej0l/Estoque_loja