Creating a Dashboard from Address Cleansing Results using SAP Data Quality Management Microservices

Estimated read time 9 min read

In my last blog post, I introduced our GitHub sample for working with SAP Datasphere and SAP Data Quality Management, microservices. Today we are announcing our new sample to show how you might create a data quality dashboard from your address cleansing and geocoding results. If you are not familiar with our GitHub sample structure, please refer to the previous article first.

 

Dashboard sample using the result from SAP Data Quality Management, microservices for location data

Our sample can be found in the SAP-samples / cloud-dqm-sample-payloads repository.

/ datasphere-dashboard

This sample uses the additional details generated during the address cleansing and geocoding process to create a statistical visualization using SAP Datasphere and SAP Analytics Cloud.

 

Informational Output Fields

SAP Data Quality Management, microservices for location data generates several Informational codes with each API request. These codes indicate how well the address data was matched to the reference data and provide additional information if the best possible results are not achieved. The following output fields are used in this sample, but you can also obtain additional information as described in the documentation such as in Assignment Codes and Information Code and Messages.

 

Address Assignment Information

The output field addr_asmt_info provides the information about the validity of the address. If it is V (Valid) or C (Corrected), it is considered that the address returned is validated to the full depth in the reference data.

Address Validity

addr_asmt_info

Description

Valid

V (Valid)

Address was valid (no changes or only minor changes were made)

Valid

C (Corrected)

Address was corrected

Invalid

I (Invalid)

Address was invalid

Invalid

B (Blank)

Address input was blank

 

Address Assignment Level

The output field addr_asmt_level provides the level that the address matches to the address reference data.

Address Level

addr_asmt_level

Description

Premise

S (Secondary)

Address was validated to the secondary address information such as a floor and unit number

Premise

PR (Primary Range)

Address was validated to the house number

Street

PN (Street)

Address was validated to the street

City

L4 (Locality4)

Address was validated to the fourth level of city

City

L3 (Locality3)

Address was validated to the third level of city

City

L2 (Locality4)

Address was validated to the second level of city

City

L1 (Locality1)

Address was validated to the first level of city

Region

R (Region)

Address was validated to the region

Region

C (Country)

Address was validated to the country

Unassigned

X (Unassigned)

Address was not validated to any level of data

 

Geocode Assignment Level

The output field geo_asmt_level provides the level that the address matches to the geocode reference data.

Geocode Level

geo_asmt_level

Description

Premise

PRE (Primary Range Exact)

Address was geocoded to the exact house location

Premise

PRI (Primary Range Interpolated)

Address was geocoded to the interpolated location based on the house number range

Street

PN (Primary Name)

Address was geocoded to the midpoint of street segment

Postcode

PF (Postcode Full)

Address was geocoded to the center of full postcode area

Postcode

P2P (Postcode2 Partial)

Address was geocoded to the center of partial postcode2 area

Postcode

P1 (Postcode1)

Address was geocoded to the center of postcode1 area

City

L3 (Locality3)

Address was geocoded to the center of third-level city area

City

L2 (Locality2)

Address was geocoded to the center of second-level city area

City

L1 (Locality1)

Address was geocoded to the center of first-level city area

Unassigned

X (Unassigned)

Address was not geocoded to any level of data

 

Information Codes

The output fields addr_info_code and addr_info_code_msg provide the potential reasons why an address was not fully validated to the full depth in the reference data.

Info Code Series

Description

1000’s

Potential problems related to the input country or script

2000’s

Potential problems related to the input city, region, or postcode

3000’s

Potential problems related to the input street, building, house number, or postbox number

4000’s

Potential problems related to the input secondary address information or organization name

5000’s

Miscellaneous scenarios encountered when matching the input address to reference data. Not all of these scenarios are necessarily problems

 

Data Quality Dashboard

In SAP Analytics Cloud, you can create a dashboard to visualize the total number of records for various informational codes received from SAP Data Quality Management microservices for location data. In our example, we used pie and bar chart representations as shown below.

 

We Value Your Feedback!

In this blog post, we showed an example of interpreting the output data generated by SAP Data Quality Management, microservices for location data, creating the data model in SAP Datasphere, and visualizing the data to create a data quality dashboard.

If you like what we did in our sample, we would appreciate your feedback on it. Is there any additional information you would like to get from the service? Do you want to see similar reports from the Data Quality Service UI? If you would like to send us an enhancement request, please use the following channel to contact us.

Enhancement requests to SAP Data Quality Management, microservices for location dataEnhancement requests to SAP DatasphereEnhancement requests to SAP Analytics CloudEnhancement requests to SAP S/4HANA Cloud for MDM 

