CHEM | Data Quality Analytics

DATA QUALITY ANALYTICS OVERVIEWBEFORE YOU BEGINUSING THE DATA QUALITY ANALYTICS WINDOWEXPORTING THE DATA QUALITY ANALYTICS REPORTRESOLVING DATA DISCREPANCIESMOVING AN SDS TO THE IGNORED QUEUERESOLVING DATA DISCREPANCIES FOR SDS IN THE IGNORED QUEUEDATA QUALITY ANALYTICS OVERVIEWData Quality Analytics enables Administrators to: View critical data that could not be captured during SDS processingApply overrides to fields to resolve discrepanciesExport an accounting of your data discrepancies to a spreadsheet. BEFORE YOU BEGINReview the following to determine the steps you need to perform: Determine if you need to create Administrators to perform data discrepancy reviews. See Creating an Administrator. Create the Data Quality Analytics Reviewer role. See Creating an Administrator Role. To ensure that there is review coverage for your organization, we recommend that, at the minimum, two Administrators be assigned as reviewers: one reviewer for the facility to which they are assigned, and one reviewer positioned at the organization’s highest hierarchical level, which allows them to perform data discrepancy reviews for any facility within their organization. Add features to the reviewer role to enable their access to the necessary feature module. See Edit an Administrator Role. Configure data quality analytics settings. Settings configuration is performed at SETTINGS > Chemical / SDS Settings > Collection Management, and then select the Data Quality Analytics Options. See Configuring Data Quality Analytics Options for more information. USING THE DATA QUALITY ANALYTICS WINDOWAfter navigating to COLLECTION MANAGEMENT > Data Quality Analytics in the Chemical Management system, you arrive at the Data Quality Analytics opening window, shown below.  The following table provides descriptions for the elements shown in the Data Quality Analytics interface, shown above. Note: the above image is from an older UI; the updated UI will have minor differences in the look, but the function is still the same. REFERENCE NUMBERDESCRIPTION1The default setting, PENDING is where you can view the list of SDSs containing data discrepancies. 2IGNORED is where you can view the list of SDSs that have been tagged to review and resolve data discrepancies at a later time. 3Click to export data discrepancy report to your device. 4Click to clear Location Assignment selections and/or Search input from fields. 5Click to reveal additional Search Filters. Filters include FIELD NAME, DATA VARIANCE TYPE, and LANGUAGE. 6Click to select all documents in bulk. Used in conjunction with the Ignore Selected hyperlink. 7Click Ignore Selected after selecting either the bulk check box or individual check boxes to move SDSs to the IGNORED queue to review and resolve data at a later time. 8Choose individual boxes. Used in conjunction with the Ignore Selected hyperlink.  9Click View Document to review this row’s SDS. 10Click to Ignore this row’s SDS so you can review and resolve its data at a later time. 11Click View Details to open this SDS’s Data Quality Analytics Details page, which is where you can view and resolve its data differences. EXPORTING THE DATA QUALITY ANALYTICS REPORTYou can easily export a list of your system’s current data discrepancies by performing the following steps. In the Chemical Management System, select COLLECTION MANAGEMENT > Data Quality Analytics. In the Data Quality Analytics window, click EXPORT TO EXCEL. Provide a File name, and click Save. The report name saves as directed and downloads to your device. RESOLVING DATA DISCREPANCIESNavigate to COLLECTION MANAGEMENT > Data Quality Analytics. Ensure the PENDING tab is selected. The list of pending data discrepancy reviews display in the lower portion of the window. After finding the SDS, in its row click the View Details icon to open the Data Quality Analytics Details page. The top portion of this page is shown below, with the Summary section bordered in red. This section encapsulates the sections of the SDS which contain data discrepancies so you can quickly locate the fields that you need to resolve.  Note: The following colored Flag icons may also accompany fields. Red flags indicate data capture attributes and display when field information was not captured during SDS processing. Blue flags indicate that an override has been applied to that field. Locate the section(s) with discrepancies in the page that are listed in the Summary section. These sections include flags which indicate either a data discrepancy or field override. When you find the category you need to edit, click its pencil icon to open its editing dialog box. Enter or select information in the dialog box. You must provide input for all fields accompanied with an asterisk (*). An example is shown in the following image.  When you finish, click SAVE. Note:  The EPCRA Hazard Category section in the Data Quality Analytics Details page may be flagged for missing information. If you determine that it is valid to keep these selections un-checked, click the Mark Chemical as Non-Hazardous toggle to dismiss this discrepancy. When you finish, scroll down the Data Quality Analytics Details page and click DONE. MOVING AN SDS TO THE IGNORED QUEUEIf you want to review one or more SDSs in the future, you can move them from the PENDING queue to the IGNORED queue. Navigate to COLLECTION MANAGEMENT > Data Quality Analytics in the Chemical Management System. Ensure the PENDING tab is selected. The list of pending data reviews display in the lower portion of the window. After locating the SDS, you can move the SDS(s) to the IGNORED queue in one of the following ways: If you are only moving one SDS, find that SDS in the list and in it’s row, click its Ignore icon to move the SDS. If you are moving several but not all SDS’s, click their individual check boxes, and then click the Ignore Selected hyperlink to move the SDSs. To move all, click the top-most check box to select all boxes, and then click the Ignore Selected hyperlink to move all SDSs. RESOLVING DATA DISCREPANCIES FOR SDS IN THE IGNORED QUEUERevisions for ignored SDSs are performed in the SDS’s Material Detail window. Select COLLECTION MANAGEMENT > Data Quality Analytics in the Chemical Management System. Click the IGNORED tab. Find the SDS in the lower portion of the window, and note its DATA ATTRIBUTES category. In the example below, the Specific Gravity is missing data. Click the hyperlink shown beneath the PRODUCT INFO column to open its Data Quality Analytics Detail window. In the window, look for the category that was listed in the DATA ATTRIBUTES column, which you noted in Step 3. Click the Edit Override Settings icon, shown encircled in white in the previous image, to display field editing icons. Find the category that you need to edit, and click its edit icon to display its editing dialog box. Note: The following colored Flag icons may also accompany fields. Red flags indicate data capture attributes and display when field information was not captured during SDS processing. Blue flags indicate that an override has been applied to that field. Select or enter data information in the dialog box. You must provide input for all fields accompanied with an asterisk (*). When you finish, click SAVE. The SDS no longer displays in the IGNORED queue.