Analytics

Home /
Categories /
Analytics

Building Real-Time Terminal Dashboards: From Excel to Operational Intelligence

The Problem: When Excel Becomes the Bottleneck Terminal planning at GCT ran on a collection of Excel spreadsheets that had accumulated over years. Volume forecasts were in one sheet. Actual crane moves were in another. Dwell targets were in a third, manually updated by the planning team each morning. There was no connection between the three — no automated refresh, no single source of truth, no way to see the gap between plan and actual in real time.

The Silent Migration: Moving to Microsoft Fabric Without Breaking Production

The Problem When I inherited the analytics environment, it was a patchwork of tools that had grown organically over years: a mix of Excel reports scheduled by hand, a handful of Power BI workspaces with no consistent naming, and several ETL pipelines that only one person understood. Nobody knew what was production vs. ad hoc. Nobody owned the lineage. When something broke, the first question was always “who touched this last?”