Data Warehouse

Analytics & Reporting

MySQL star schema powered by a Python ETL pipeline. Query tenant-scoped views directly from Metabase, Superset, Tableau, or any SQL client.

MySQL

Freight Data Warehouse

Bookings, quotes, containers, finance line items, and milestones. Pre-built KPI views for OTIF, profitability, transit time, and quote conversion.

Shipments Quotes Finance OTIF Trade Lanes

MySQL

CFS Data Warehouse

Import containers (MBL), packages (HBL), export on-hand cargo, and CFS charges. KPI views for dwell time, devan efficiency, LFD compliance, and manifest accuracy.

Import MBL Import HBL Export On-Hand Charges LFD

Database

logiware_dwh (MySQL 8)

Update Frequency

Every 3 hours (ETL scheduler)

Access

Tenant-scoped tenant_v_* views

Schema Files

freight-dwh.drawio & cfs-dwh.drawio