Case study
Transportation
Data Integration & Advanced Analytics, Snowflake
80%
Less Manual Reporting
The Challenge
Reporting across 70 service centres ran on manual spreadsheets, burning hundreds of hours weekly and still arriving late and inconsistent.
Fourteen years of operational data sat trapped in IBM i (AS/400), blocking centralised reporting and historical analysis.
Legacy reporting had no automation, making it near impossible to consolidate sales, inventory, and profitability data accurately or on time.
Our Solution
Built a modern data platform using automated CDC pipelines to extract IBM i (AS/400) data into an AWS-based data lake.
Implemented a Snowflake Medallion architecture with dbt Cloud transformations for governed, scalable modelling and trusted analytics.
Orchestrated end-to-end pipelines with Dagster and delivered interactive Amazon QuickSight dashboards with secure, role-based access.
Business Impact
Reduced manual reporting effort by a projected 80%, replacing 26 spreadsheet-based reports with four interactive dashboards.
Enabled centralised, near real-time reporting with sub-five-second dashboard performance for approximately 150 business users.
Unlocked 14 years of historical data, transforming accuracy, governance, and decision-making on a scalable analytics platform.
Workato Integration: How Automated Onboarding Replaced Manual HR Data Sync Across 10+ Systems
Explore Story
Workato ETL: How Scheduled Product-Data Sync Cut a Week-Long Process Across ~70 Brands
Explore Story
Salesforce Transformation: How AI-Powered Metadata Analysis Untangled Fragmented CRM & CPQ Environments
Explore Story
