Load Utilities Health Scores via Notebook

Maximo Predict comes with notebook templates to assist in streamlining data uploads of the industry standard health score for utilities assets into Maximo Health. This notebook will Create a health scoring group and the associated health, risk, criticality, effective age, end of life, duval triangle and the history of combustible gases scores. These instructions will be based off using the '1_Create-HPU-ScoreGroups.ipynb' file with the Substation Transformer Health and Predict for Utilities Demo Assets.

In this exercise you will use Watson Studio, Manage and Predict to:

1. Upload the and Run the HPU Health Score Group notebook using a template to upload new Asset and Location Data to Maximo Manage.
2. Confirm Scoring groups have been created and scores have been calculated
3. Handle Errors that may come up in the process

This notebook can only be run once per environment per site with the same set of assets.

Pre-requisites

• Review Predict documentation for the list of available models.
• Ensure your MAS Predict environment is running and you have access. Try your server URL that might look something like: https://main.predict.ivt11rel87.ivt.suite.myhost.com/ibm/pmi/service/rest/system/info
• Ensure you have Access to Asset data files for the Health and Predict Utilities Demo Data
• Complete the Load Data into Manage lab for the Utilities data.
• Have the following information from the previous lab: MX_BASE_URL, API_KEY, SITE_ID and ORG_ID

Upload files and run the Data Loader Notebook

Load Data into Manage lab to your project. Use the steps from the previous exercise Add Notebook From File to a Watson Studio Project.

Select the 1_Create-HPU-ScoreGroups.ipynb notebook template.

Click on the pencil icon next to your notebook to open it in edit mode.

If the notebook fails to start, restart it. Click on the i icon , Environment tab, Running status dropdown select box and choose Restart

1. Run the first cell to import packages

2. Add the MX_BASE_URL and API_KEY from the previous lab to cell 2

3. Update the site id value to your SITE_ID and the prefix value to your org id ORG_ID in the second cell

4. Uncomment the asset class you will be uploading. In this lab we will be focusing on only Substation Transformer, so the first ASSET_CLASS list containing only one item is uncommented. If we were uploading all demo asset classes available in the github, uncomment the second section. If you have additional assets, use the third list and uncomment as needed.

5. Here are two ways to comment out a cell: add a # to the beginning of each line or add ''' to the beginning and end of a section of code for it to be ignored when run

1. Run the next cell to define the API call for Maximo

2. Run the next 3 cells to define function for creating the following:

   1. The query that will be used to build the health scores

   2. Get the scores list and activate the scores

   3. Create the asset group, create scores for the asset group and clean up

3. Run the next cell to delete any existing asset score groups for your data. If none exists, the cell will output None.

1. Run the next cell to create the query for the Asset Scoring Group. This query will be made up of Asset Type and Site ID

2. Run the next cell to create the Asset Scoring Group using the query from the previous cell, Build the scores from the Industry Standard Provided notebooks, and activate the scores.

Confirm Proper Data Upload

The following steps will confirm that the data was uploaded properly

1. Navigate to Maximo Health and Predict for Utilities for the provided environment

2. Go to the Scoring and DGA Settings application within Maximo H&PU

3. Search for your Org or Site and notice that there are two score groups created - One for Assets and One for Locations. Notice the calculation type is Connect group to notebook since the scores are built via notebooks for the specific Asset Classification

4. Click into the Score Groups and notice all the score types created via the Asset Type specific notebook listed in the Group Details section

5. Click Recalculate Scores and allow the scores to calculate

6. Click into any asset and see that the scores have calculated

Congratulations you have seen how to upload Health and Predict for utilities data via a notebook. You have also gained experience using Jupyter Notebooks in Watson Studio!

In the next exercises you will learn how to use the 1_Create-HPU-ScoreGroups.ipynb Notebook template to create health scores for Health and Predict for Utilities assets and associate the asset notebook to that created group.