ZipParcel Logistics Analytics. A end-to-end data analytics project simulating a real parcel delivery company.

• Project Overview ZipParcel tracks customers, drivers, vehicles, routes, and deliveries across New York City. This project demonstrates the full data analytics workflow — from database design to business insights and visual dashboards.

• Tools Used MySQL — database design & querying MySQL Workbench — query execution & data export Microsoft Excel — dashboard & data visualization

• What's Inside SheetDescriptionCustomers20 customers across NYC boroughsDeliveries150 delivery records with status trackingDrivers20 drivers with experience & license dataRoutesDelivery routes with distance & durationVehiclesFleet informationDelay Reasons10 categorized delay typesDashboard4 visual charts summarizing key insights

• Key Insights Manhattan leads with the highest customer concentration 148 out of 150 deliveries were successfully completed (98.7% success rate) Delay causes are evenly distributed — no single failure point dominates