SAS works with leading manufacturer to develop visual data analytics programme
Technology manufacturing company uses SAS® Visual Analytics to streamline its manufacturing testing and deliver big data insights to senior management
A leading technology manufacturer's testing team tests components manufactured by the company for inclusion in its storage area network products. The team engaged in a project to prove to senior management that the analysis of machine-generated log files from the test process would provide greater insight into the overall manufacturing process, and that they should therefore be included in a data warehouse. The team also wanted to determine whether the log files generated during testing could indicate that a specific component was likely to fail in the field, and therefore incur a post-sales cost. Specifically, the team was trying to find patterns or correlations for certain variables within the logs that would indicate a component was likely to fail.
The test harness under investigation heated and cooled each component to defined temperature values, and ran a series of tests. The team wanted to determine whether there were temperature values at which the component never ever failed. Tests at these temperatures could then be eliminated and testing could be concentrated on more vulnerable areas. This process would reduce the length of the overall testing cycle and optimise the manufacturing process.
The team was keen to evaluate the insight garnered from this initial investigation, in order to identify if this approach could be applied across different business areas.
Unyielding legacy approach
"The company's traditional routines failed to deliver the desired result, and the data analysis took months to complete. The programmes used to represent the vast quantities of data graphically were inefficient, and the SQL statements were often terminating prior to completion due to their size and complexity. Using SAS Visual Analytics, the company can explore the data simply and visually, and can now create reports that bring findings to life," said Alex Manek, Principal Pre-Sales Consultant at SAS.
Close collaboration delivers easy-to-digest, highly visual insights for senior management
The team produced some interesting results. Indicators from a number of the variables at certain temperatures provided insight into the overall performance of the component at certain stress points. The team was also able to identify certain temperature ranges at which no results were ever recorded. This meant that the calibration of the test harness could be optimised.
From its analysis, the team was able to produce line graphs and histogram reports which outlined the results to senior management. The team was also able to record some screen videos to outline the ease with which these results had been found. In particular, they focused on the Explorer and Reporter functions of SAS® Visual Analytics. The team used the Visual Explorer interface to explore the data and extract variables of interest. This process was followed by use of the Reporter interface to transform the data into graphs which could be presented to management.
Gathering operational insights from data
"The service the SAS team provided has saved significant time and resources previously dedicated to the testing process. We can process much more data in far less time - using SAS, the time taken to identify variables of real interest has been reduced from months to just hours. We are also excited by the potential of SAS Visual Analytics, particularly for identifying components likely to fail in the field. Preventing component failure will save approximately €20,000,000 per year in reactive engineering costs across Europe," said a senior manager within the company's testing team.
Copyright © SAS Institute Inc. All Rights Reserved.
Technology manufacturer - SAS® Visual Analytics
Needed to eliminate superfluous tests from the manufacturing test process; needed to present insights from data in a visual format to senior management.
SAS® Visual Analytics; SAS® Data Integration Studio
Able to process more exhaustive quantities of data to gain better insights; increased efficiency - time taken to identify variables of interest is reduced from months to hours; cost savings of up to €20,000,000 per year in reactive engineering costs across Europe ; tool becomes proactive, as well as reactive.
“The service the SAS team provided has saved significant time and resources previously dedicated to the testing process. We can process much more data in far less time - using SAS, the time taken to identify variables of real interest has been reduced from months to just hours. We are also excited by the potential of SAS Visual Analytics, particularly for identifying components likely to fail in the field. Preventing component failure will save approximately €20,000,000 per year in reactive engineering costs across Europe.”
Senior manager within the company’s testing team