Data sorting is often a major pain point for many people when conducting data analysis. However, highly repetitive and frequent reports not only require a lot of time to produce, but also often require high timeliness. Therefore, in many cases, even if you know good analysis It can help improve yield, but because analysis results cannot be obtained in a timely manner, analysis is abandoned to help improve production capacity. Therefore, if the entire data collection and analysis process can be integrated into a set of standard analysis processes, the time for producing analysis reports can be greatly reduced and the analysis efficiency can be improved.
new version JMP17 Record the analysis process and automate the analysis
JMP has a very convenient tool platform for organizing data tables. JMP unique JSL The program editing function allows users to arrange standard operating procedures according to needs, including data collection and subsequent statistical analysis, to complete the production of analysis reports. With the new version, JMP When users edit and organize data tables, they can preview the status of the organized data tables in advance to avoid generating wrong data tables; in addition, JMP improved JSL Log The presentation and structure make it easier for users to edit scripts more quickly and easily; or they can use JMP 17 new function workflow builder Complete the formulation of a complete set of analysis processes to achieve automation.
From data cleaning to analytical automation, semiconductor CP Data as an example
We use semiconductor CP As an illustration, after the wafer production is completed, the test machine will be used to The probe card is connected to the test pad on the wafer for electrical testing to confirm the electrical testing performance of the wafer. If there is a die that performs beyond the standard, it will be marked so that the subsequent packaging and testing process will not be performed to avoid the production of defective products. .
JMP can quickly analyze the data thrown out by the test machine to determine which wafers have higher defects or test items with poor electrical test performance, helping engineers make quick preliminary judgments. JMP supports the import of multiple data formats (Figure 1) and has many ways to import data.
Figure 1, JMP supports imported data formats
When you use open under File to open a text file (.txt, .csv) or excel format (.csv), you can choose to open it in preview mode, and JMP will guide to the import wizard platform to help users according to their needs. To import the required content, we first take the specifications of grabbing CP data as an example. If we want the first column to be the header of the data table, we can check File contains column names on line on the import wizard platform, and then use Fill in the box with 1, which means the data is in the first column.
We can also select the range of data included. For example, the data specification only includes the third and fourth columns of the original data. Then we can put 3 in the box after Data starts on line and select lines from start under subset. of file, fill in the box on the left with 2, which means that the data starts from the third column and continues for two columns, that is, the third and fourth columns containing the original data. (Figure II)
Figure II, use open down import wizard Import data specification content according to needs
Then we use the same concept to convert CP Import test data, CP The data starts from the twelfth column of the original data, using open turn on CP After the path, in Check File contains column names on line on the import wizard, and fill in 12 in the subsequent box. Because all data below 12 columns need to be selected, just keep the original subset default. (Picture 3)
Figure 3, use open down import wizard Import according to needs CP Test data content
Next we need to organize and clean the data we imported. Using JMP When doing data analysis, we must first organize the data table so that each column of the data table contains various information about each sample point, and each row represents a parameter, result, or some related information. ( Figure 4 )
Figure 4, JMP Data table analysis data placement format
We can find that the original data does not conform to JMP Analysis format ( Figure 5 ) , we hope to organize it into the data type in Figure 4. Got it JMP of Table With the help of the function list, such organization becomes very convenient. Open JMP above the data table Table Feature List, Discover JMP Provides many tools for organizing data tables, including Summary( Summary ) , Subset( Extract subgroups ) , Sort( sort ) , Stack( stack ) , Split( Split ) , Transpose( Transpose ) , Join( intersection union ) , Update( renew ),concatenate( bond ) Etc., each functional platform includes a preview platform to help users understand what kind of data table will be generated by the current adjustment, avoid making wrong data tables, and save time in purifying data tables.
Figure 5, CP Data import JMP initial information table
For this example, we first divide the first to fourth Sites into Data is stacked and retained Parameter data of ( Figure 6 ) , check stack under the platform Auto Refresh The preview platform can be opened.
Figure 6, Stack Platforms and preview windows
Then the stacked Data Data based on Parameter Split and keep Site Variables, check the same stack under the platform Auto Refresh Open preview platform ( Figure 7 ) .
Figure 7, Split Platforms and preview windows
After completing the above information table, we found that CP positional parameters X and Y , originally merged into one parameter ( Figure 8 ) , we can select this parameter and use Col under the function list Utlities >Text to columns Do the splitting of parameter content ( Figure 9 ) .
Figure 8, original data sheet X&Y parameter
Figure 9, use Co>Utlities >Text to columns Do parameter splitting
At this point, we have completed the sorting and purification of the data.
use JMP Automate your analysis: JSL Action Recorder , JMP17 Workflow Builder
(1) JSL Action Recorder
In order to allow work partners and project collaborators to more quickly understand the information brought by the data, the company may have some fixed output analysis reports. JMP It has many different demand-oriented analysis platforms, and its diverse and compatible statistical analysis tools are suitable for users with various statistical analysis needs. use JMP of JSL , the required platform can be customized according to the user's needs, or you can use JSL Edit the overall analysis process, including the previously mentioned data collection, sorting, cleaning, report production and output, to achieve the goal of report automation.
As mentioned earlier, JMP I hope it will be closer to the user's usage pattern. Considering that most users have little experience in software editing, JMP Continuous improvement and use JSL mode to help users get started more easily JSL edit. JMP Improve Log The architecture has changed from the original scattered software language records to a modular block form. JMP call it ActionRecorder( Figure 10 ) . With this drawer type log architecture, users can find what they need more quickly JSL Language blocks, acceleration JSL Collection, editing and integration.
Figure 9, JMP Modular block form Log , Action recorder
(2) JMP 17 Workflow Builder
Based on this concept, JMP Also provided Workflow builder as JMP A powerful assistant for workflow planning ( Figure 11 ) . Compared to Action Recorder , Workflow builder Provides a more visual and physical process arrangement interface , such an interface makes it easier for the general public to do it more intuitively JMP The process arrangement of each action includes the addition, deletion and adjustment of process items. The block program structure also facilitates users to understand where problems occur and correct them.
Figure 10, JMP Workflow Builder
Next, demonstrate how to operate the workflow builder . when want to construct workflow can be opened when File>New>Workflow , turn on Workflow Builder, Press the record button in the upper left corner ( red circle ) , start recording the action. At this time, a white square will appear on the button in the middle of the red circle. Then the subsequent operations will be recorded as work items one by one until the record button is pressed again to return to the red circle pattern. ( Figure 12 ) .
Figure 12, Workflow Builder Record keystrokes
You can also perform the desired action first, and the action will be recorded in the JMP Log History below on, this record is also recorded simultaneously log window and select JMP Log History In the action you want to integrate, press the up button on the right to integrate the action into Workflow step( Figure 13 ) .
Figure 13, Select the action item you want to move and press the Move Up key to join Workflow step list
For Workflow step For action items, you can select Move Up on the right , Move down or delete button adjustment ( Figure 14 ) .
Figure 14, Select the action item you want to move and press the move key or delete key to edit Workflow step list
If you want to modify the JSL of the edit action item , or to make notes on the action, you can open the step settings , edit and modify action items ( Figure 15 ) .
Figure 15, turn on Step Settings Edit action items
Press Step next to Record The execution button can reply to the action item, perform the full action, or move forward or backward step by step. When an action item encounters an error, an error mark will appear on the right side of the action item; if the action is executed successfully, a check mark will appear. ( Figure 16 ) .
Figure 16, Use the markers on the right to understand the steps where the problem occurs.
After completing the work item arrangement, you can save the entire schedule. Press Workflow Builder under the red triangle create workflow package , you can save the entire process as .jmpflow files and share them directly with other users ( Figure 17 ) .
Figure 17, use Create Workflow Package Save schedule
JMP Based on the user's usage habits, continuous improvements and modifications are made to meet the user's needs, hoping that most users can complete the analysis report they want at their fingertips.
Using Workflow Builder and JMP Table Editing tool, users can create regular work and reports into JMP schedule or JSL , quickly complete the report, save the user's valuable time, improve work efficiency, and apply JMP 17 try out Try it now!
Recommended reading:
