Three industries, three kinds of work

Challenge

Manufacturer with legacy Informatica PowerCenter (12 years old, 350+ pipelines) — maintenance costs growing, talent scarce, performance issues at volume.

Approach

Wave-based migration to Qlik Talend Cloud. Assessment of all pipelines, parallel running, automated validation, phased per business domain.

Result

350+ pipelines migrated over 14 months without business disruption. Maintenance costs −45%. New pipelines now 3-5× faster to build on the modern platform.

Challenge

Discrete manufacturer running SAP BW for 15+ years. Platform and licensing costs climbing, data scientists locked out of direct SAP access and forced into weekly extract workflows.

Approach

Extraction from SAP BW + SAP ECC via Qlik Talend Cloud into a Snowflake lakehouse, Data Vault 2.0 modelling, erwin Data Intelligence for end-to-end lineage from SAP field to dashboard cell. Five-month parallel run for critical reports.

Result

SAP BW decommissioned after 11 months. Platform and licensing costs −60%. Data scientists gain direct access to transactional SAP data for the first time, with full lineage and governance preserved.

Challenge

Manufacturer with 8 production lines generating sensor data that was never used operationally. Unplanned downtime accounted for 12% of production time; maintenance was scheduled on calendar, not data.

Approach

Streaming ingestion of sensor data via Qlik Talend Cloud into Snowflake. Qlik Predict failure-prediction models per machine type (trained on 18 months of history). Per-line OEE dashboards in Qlik Sense with operational alerts.

Result

Unplanned downtime from 12% to 7% in year 1 (−40%). Estimated annual savings €2.3M through productivity recovery and targeted interventions. Maintenance team now plans interventions on data instead of calendar.

Challenge

Logistics provider with 40+ sites and 7 different WMS and TMS systems — no real-time insight into stock or delivery times, customer promises based on estimates, dispatch working off overnight batch.

Approach

CDC pipelines via Qlik Talend Cloud into a Snowflake lakehouse, real-time streaming for critical events, Qlik Sense dashboards plus event-driven alerts through Qlik Application Automation. Phased decommissioning of legacy reporting cluster.

Result

Real-time stock visibility across all 40 sites within 7 months. Customer promises on delivery dates +18% accurate. Operational dispatch decisions based on live data instead of overnight batch. Legacy reporting cluster taken out of operation.

Challenge

Logistics group with Oracle BI EE end-of-life on the horizon. 240+ business-critical operational reports, some carrying 10+ years of weight, and no self-service access for planners and operational leads.

Approach

Full inventory and criticality assessment of all 240 reports. Phased Qlik Sense rebuild with self-service governance on Qlik Cloud, 4-month parallel run per business domain, automated regression tests on key figures during cut-over.

Result

240 reports successfully migrated in 9 months. Oracle BI EE licence cost −55% (post-decommissioning). 100% uptime during transition. Planners now have self-service access with governance maintained through Qlik Cloud.

Challenge

Transport company with 850 trucks/day where routes were drawn up by planners on gut feel. Exceptions (traffic, weather, load changes) cost 18% extra fuel and planners worked an average of 90 minutes/day overtime.

Approach

Qlik Predict model on historic routes plus live traffic and weather data. Real-time scoring visible in Qlik Sense, integrated with the existing TMS via REST API. Planners retain final responsibility; the model delivers ranked alternatives.

Result

Routes shortened by 14% kilometres per day. Fuel savings €720k/year. Planner time −30% (each planner can manage 6 additional trucks). Customer OTIF (on-time in-full) +6%.

Challenge

Dutch bank with customer data spread across 15+ core systems — no golden record, marketing and risk operating on different customer definitions, GDPR rights (access, erasure) hard to execute.

Approach

Master Data Management programme with erwin Data Modeler (canonical customer model), data integration via Qlik Talend Cloud, governance forum with data stewards per domain. Per-field survivorship rules.

Result

4 million customer records consolidated into golden records. GDPR requests from 4 weeks to 3 days (−90%). Marketing campaign targeting +28% conversion on validated segments.

Challenge

Bank with core banking on mainframe (z/OS, DB2). 6-hour batch loads into the legacy data warehouse; analytics teams habitually worked on "yesterday's data". Mainframe MIPS costs grew in step with BI load.

Approach

Qlik Talend Cloud CDC on z/OS DB2 (log-based, no impact on the operational platform). Streaming pipeline into a Snowflake lakehouse, dimensional + Data Vault 2.0 modelling. Mainframe reporting load offloaded to Snowflake; analytics rights revisited.

Result

Analytics latency from 24 hours to <1 minute. Mainframe MIPS for BI workloads −35% (direct TCO saving). Average analytics query time −85%. Mainframe team no longer carries hot-week peak on report runs.

Challenge

Financial institution with COREP/FINREP reporting built across 4 different legacy systems. Lineage was maintained manually in Excel spreadsheets; DNB audits took 8 weeks of preparation; BCBS 239 maturity assessment landed at level 2.

Approach

erwin Data Intelligence for end-to-end lineage from source system to report line, Qlik Talend Cloud for data consolidation, governance forum with regulator-ready audit trail. Decommissioning of the two oldest legacy reporting platforms.

Result

BCBS 239 compliance achieved across all 14 principles. Audit preparation from 8 weeks to 2 weeks (−75%). Zero findings at the next DNB inspection. 2 legacy reporting platforms out of operation.