Organizing and Managing Data for an Aerospace Manufacturing Company

Aerospace Manufacturer

 The process was lengthy and time-consuming requiring more than sixty analysts working full time. Weekly executive reports were usually late, and the quarterly plans were rarely completed on time.

Disconnected

Data used in building operating and financial plans was spread out over several SAP data bases, multiple Excel files, and Access databases.

Inefficient

Analysts manually copied and pasted data from various sources into over 4,000 spreadsheets.

Errors

Errors were a common occurrence and work was incorrect even when submitted with a delayed deadline.

Challenge

The Challenge. Data used in building operating and financial plans was spread out over several SAP data bases, multiple Excel files, and Access databases. Analysts manually copied and pasted data from various sources into over 4,000 spreadsheets. The process was lengthy and time-consuming requiring more than sixty analysts working full time. Weekly executive reports were usually late, and the quarterly plans were rarely completed on time. Errors were common and delays very high.

The Solution

The Solution. CT Global’s team used SAS Data Management to connect all the data sources and import into SAS. Data jobs were scheduled in SAS to run nightly. SAS was also used to build reports from the centralized data hub on an on-demand or weekly schedule. This freed up analysts’ time and also eliminated mistakes and ensured on-time delivery of reports.

Interested?

Fill out the form below and we will contact you with more information.