Stocks in Ports

Challenge

Inventory held in ports was reported separately by each site, in different formats and on different schedules. Planners had no single, reliable picture of what was where, which made it hard to plan shipments and allocate resources.

Approach

1. Audited the data each port site produced and agreed one common structure for stock records.
2. Collected and consolidated data from every site and source into a single dataset.
3. Cleaned and standardised the records so figures from different ports could be compared directly.
4. Designed the dashboard around the questions planners ask every week: how much, where, and how it is changing.

What we delivered

• A consolidated stock dataset covering all port sites.
• An analytical dashboard with an overview across ports and drill-down to each site.
• A documented data blueprint showing how data moves from source to dashboard.

Outcome

Consolidated data improved the quality of analytics and sped up business-intelligence work. Logistics and supply-chain teams gained a shared view for strategic planning instead of reconciling site reports by hand.