Case
Sea-Invest: transforming data management with a real-time dashboard
Table of contents
Client overview
Sea-Invest is an international terminal operator specializing in dry bulk, fruit and food, breakbulk, liquid bulk, and containers. Operating in 23 ports across seven countries, the group has established a strong reputation in stevedoring, transport, warehousing, and other port-related activities. With over 5,500 employees and handling more than 170 million tons of cargo annually, Sea-Invest is a crucial link in its customers’ supply chains.
Initial situation
Sea-Invest managed a vast and complex array of data in their data warehouse, encompassing detailed quantity overviews per tank, planning information per vessel and jetty, and upcoming tank order information. However, they needed a solution to consolidate this diverse data into a unified, real-time dashboard. The goal was to reduce the manual effort required to communicate this data to clients while ensuring precision and timely updates.
Solution delivered
We developed a comprehensive real-time dashboard tailored to Sea-Invest’s needs. Key aspects of the solution included:
Technology and integration
- Built the dashboard using React, ensuring a dynamic and user-friendly interface.
- Fully integrated the solution on top of the client’s existing infrastructure, including STIP ERP and Azure Data Warehouse (DWH), by utilizing our own developed Symfony API Middleware to ensure seamless connectivity and performance.
Data consolidation
- Consolidated all essential data into a single dashboard, eliminating the need for manual communication.
- Ensured real-time updates through API and middleware integrations, providing up-to-the-second accuracy.
Scalability
- Designed the dashboard to accommodate multiple clients with different access rights.
- Included detailed information on nominations, orders, jetty planning, and short tank overviews, ensuring relevance for each client.
Results
Improved efficiency: reduced manual efforts and streamlined the communication of critical logistics data.
Real-time access: clients, including Total, BP, and Glencore, now receive accurate, live updates on their operations.
Infrastructure compatibility: the solution was seamlessly built on the client’s existing Azure infrastructure, ensuring cost-effectiveness and integration.
Scalability: started with one client and expanded to include most of Sea-Invest’s major clients, enhancing the overall client experience.
