Step 3: Create a Minitab Connect table

Follow these steps to create a new table in Minitab Connect®.

Minitab Connect connects with Minitab Model Ops to receive new prediction data. First, create a Minitab Connect table to contain the new predictions. Then, create a new flow that sends the new predictions from the Model Ops API to the Connect table, then back to Minitab Model Ops.

For this example, we use a data file from a CART® Classification model that has a column for each predictor and an optional prediction ID column.
Note

You define the name of the unique identifier column in the Settings tab. This identifier is used to match the prediction data and the stability data. It is optional for prediction requests but required for stability monitoring.

  1. Sign in to Minitab Connect.
  2. From the Home screen, select the Minitab Connect button to open the Navigation pane. Under Tables, select Add New Table. Or, from the Home screen, select the Add button under Tables.
  3. On the Dataset tab, enter the Name, Folder, and all other required setup properties.
  4. From the Tables gallery, select File/Text/Template.
  5. Under Import Type, select File then browse to the file that contains your prediction data. Preview the data columns to ensure you have the appropriate predictor and ID columns. Use this data ( HeartDiseaseCartPredict.csv ) to create the same Connect data table.
Open the Prep tab to see the structure of the data table.

All predictors from the model have been added. We also added an optional observation ID column, ObservationID, that is optional for predictions, but required for stability monitoring.

Add new fields to the Connect data table

Add new fields for the predicted results and the actual responses which are used to create the drift and stability reports. The stability data set must contain the actual response values and the observation IDs, which was added in the previous section.

  1. Open the Navigation pane. Under Tables, browse to the folder that contains your Connect data table.
  2. Open the table. Select the Base Tool.
  3. Open the Setup tab.
  4. Select Click to add a field, and enter the information for the field in the box that appears underneath for the predicted results and the actual results. Select the expander to access additional settings for the field. For this example, we added this column (ObservationId) when we created the table.
  5. Select Save.
If you use Click to add a field at the top of the form, Connect adds the new fields to the front of the table. If you use Click to add a field at the bottom of the form, Connect adds the fields to the end of the table.

The new fields have been successfully added.