[vc_section full_width=”stretch_row” css=”.vc_custom_1764240299714{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 45px !important;padding-bottom: 0px !important;background-color: #ffffff !important;}”][vc_row full_width=”stretch_row” css=”.vc_custom_1764239630188{margin-top: 0px !important;margin-bottom: 0px !important;padding-top: 0px !important;padding-bottom: 10px !important;}”][vc_column css=”.vc_custom_1764238276751{margin-bottom: 25px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][vc_column_text css=”.vc_custom_1764239679277{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Enterprise Data Warehouse Implementation Enabled Improved Business Performance

[/vc_column_text][vc_column_text css=”.vc_custom_1764236927998{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]The client is a holding company that focuses on purchasing, leasing, and resale of marine cargo containers. It is one of the world’s largest intermodal container lessors with more than 4 million Twenty-Foot Equivalent Units (TEU) in its owned and managed fleet. It also leads the resale industry, having secured the status as one of the largest sellers of used containers with over 1,000 clients purchasing more than 130,000 units annually from it.[/vc_column_text][vc_column_text css=”.vc_custom_1764236951460{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

Background

[/vc_column_text][vc_column_text css=”.vc_custom_1764236993548{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]To meet its analytical reporting needs in a manner that would reduce traditional dependence on IT, the client had embarked upon a Business Intelligence (BI) initiative.[/vc_column_text][vc_column_text css=”.vc_custom_1764236983925{margin-top: 0px !important;margin-bottom: 35px !important;}” el_class=”text-block”]

DiLytics’ Solution

[/vc_column_text][vc_column_text css=”.vc_custom_1764237013012{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]DiLytics implemented an enterprise data warehouse project that sourced data from multiple homegrown systems – General Ledger Data from JDE, Billing Data from AS400 and Asset Management Data from Real Asset Management (RAM). The data warehouse caters to the reporting needs of upper management (CEO & CIO), marketing, operations, resale, credit, accounting, finance & FP&A teams of the client: [/vc_column_text][vc_column_text css=”.vc_custom_1764237030661{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]CEO/CIO Dashboards:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237081315{margin-bottom: 20px !important;padding-left: 35px !important;}”]

• Provided critical dashboards & reports for top management like Net Operating Income (NOI), Top clients, Fleet Performance

[/rt_list_style][vc_column_text css=”.vc_custom_1764237060117{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Marketing Team:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237178372{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Provided overview of lease-outs, turn-ins, bookings & container utilization
• Insight into factory inventory, factory lease-outs, average days units in the factory & equipment ramp-up days
• Reports on booking activity, unbooked credit capacity & container float Key Performance Indicators (KPIs)
• Created reports to help Identify best-performing depots and help reposition containers at minimum costs
• Provide detailed insight into client activity & client KPIs like credit limit, on-hire position, average rent rate, average age of containers, DSO & lease details
• Provided dashboard to help track depot activity with reports like stock availability by depot, average days containers are at depot & ramp-up report to identify average turn-in to lease-out duration

[/rt_list_style][vc_column_text css=”.vc_custom_1764237144348{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Operations Team:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237158707{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Created an overview dashboard to track the global turn-ins, damaged turn-ins, days in depot, etc
• Created a repair dashboard specially designed to provide information on units repaired, number of units awaiting repair, units pending repair, average days taken to repair and repair cycle history

[/rt_list_style][vc_column_text css=”.vc_custom_1764237198386{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Resale Team:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237215171{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Provided resale team with a powerful dashboard that provides insight into a number of units sold, average sales prices, sales around days & profit/loss metrics over the last 15 months
• Provided resale activity dashboard with top resale locations, best resale prices, best locations by sales volume, etc
• Enabled resale client activity dashboard

[/rt_list_style][vc_column_text css=”.vc_custom_1764237231923{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Credit Team:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237247230{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Provided bankruptcy dashboard to help recover containers from bankrupt lessees
• Created KPIs to provide insight into total containers held, containers recovered, recovery %, containers booked for turn-in & balance to be recovered
• Provided a detailed list of units held by bankrupt lessees and their sales details
• Provided credit watch reports by the client

[/rt_list_style][vc_column_text css=”.vc_custom_1764237266662{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Accounting Team:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237284082{margin-bottom: 20px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Provided a dashboard with various reports like balance sheet summary, container count summary, write-down/write-up summary, etc
• Provided disposal summary and detail reports by age, manufacture date, owner, balance sheet indicator, equipment type, etc
• Provided reports on Direct Finance Lease (DFL) units

[/rt_list_style][vc_column_text css=”.vc_custom_1764237302597{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”text-block”]Forecast Planning & Accounting:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237321490{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Created a custom cube in ESSBASE for budgeting and forecasting
• Created multiple oracle analytics reports to help analyze new production data

[/rt_list_style][vc_column_text css=”” el_class=”text-block”]

Business Benefits

[/vc_column_text][vc_column_text css=”.vc_custom_1764055496415{margin-bottom: 10px !important;}”]The initiative delivered a broad range of business benefits, including:[/vc_column_text][rt_list_style list_style=”seven” list_css=”.vc_custom_1764237360667{margin-bottom: 35px !important;padding-left: 35px !important;}” list_extra_class=”text-block”]

• Improved business performance via enablement of insights allowing tracking of key metrics such as utilization, off-hire units, on-hire units, disposed of units, etc
• Improved container management via insights into container capacity, container activity (repairs, movement, utilization); sale price trends, resale container inventory, resale container activity, and resale client overview
• Enhanced compliance with corporate governance requirements via the enablement of reports from the Real Asset Management (RAM) system
• Simplification of month-end, quarter-end, and year-end processes by providing reports on Gross Book Values (GBV), Net Book Values (NBV), depreciation and write-down data

[/rt_list_style][vc_column_text css=”” el_class=”text-block”]

Technical Stack

[/vc_column_text][vc_column_text css=”.vc_custom_1764239374834{margin-bottom: 0px !important;}” el_class=”text-block”]Source Systems: Oracle ERP Cloud, JD Edwards, Homegrown Solutions for Billing, Leasing, Repair, Operations, Asset Management

Data Integration Tool: Microsoft SQL Server Integration Services (SSIS), Oracle Data Integrator

Data Warehouse: Microsoft SQL Server Database, Oracle Database Cloud Service

Reporting Tool: Oracle Analytics, Oracle Analytics Cloud[/vc_column_text][/vc_column][/vc_row][/vc_section][vc_row full_width=”stretch_row” equal_height=”yes” content_placement=”middle” css=”.vc_custom_1764238185528{margin-top: 0px !important;margin-bottom: 0px !important;background-color: #ffffff !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}”][vc_column width=”1/3″ css=”.vc_custom_1531997568277{margin-top: 0px !important;margin-bottom: 10px !important;padding-top: 0px !important;padding-bottom: 0px !important;}”][/vc_column][vc_column width=”1/3″][vc_column_text css=”” el_class=”text-block”]

DiLytics Delivers

[/vc_column_text][/vc_column][vc_column width=”1/3″][vc_custom_heading text=”View all Success Stories →” font_container=”tag:h6|font_size:16px|text_align:right|color:%23dd3333|line_height:26px” use_theme_fonts=”yes” css=”.vc_custom_1660717315754{margin-top: 0px !important;margin-bottom: 10px !important;}” el_class=”font-weight-medium” link=”url:https%3A%2F%2Fdilytics.com%2Fsuccess-stories%2F|title:Success%20Stories”][/vc_column][vc_column][rt_case_study_style case_study_style_variation=”seven” case_study_display_filter=”no” case_study_enable_title=”yes” case_study_enable_excerpt=”yes” case_study_spacing=”30″ case_study_looping_sort=”ASC” no_of_case_studies=”3″][/vc_column][/vc_row]