This Spotfire® application we will be describing here is one in a series of Templates for Statistica® Data Entry in Spotfire® and can be downloaded here.
Overview
The application for exploring Spotfire Statistica® Data Entry data with SPC is used to demonstrate how the data entry data can be extracted using Statistica data functions for use in the analysis. With additional supporting data functions that extract available Data Entry Setups, and their associated Label and Characteristic information, users can select one of their Data Entry Setups that contain variable characteristics, define the maximum number of rows to extract, and the data will be retrieved. The variable characteristics are then listed for use in performing SPC analysis.
Business Scenario
Spotfire® Statistica Data Entry is designed and implemented on the concept of collecting data for analytics. Once clients have defined the input items (Labels and Characteristics), Data Entry Setups, and used them to collect data they can start exploring the data by extracting and visualizing it in Spotfire®. When defining characteristics, data entry administrators define the type of quality control analysis for use on the measurement data. This application continues with this use case by including normal distribution testing, individuals and moving range charts, and process capability analysis allowing users to start on their journey to ensure the quality of the defined characteristics.
Benefits and Business Value
The key benefit is to give analysts visibility on the data collected in Spotfire Statistica® Data Entry. In addition to the extracted data, it demonstrates how analysts may design their own Spotfire® analyses using Statistica data functions. The individuals and moving range chart demonstrates how the data from a Statistica data function can be utilized for use in visualizations. The normal distribution testing and process capability demonstrate how the Statistica analysis results can also be viewed directly within Spotfire by placing the analysis results as static images and dynamically generated Table visualizations. Key indices from the normal distribution testing (i.e. Anderson-Darling statistic and p-value) and process capability analysis (i.e. Ppk and Cpk) are also placed into Table visualizations.
Technical Scenario
This application for exploring Spotfire® Statistica Data Entry data with SPC consists of various Statistica workspaces deployed as Spotfire data functions along with visualizations to that provide the start to SPC analysis.
The first data function "Get DES Info" retrieves data tables containing the list of available data entry setups, labels, and characteristics resolved with their full path information. In addition, another table provides the list of data entry setups that is filtered to only include those that have variable characteristics (for use in targeted SPC analysis). Additional lookup tables are optionally available defining the data entry setup to label and data entry setup to characteristic by their ID. The list of data entry setups with variable characteristics is then used in the drop down selection when defining which of the data entry setups to use as input. Please note, the remaining data tables are for information purposes only (used in other use cases common for data entry setup configuration).
The second data function "DES Data" uses as input the full path to the data entry setup and the maximum number of rows. It will dynamically create the SQL to extract the data from the Statistica configuration database, edit the SQL to sort the rows in descending order by Statistica sample ID, limit the extraction to the last N rows, resort the data back into ascending order, identify the variable characteristics with their reasonable limits or min\max values for default specification values (lower/upper boundary and midpoint), and output 2 data tables; one with the resulting data and the other with the list of variable characteristics with boundaries.
The third data function "Normality Tests" uses as input the data entry setup data and the input selected variable characteristic name. It uses the normality tests analysis node to generate the results transferring the normality test results data table. All of the Statistica analysis results are placed into the Normality Tests page and the normality test results data table is placed into the Normality Tests Selection page.
The fourth data function "QC Analysis" uses as input the data entry setup data and the input selected variable characteristic name. It uses the Spotfire SPC Charts node to perform the QC analysis. This node is specially designed to perform QC analysis and only generate data table results to support higher performance when only the data table results are needed for creating visualizations (no Statistica graphs or reporting document results). The resulting data tables are then used to render the histograms and scatter plots representing the individuals and moving range charts along with the alarm table.
The fifth data function "Process Capability" uses as input the data entry setup data and the input selected variable characteristic name. It uses the process capability analysis node to generate the results and uses the Get Result Spreadsheet node to retrieve the CP and PP result data tables to make a single process capability results table. All of the Statistica analysis results are placed into the Process Capability page and the process capability results data table is placed into the Process Capability Selection page.
In the Spotfire® dashboard, as the user extracts the data entry setup data, it will select the first variable characteristic as input for the analysis and run the analyses. As the user changes the input characteristic from the drop down selection (or when extracting the DES data), it will also trigger the analyses. Note, all of the analyses are run (normality test, QC analysis, and process capability) and the visualization of the Statistica results will be shown when completed.
Data Function Diagrams
Get DES Info
DES Data
Normality Tests
QC Analysis
Process Capability
Installation
An installation guide is provided as part of the release on this Exchange page.
Recommended Comments
There are no comments to display.