Logistics control tower
On-time-in-full deliveries, distribution network map, fleet, distribution centers, and delivery exceptions for a nationwide parcel and freight company.
The challenge
Expreso Cóndor ran its operation across a TMS, fleet telemetry, the WMS of four distribution centers, and exception spreadsheets. Nobody saw in one place where the delivery promise broke or what each failure cost.
Python · Power Query · DAX · Power BI
Key findings
- OTIF of 93.8% vs. a 95% target; the weakest hub is Malambo (91.7%).
- Bringing below-target cities to 95% would recover about 25,600 deliveries.
- Cutting exceptions by 30% would save about COP 321 million; 16 vehicles exceed 70 days in the shop.
Capabilities shown
- Network map with no external dependencies
- OTIF and traffic lights computed in DAX
- Exception Pareto and carbon footprint
- Operational heatmap for shift planning
Dashboard tour
7 views. Click any view to enlarge it.
Live interactive dashboard
Use the filters and the navigation menu inside the dashboard, just as a manager would.
More prototypes from this service
Power BI dashboard360° digital brand intelligence
Social media, social listening with emotion analysis, web traffic, and campaign ROI in one dashboard to decide what to publish, where to invest, and when to react.
View prototype
Power BI dashboardSales intelligence
Sales, margin, targets, customers, and regions for a specialty coffee brand selling through four channels: B2B distribution, own stores, e-commerce, and marketplaces.
View prototype
Power BI dashboardManagement performance tracking
Balanced scorecard, project portfolio with earned value, action plan, and risk matrix for the management committee of a logistics company.
View prototype
Power BI dashboardFinance & scenarios
Income statement, budget vs. actuals, cash flow, working capital, and a scenario simulator to anticipate liquidity over the next 12 months.
View prototype
n8n + AI automationWeekly AI executive report
Every Monday, management gets a clear report: what happened, why, and what to do.
View prototype
AI agentAsk your data
Managers ask in plain language; the agent explores the database, writes and fixes SQL, charts the result, and answers with findings and a recommendation.
View prototypeReady to turn your data into smart decisions?
We build this kind of solution with your own data. Let’s start with a free 30-minute call.