Project Velocity
Amazon Delivery Performance Analytics
End-to-end delivery operations analytics on Amazon data. Models a star schema (fact_orders + 4 dimensions), runs a 7-script SQL pipeline with window functions and CTEs, and performs Python EDA covering on-time delivery rates, agent productivity rankings, weather/traffic impact on delays, and vehicle type efficiency.
Key features & capabilities.
Star schema: fact_orders + dim_agents, dim_locations, dim_context_factors, dim_delivery_details
7-script SQL pipeline from DDL creation through analytical views
Window functions for agent productivity rankings, running totals, and lag/lead analysis
Weather and traffic impact analysis on delivery delay rates
Vehicle type efficiency comparison and distance-vs-delay correlation
Full business requirement documentation: BRD, stakeholder analysis, KPI definitions
Want something like this?
We build full products — from idea to deployment. Let's talk.
Ready to build?
Ready to build what's next?
Tell us about your product. We'll come back with a plan, a team and a timeline.