dmortalla / project8-segmentation Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Supply-chain efficiency analytics in Power BI with SQL and Python integration.

darrellmortalla.com

0 stars 0 forks Branches Tags Activity

Notifications

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
data		data
docs		docs
scripts		scripts
sql		sql
README.md		README.md
requirements.txt		requirements.txt

Repository files navigation

🚚 Supply Chain Efficiency Dashboard (Python + SQL + Power BI)

Comprehensive supply chain analytics system that automates KPI tracking using Python, SQL, and Power BI.

Workflow

ETL script calculates delivery, defect, and cost KPIs.
KPI data stored in PostgreSQL database.
Power BI visualizes performance by region.
GitHub Actions automates daily ETL refresh.
Dashboard embedded on Hostinger portfolio.

Tech Stack

Python (pandas, SQLAlchemy)
PostgreSQL
Power BI
GitHub Actions
Hostinger