1. Navigate to the SageMaker Canvas console.

2. In the Get Started section, choose Open Canvas.

• Verify that you are in the US East (N. Virginia) Region.
   

The SageMaker Canvas Creating application screen will be displayed. The application will take a few minutes to load.

Note: If this is your first time using SageMaker in us-east-1 Region, SageMaker Canvas creates an Amazon S3 bucket with a name that uses the following pattern: sagemaker-<your-Region>-<your-account-id>.

3. Download the following datasets and save them to your local computer.

• Shipping Logs
• Product Descriptions

1. Navigate back to the Amazon SageMaker Canvas application to import the previously downloaded datasets into SageMaker Canvas.

2. In the left-hand section, choose Data Wrangler, and then choose Create data flow.

3. In the Create data flow pop up, for Data flow name, enter product_descriptions, and select Create.

4. Choose Import data, and select Tabular.

5. On the Import data page, choose Select files from your computer.

6. Upload the product_descriptions.csv dataset you previously downloaded on your local machine, and choose Preview data.
 

7. A preview of the data will display, choose Import data.

8. Complete Step 2 through Step 7 again to upload the shipping_logs dataset bullet point.

• In the Create data flow pop up, for Data flow name, enter shipping_logs, and select Create.

9. In the left-hand navigation, choose Data Wrangler, and select the Datasets tab. Then, choose Join data.

10. On the Join Datasets page, drag the canvas-sample-product-descriptions.cvs and canvas-sample-shipping-logs.csv from the left panel onto the right pane. Select the join icon between the two datasets.

11. A pop-up showing details about the join will appear. Make sure that the join type is Inner and the joining column is ProductId. Then, choose Save & close, and choose Import data.

12. In the Import data dialog box, enter ConsolidatedShippingData in the Import dataset name field, and choose Import data.

13. On the Data Wrangler page, check the box beside ConsolidatedShippingData. Then, choose Create a data flow.

14. On the Create a data flow dialog box, enter ConsolidatedShiping-Prep, and select Create.

15. On the Data flow page, you will see a preview of the dataset and visualizations for the first 2,000 rows of the data, but before you explore the data analysis, you will complete some initial clean-up.

Note: The chat for data prep requires access to Amazon Bedrock and the Anthropic Claude model within it. If you haven’t provisioned this access, use the following steps before proceeding:

16. Navigate to the Amazon Bedrock console, in the left-hand navigation choose Model access.
 

18. On the Manage model access page, select Anthropic. Then, choose Request model access.

19. Choose the Chat for data prep icon.

• Using chat for data prep, you can explore, visualize, and transform your data using natural language.
   

20. In the chat box, type Plot actual vs expected shipping days, and press enter.

• The graph shows there is a close relationship between expected and actual shipping days. In addition to the graph, you will see a message explaining the visualization and even how you can leverage it.
• If you select View code, you will see the code that was used to generate the visualization.
   

21. In the chat box, type Drop ProductID and OrderID, and press enter.

• ProductID and OrderID are primary keys and not expected to contain any valuable information for training a model, you will want to drop them.
   

You will see an explanation in the chat box and the code used to achieve the step, but this time you will also see a preview of how this will impact your dataset.

22. Select Add to steps to include the step in your workflow.
 

23. Select the Analyses tab. In the Create analysis section, select the drop-down, and choose the Data Quality And Insights Report.

24. For Analysis name, enter Initial-Report, for Target Column, select ActualShippingDays, for Problem type, select Regression, and for Data size, select Sampled dataset (20k). Then, choose Create.

• The Features Prediction power graph has a few features that don’t provide useful information for predicting the target, you will want to remove them before training the model.
• The feature providing the second highest Prediction power, OnTimeDelivery, is not information that would be available when predictions are made using the generated model. This is referred to as data leakage and that column will also need to be dropped before training the model.
   

26. To action on these insights, at the top of the page, choose ConsolidatedShippingData-Prep.flow to navigate back to the Data flow page.

27. Select the ellipses icon next to the chat transform step, and choose Add transform.

28. Select Add step.

29. On the Add transform page, scroll down and choose Manage Columns.

• Leave Transform set to Drop column
• For Columns to drop, select OnTimeDelivery, ComputerBrand, ComputerModel, ScreenSize, PackageWeight, and OrderDate
• Confirm the correct columns are selected, then choose Add

1. Choose Create model.

2. In the Export data and create model popup, Name the new dataset ConsolidatedShippingData-Clean, and select Export.

