INTRODUCTION
Pratt & Whitney, a global aerospace manufacturer, set out to streamline how SAP data is extracted, transformed, and used
across their analytics and reporting environment.
They aimed to eliminate Excel-based workflows, reduce manual
data handling, and respond faster to growing business demand without increasing dependency on development teams.
It is a suite of tools for SAP designed to accelerate the implementation of solutions, primarily without requiring code changes.
We're delivering solutions faster and at a lower cost, without the need for extensive custom development.
Rafael Perez
Manager, Digital Technology
The Challenge
1. Business logic had to be rebuilt outside SAP
Extracting data into reporting systems required duplicating SAP business logic in ETL processes increasing complexity, maintenance effort, and risk of inconsistencies.
2. Manual and Excel-based workflows slowed down operations
Key processes relied on Excel and manual data handling, requiring several hours of work each day and limiting scalability.
3. Delivery depended on development cycles
Even small reporting or data changes required developer involvement — slowing down delivery and making it difficult to keep up with business requests.
This eliminates the need to replicate the business rules embedded in the ALV reports.. ensuring consistency and reducing redundancy.
the solution
How They Used Insight Zap
Streamlining Data Extraction for Analytics
The data analytics team leveraged Insight Zap's Publisher to extract data directly from ALV reports.
- No need to rebuild business logic in ETL
- Direct integration into Power BI and SSRS
- Consistent data across reporting systems
Replacing Excel-Based Workflows
With the Creator, they transitioned key processes from Excel into SAP:
- Improved consistency and scalability
- Business rules applied directly inside SAP
- Reduced manual data handling
We've replaced manual Excel-based processes with SAP-driven automated workflows - improving efficiency,accuracy, and scalability.
Accelerating Change Deliveryfor Analytics
- No need to rebuild businesImplement changes directly in production environment
- Iterate rapidly without development cycles
- Respond faster to evolving business needs
Enabling "What-If" Scenario Analysis
Teams gained the ability to model and test scenarios quickly:
- Evaluate business impact in real time
- Collaborate with stakeholders during the process
- Adjust and refine without waiting for development
We can run 'what-if' scenarios quickly and collaborate in real time, without the need for time-consuming development.
THE RESULTS
Today, Pratt & Whitney delivers SAP-driven insights faster with less manual work and development dependency – without adding complexity or operational overhead.
- Reduced time to deliver analytics from weeks to days
- Shortened the cycle between request → delivery → iteration → action
- Reduced manual data handling by ~30–50%
- Saved ~10 hours of manual work per person, per week
- Eliminated duplication of business logic
- Reduced reliance on Excel and external workarounds
- Enabled faster response to business needs without increasing development workload
Insight Zap
