Skip to Content
0

Data Quality Scorecards for Metapedia Attributes (Standard & Custom)

Jun 13, 2017 at 09:18 AM

31

avatar image

All,

We are looking for ways to build data quality scorecards in Data Insight to measure the completeness of the data within Metapedia. This would include measuring completeness for both standard attributes and custom attributes for the metapedia terms and categories.

To date we have leveraged both the mmb_business_term and mmb_business_category to measure the completeness of the standard fields. This is the easy one. The challenge comes in measuring the completeness of the custom attributes.

Also, we have explored using the mmb_custom_field and mmb_custom_field_value tables, but two things 1) the mmb_custom_field_value only inserts data into the table when a value has been selected for that custom attribute making measuring completeness of custom attributes overall difficult and 2)to ease the reporting burden, this table would need to be "cross tab-ed" so that the custom attributes are the columns to facilitate ease of reporting (I understand why this table structure is being used from an application perspective, but it makes reporting a bit daunting).

Does anyone have an easy way to report on the completeness of custom attributes in metapedia for both categories and terms? Are there any views built already to do this? If not, I'd suggest that this be included as an enhancement to future releases.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers