High tech aerospace manufacturer: Data infrastructure creation and pipeline automation
A major manufacturer in the high-tech aerospace industry had developed a strong, lightweight carbon fiber-based airplane coating designed to protect planes from UV rays, lightning strikes, and even static electricity. To create this coating, however, was an involved process – a given batch of coating needed to go through processing at up to 3 different facilities.
The manufacturer had a geographically dispersed IT environment with no infrastructure in place to connect the disparate systems leveraged across the organization. This, combined with the fact supplies from different lots and suppliers were used at different sites, created a challenge surrounding traceability.
Traceability was a key issue for the aerospace manufacturer as there would often be variations in the quality of finished batches of the coating. Having no ability to track which facilities were involved in manufacturing a given batch of coating, let alone which specific supplies or machinery was used in the manufacturing process, meaning the aerospace manufacturer had limited ability to conduct root cause analysis.
As a result, the organization reached out to Neal Analytics to help gain clarity into their manufacturing process and enable better root cause analysis for variations in the finished product.
Neal Analytics worked hand-in-hand with the organization to understand the entirety of their business challenge. Neal then took action to help the manufacturer leverage and gain insights from their existing, geographically disparate systems while enabling the organization to clearly identify the specific site, machinery, and supplies being used in each specific batch of the final product.
To help the organization gain a better view of their data, Neal Analytics automated data movement from over ten on-premises systems across five of the organization’s manufacturing facilities to Azure Data Lake Storage via Data Factory.
The types of data in the data movement process included sensor data from manufacturing machinery, records of the supplies used in the process (including lot numbers), and other manufacturing data that enabled the organization to quickly drill down and conduct root cause analysis for products with quality variations.
Bringing all this data into an Azure Data Lake created one central area for the data to reside, facilitated by the use of USQL scripts to load the data to Azure Data Lake Analytics tables. This allowed for the data to be transformed, helping to eliminate gaps in traceability. Once transformed, data was then able to be loaded into Azure SQL Data Warehouse tables (now known as Azure Synapse Analytics) using PolyBase, making it easily usable in downstream activities such as data visualization or machine learning.
To help the organization take advantage of the downstream possibilities, Neal Analytics also built Power BI dashboards designed to support easier reporting.
By working with Neal Analytics, the aerospace manufacturer was able to take a series of fragmented data systems and gain a 360⁰ view of their manufacturing process. The Azure Data Lake connecting the disparate data sources has helped the organization eliminate gaps in traceability, enabled them to identify the causes for product quality variations more rapidly, and supported simplified reporting via Power BI data visualization. This, in turn, helps the organization reduce costs by supporting prompt remediation of issues and errors in manufacturing.
Since the data lake can ingest and process data much more quickly and efficiently than their on-premises environments, the organization has also gained access to an automated data pipeline that supports continuous analysis of final product quality. This has enabled the organization to predict the final product quality while it is still in the factory.