SQL | Python | Tableau | Data Visualization
End-to-end logistics analytics project using SQL, Python, and Tableau.
DHL U.S. Facility Network Dashboard
- SQL
- Python (Pandas)
- Tableau
- Total Facilities by State
- Facility Category Mix
- Saturday Pickup Rate
- Geographic Facility Coverage
- Category Share of Total Facilities
Key operational insights from the dashboard:
- Texas has the highest number of DHL facilities, making it the primary network hub.
- Drop Box and Drop Off Facility accounts for the majority of total locations.
- Saturday pickup coverage is highest in DHL Staffed Facilities compared to other categories.
- Facility distribution is concentrated in major population and logistics corridors.
- Coverage patterns highlight opportunities to optimize weekend service availability.
- SQL queries analyze facility and pickup data.
- Python performs exploratory analysis and data preparation using Pandas.
- Tableau visualizes operational KPIs.
- Texas leads all states by facility count.
- Drop Box and Drop Off Facility dominates total network share.
- Saturday pickup availability varies significantly by facility type.
- Facility coverage density is highest in large metro regions.