Drive Towards an Analytics Driven Organization using

INSERT PARTNER LOGO
Ognjen Ružić - Operations Manager
Sebastiano Černeka - IT Manager
CONNECT.
COLLABORATE.
INNOVATE.
Drive Towards an Analytics Driven
Organization using the Navis BI Portal
INSERT PARTNER LOGO
AGCT – An ICTSI Group Company
Adriatic Gate Container Terminal is part of the ICTSI Group – a dynamic Company with a global operation portfolio in managing container terminals
ICTSI is present in 6 continents, operating
29 marine terminals
in 21 countries
positioned
in some of the
world’s most strategic trade and
travel routes.
INSERT PARTNER LOGO
AGCT - Terminal Equipment and Throughput
THROUGHPUT
2014
149 500 TEU
CAPACITY
600 000 TEU
INSERT PARTNER LOGO
AGCT - The Terminal Layout
v2.5.2
INSERT PARTNER LOGO
AGCT Navis BI Portal
IT Perspective
INSERT PARTNER LOGO
Navis BI Portal – Technical Considerations
Installation
• simple, easy to follow setup and documentation
Configuration
• Joint effort by Navis and
AGCT
Maintenance
• Appliance Web Monitor Dashboard
INSERT PARTNER LOGO
AGCT BI Portal - Architecture & Prod. N4 Impact
BI Appliance
Windows Server 2008 R2
8x vCPU, 20GB RAM
HDD1 25GB
HDD2 30GB
BI Database
Windows Server 2012
SQL server 2008 R2
8x vCPU, 32GB RAM
HDD1 180GB (OS)
HDD2 180GB (SQL Data)
HDD3 40GB (CIFS)
INSERT PARTNER LOGO
Navis BI Portal – IT Lessons Learned
• Initially received HW Hardware
requirements quite higher than
Requirements
needed for current AGCT volume
IT Infrastructure
Impact
• Focus on CIFS disk Read/Write
Peformance, not vCPU/Memory
Production N4 • Almost nonexistent
• Total query time 9‐11 seconds
DB Impact
INSERT PARTNER LOGO
AGCT Navis BI Portal
Operations Perspective
INSERT PARTNER LOGO
Navis BI Portal – Operations Perspective
Importance
of
Knowing
Performance
• Vessel, Rail and Truck simultaneous
operations – importance of
synchronization
• Real time data for immediate warnings
and rectifying measures
• Statistical data and „after the fact”
debriefing for strategical measures and
direction
• What gets measured gets done
INSERT PARTNER LOGO
Need for improvement
Now
• Monitoring and reporting done through Excel tables
• Input data done manually or raw data from N4
• No automation
• Limited real time information
• Lower accessibility for management
• Time consuming tedious processes
Goal
• Live monitoring
• Visually comprehensive dashboards
• Reporting tool with automatic refresh
• Faster and wider information spread
• Reducing manual input error possibility
INSERT PARTNER LOGO
Setting up for NAVIS BI
Helping
NAVIS to
help
ourselves!
•
•
•
•
•
•
•
•
Engaging various stakeholders
Choosing N4 superusers
Training
Listing required data functions, dashboards
and reports
Verifying data type and measurement
requirements
Evaluating data integrity
Comparing result output of Beta product with
current reports
Providing feedback to NAVIS project team
INSERT PARTNER LOGO
Report value Case One
* Monitoring crane
productivity by hour
in real time
* Graphic oversight if
cranes are balanced
* Graphic oversight
productivity flow
* React promptly on
delay or decrease in
productivity
INSERT PARTNER LOGO
Report value Case Two
* Overview of truck
visit daily
distribution
* Compare on
week-on-week base
* Compare truck
visit vs avg turn
time
* Enables clear
visibility of anomaly
INSERT PARTNER LOGO
Report value Case Three
*Easy overview of
each type weight
*Scheduling –
„BUILD AND
FORGET”
*Creating report in
any format
*Sending directly to
designated email
INSERT PARTNER LOGO
Further product improvements
Improvements
requested
by AGCT
from
Navis BI Team
• Rail operations data
• Flex fields
• Additional ability and user
friendly function
• Simultaneous work on
multiple reports
INSERT PARTNER LOGO
AGCT Navis BI Live Demo
Thank you!
INSERT PARTNER LOGO
| [email protected] | www.ictsi.hr | [email protected] |