Data Quality Workflow

About the Data Quality Workflow

The Data Quality workflow contains dashboards and widgets that provide information on the data completeness in Equipment, Functional Location, and Work History records. Using this information, you can identify the missing data.

In addition, you can also evaluate the hierarchy distribution across various sites. You can also access the APM Connect EAM jobs and Data Loader jobs.

The Data Quality main dashboard contains the following widgets:
  • OVERVIEW: Contains the number of Sites, Process Units, Equipment, Functional Locations, and Work Histories.
    Note: Process Units are Functional Location records for which the Is a Unit check box is selected.
  • COUNT OF ORPHAN EQUIPMENT: Contains the total number of Equipment records that do not have a parent. You can select the link to access the list of Equipment.
  • WORK HISTORY TOTAL COST: Contains the cost of each category in the Work History records (excluding cancelled ones).
  • ORPHAN WORK HISTORY: Contains the total number of work histories that are not linked to an Equipment or a Functional Location. You can select the link to access the list of work histories.
  • COUNT OF GLOBAL EQUIPMENT AND FLOC: Contains the number of Equipment and Functional Locations that are not linked to a Site. You can select each link to access the list of Equipment or Functional Locations.
  • DASHBOARD HYPERLINKS: Contains links to the other dashboards in the Data Quality workflow:
For each widget, you can select the Open in New Tab () button to open the Results workspace, which provides the results-only view of the corresponding query on a new page. In this workspace, select the Open in Query Editor () button to access the full, modifiable view of the query on a new page. To export the query to a file, use the Export to a File () button.

Access the Data Quality Main Dashboard

Before You Begin

Ensure that the asset context in APM is set to Home. To do so, in the top navigation bar, select , and then select Home in the Hierarchy pane.

Procedure

  1. In the Applications menu, navigate to the TOOLS section.
  2. Select Catalog.
  3. Select Home > Public > Data Quality Dashboard > Dashboards.
    The corresponding Catalog items appear in the workspace for the selected folder.
  4. Select Data Quality Main Dashboard.
    The Data Quality Main Dashboard page appears, displaying the widgets.

About the Equipment Data Completeness Dashboard

The Equipment Data Completeness dashboard contains the following widgets:
  • EQUIPMENT DATA COMPLETENESS: Contains a heatmap graph that plots the percentage completeness of Equipment data (such as Equipment ID and Manufacturer) in Equipment records based on the site, criticality, and Asset Hierarchy. You can select a cell to access the list of records in the category.
  • EQUIPMENT DATA TOTAL FOR ALL SITES: Contains a bar graph that plots the percentage completion of each type of Equipment data for all the sites. For example, if the Manufacturer bar shows 60%, it indicates that only 60% of the Equipment records in all the sites contain the Manufacturer data.
  • EQUIPMENT COMPLETENESS: Contains the count and percentage of completion of each type of Equipment data for each site and criticality. If you select a percentage, the list of Equipment records for which the corresponding data is not available appears.
  • EAM EQUIPMENT TAXONOMY NOT LOADED INTO APM TAXONOMY: Contains the count of Equipment records for which the Taxonomy Type (that is, APM Taxonomy) and/or Object Type (that is, EAM Taxonomy) is blank. If you select the link in the COUNT column, the list of Equipment records for which the data is missing appears.
Note: The percentage values are rounded off. Therefore, there can be a difference in the count value with respect to the percentage. This difference can be bigger with bigger numbers.

About the Functional Location Data Completeness Dashboard

The Functional Location Data Completeness dashboard contains the following widgets:
  • FUNCTIONAL LOCATION DATA COMPLETENESS: Contains a heatmap graph that plots the percentage completeness of Functional Location data (such as Criticality ID and Maintenance Plant) in Functional Location records based on the site, criticality, and Asset Hierarchy. You can select a cell to access the list of records in the category.
  • FUNCTIONAL LOCATION DATA TOTAL FOR ALL SITES: Contains a bar graph that plots the percentage completion of each type of Functional Location data for all the sites. For example, if the Criticality bar shows 60%, it indicates that only 60% of the Functional Location records in all the sites contain the Criticality data.
  • FUNCTIONAL LOCATION COMPLETENESS: Contains the count and percentage of completion of each type of Functional Location data for each site and criticality. If you select a percentage, the list of Functional Location records for which the corresponding data is not available appears.
  • EAM FUNCTIONAL LOCATION TAXONOMY NOT LOADED INTO APM TAXONOMY: Contains the count of Functional Location records for which the Taxonomy Type (that is, APM Taxonomy) and/or Object Type (that is, EAM Taxonomy) is blank. If you select the link in the COUNT column, the list of Functional Location records for which the data is missing appears.
Note: The percentage values are rounded off. Therefore, there can be a difference in the count value with respect to the percentage. This difference can be bigger with bigger numbers.

About The Work History Data Completeness Dashboard

The Work History Data Completeness dashboard contains the following widgets:
  • WORK HISTORY DATA: Contains a heatmap graph that plots the percentage completeness of Work History data (such as Event Type and Priority) in Work History records based on the site and Asset Hierarchy. You can select a cell to access the list of records in the category.
  • WORK HISTORY DATES - SUMMARY: Contains a bar graph that plots the percentage completion of the Event Start Date, Maintenance Start Date, and Maintenance Completion Date. For example, if the Event Start Date bar shows 60%, it indicates that only 60% of the Work History records in all the sites contain the Event Start Date.
  • WORK HISTORY COMPLETENESS: Contains the count and percentage of completion of Work History data (such as Maintenance Cost and Priority). If you select a percentage, the list of Work History records for which the corresponding data is not available appears.
  • WORK HISTORY TOTAL COST: Contains the total cost of each category in the Work History records for the selected site (for example, Actual Labor Cost and Actual Material Cost).
Note: The percentage values are rounded off. Therefore, there can be a difference in the count value with respect to the percentage. This difference can be bigger with bigger numbers.

About the Hierarchy Evaluation Dashboard

The Hierarchy Evaluation dashboard contains the following widgets:
  • Distribution of Hierarchy (graph): Contains a bar graph that plots the distribution of percentage of Equipment, Work History records, and Work History cost per hierarchy level for each site.
  • Distribution of Hierarchy (table): Contains a list of the distribution of the count and percentage of Equipment, Work History records, and Work History cost per hierarchy level for each site.
Note: The percentage values are rounded off. Therefore, there can be a difference in the count value with respect to the percentage. This difference can be bigger with bigger numbers.

About APM Connect EAM Jobs

When you select APM Connect EAM Jobs, the Job Monitoring Dashboard appears, displaying the EAM jobs that are in progress, successful, failed, and cancelled.

About APM Connect Data Loaders

When you select APM Connect Data Loaders, the Data Loaders page appears, displaying the Data Loader jobs, along with their status and other details.