​ In my last blog post, I introduced our GitHub sample for working with SAP Datasphere and SAP Data Quality Management, microservices. Today we are announcing our new sample to show how you might create a data quality dashboard from your address cleansing and geocoding results. If you are not familiar with our GitHub sample structure, please refer to the previous article first. Dashboard sample using the result from SAP Data Quality Management, microservices for location dataOur sample can be found in the SAP-samples / cloud-dqm-sample-payloads repository./ datasphere-dashboardThis sample uses the additional details generated during the address cleansing and geocoding process to create a statistical visualization using SAP Datasphere and SAP Analytics Cloud. Informational Output FieldsSAP Data Quality Management, microservices for location data generates several Informational codes with each API request. These codes indicate how well the address data was matched to the reference data and provide additional information if the best possible results are not achieved. The following output fields are used in this sample, but you can also obtain additional information as described in the documentation such as in Assignment Codes and Information Code and Messages. Address Assignment InformationThe output field addr_asmt_info provides the information about the validity of the address. If it is V (Valid) or C (Corrected), it is considered that the address returned is validated to the full depth in the reference data.Address Validityaddr_asmt_infoDescriptionValidV (Valid)Address was valid (no changes or only minor changes were made)ValidC (Corrected)Address was correctedInvalidI (Invalid)Address was invalidInvalidB (Blank)Address input was blank Address Assignment LevelThe output field addr_asmt_level provides the level that the address matches to the address reference data.Address Leveladdr_asmt_levelDescriptionPremiseS (Secondary)Address was validated to the secondary address information such as a floor and unit numberPremisePR (Primary Range)Address was validated to the house numberStreetPN (Street)Address was validated to the streetCityL4 (Locality4)Address was validated to the fourth level of cityCityL3 (Locality3)Address was validated to the third level of cityCityL2 (Locality4)Address was validated to the second level of cityCityL1 (Locality1)Address was validated to the first level of cityRegionR (Region)Address was validated to the regionRegionC (Country)Address was validated to the countryUnassignedX (Unassigned)Address was not validated to any level of data Geocode Assignment LevelThe output field geo_asmt_level provides the level that the address matches to the geocode reference data.Geocode Levelgeo_asmt_levelDescriptionPremisePRE (Primary Range Exact)Address was geocoded to the exact house locationPremisePRI (Primary Range Interpolated)Address was geocoded to the interpolated location based on the house number rangeStreetPN (Primary Name)Address was geocoded to the midpoint of street segmentPostcodePF (Postcode Full)Address was geocoded to the center of full postcode areaPostcodeP2P (Postcode2 Partial)Address was geocoded to the center of partial postcode2 areaPostcodeP1 (Postcode1)Address was geocoded to the center of postcode1 areaCityL3 (Locality3)Address was geocoded to the center of third-level city areaCityL2 (Locality2)Address was geocoded to the center of second-level city areaCityL1 (Locality1)Address was geocoded to the center of first-level city areaUnassignedX (Unassigned)Address was not geocoded to any level of data Information CodesThe output fields addr_info_code and addr_info_code_msg provide the potential reasons why an address was not fully validated to the full depth in the reference data.Info Code SeriesDescription1000’sPotential problems related to the input country or script2000’sPotential problems related to the input city, region, or postcode3000’sPotential problems related to the input street, building, house number, or postbox number4000’sPotential problems related to the input secondary address information or organization name5000’sMiscellaneous scenarios encountered when matching the input address to reference data. Not all of these scenarios are necessarily problems Data Quality DashboardIn SAP Analytics Cloud, you can create a dashboard to visualize the total number of records for various informational codes received from SAP Data Quality Management microservices for location data. In our example, we used pie and bar chart representations as shown below. We Value Your Feedback!In this blog post, we showed an example of interpreting the output data generated by SAP Data Quality Management, microservices for location data, creating the data model in SAP Datasphere, and visualizing the data to create a data quality dashboard.If you like what we did in our sample, we would appreciate your feedback on it. Is there any additional information you would like to get from the service? Do you want to see similar reports from the Data Quality Service UI? If you would like to send us an enhancement request, please use the following channel to contact us.Enhancement requests to SAP Data Quality Management, microservices for location dataEnhancement requests to SAP DatasphereEnhancement requests to SAP Analytics CloudEnhancement requests to SAP S/4HANA Cloud for MDM   Read More Technology Blogs by SAP articles 

#SAP

#SAPTechnologyblog

You May Also Like

More From Author