3. Once the export completes, select Create model on the pop-up at the bottom left of the screen.

4. In the Create new model popup, for the Model name, enter ShippingForecast, leave the default selection for Predictive analysis. Then, choose Create.

7. In the Model type section, choose Numeric model type, and choose Save.

1. Choose Quick build.

The build takes approximately 5 minutes to validate and complete. Once completed the page model will move to the Analyze step where you can view the quick training results.

Once completed, the SageMaker Canvas model built using Quick build can predict the number of shipping days within +/-1.693 of the actual valu

• Machine Learning introduces some stochasticity in the process of training models, which can lead to different results to different builds. Therefore, the exact performance in terms of the metrics that you see might be different.

2. On the Overview tab, SageMaker Canvas shows the Column impact or the estimated importance of each input column in predicting the target column. In this example, the ExpectedShippingDays column has the most significant impact on predicting the number of shipping days.

• On the right panel, you can see the direction of impact of a feature as well. For example, the higher the value of ExpectedShippingDays, the more positive its impact on the number of shipping days prediction.
   

• On the Scoring tab, you can see a plot representing best fit regression line for ActualshippingDays. On average, the model prediction has a difference of +/- 1.693 from the actual value of ActualShippingDays.
• The Scoring section for numeric prediction shows a line to indicate the model's predicted value in relation to the data used to make predictions.
• The values of the numeric prediction are often +/- the RMSE (root mean square error) value.
• The value that the model predicts is often within the range of the RMSE. The width of the purple band around the line indicates the RMSE range. The predicted values often fall within the range.
  

• On the Advanced metrics tab you can see more details of the model performance.
  • The various metrics shown on the Advanced metrics tab are R2, mean absolute error (MAE), mean absolute percentage error (MAPE), and root mean square error (RMSE). The Advanced metrics page also shows plots for visual inspection of the model performance. One image shows a graph of the residuals or errors. The horizontal line indicates an error of 0 or a perfect prediction. The blue dots are the errors. Their distance from the horizontal line indicates the magnitude of the errors.
     

• If you choose Error density you can see the distribution of the errors and their spread with respect to MAE and RMSE of the model. An error density with a shape similar to a normal distribution is indicative of good model performance.

1. To start generating predictions, choose the Predict tab.

3. On the Select datasets for prediction page, select the ConsolidatedShippingData-Clean dataset, and choose Generate predictions.

After a few seconds, you will be notified that the prediction is done.

4. Choose View from the message window at the bottom of the page to see a preview of the predictions.

• You can also choose Download to download a CSV file containing the full output. SageMaker Canvas returns a prediction for each row of data.
• In this tutorial, the feature with the highest importance is the ExpectedShippingDays feature. It is also presented beside the predictions for a visual comparison.
   

5. On the Predict page, you can generate predictions for a single sample by selecting Single prediction.

• SageMaker Canvas presents an interface in which you can manually enter values for each of the input variables used in the model. This type of analysis is ideal for what-if scenarios where you want to know how the prediction changes when one or more variables increase or decrease in value.
   

6. After the model building process, SageMaker Canvas uploads all artifacts including the trained model saved as a pickle file, metrics, datasets, and predictions into the S3 bucket that was SageMaker Canvas previously created for you (sagemaker-<your-region>-<your-account-id>) under a location named Canvas/1-business-analyst. You can inspect the contents and use them as necessary for further development.

1. Navigate to the S3 console and choose Buckets. Navigate to the sagemaker-<your-Region>-<your-account-id> bucket and select the radio button, and choose Empty.

3. Navigate back to the sagemaker-<your-Region>-<your-account-id> bucket and select the radio button, and choose Delete.

4 In the Delete bucket section, confirm by entering the bucket name in the text field, and choose Delete bucket.

5. On the SageMaker Canvas main page, choose My Models. For the ShippingForecast model, choose the vertical ellipsis, and select Delete.

6. In the pop up, select Delete to confirm that you want to delete the model.

7. In the left-hand navigation, choose on Log out to end your Canvas session.

Note: If you used an existing SageMaker Studio domain you can skip the rest of the steps.

If you ran the CloudFormation template in Step 1 to create a new SageMaker Studio domain, continue with the following steps to delete the domain, user, and the resources created by the CloudFormation template.

8. Navigate to the CloudFormation console, choose CFN-SM-IM-Lambda-catalog, and choose Delete to delete the stack along with the resources it created.