| PI | Data Object / Epic | Entity | Completeness | Consistency | Uniqueness | Timeliness |
Q2 | GBU | V_DIM_gbu | ||||
| V_DIM_group_of_activity | ||||||
| V_DIM_activity1 | ||||||
| Exchange Rate | V_DIM_exchange_rate | |||||
Customer | V_DIM_customer_corporate_group | |||||
| V_DIM_customer_segmentation | ||||||
| V_DIM_customer | ||||||
Product/Material | V_DIM_material | |||||
| V_DIM_package_type | ||||||
| V_DIM_product_hierarchy | ||||||
| V_DIM_product_line | ||||||
| V_DIM_material_group | ||||||
| V_DIM_material_type | ||||||
Q3 | Markets | V_DIM_gbr_market | ||||
| V_DIM_gbr_segment | ||||||
| V_DIM_gbr_application | ||||||
| V_DIM_gbr_enduse | ||||||
Testing script:
Testing output file:
| Data Object | Attribute | Table in Lake | Attribute in Lake | RAG | Match Ratio | Comments | Actions |
| GBU | GBU | V_DIM_gbu | GBU_Lake | OK | 100.00% | > Transformation Required. Requires concatenation of fields | > Transformation requirement to be discussed |
| Product/Material | Material_Name | V_DIM_material | material_name | DQ | 97.26% | > 61 out the 62 Product Names have Product Code in the Sample > When matching to the lake by Product Code, 61 are found with potential DQ Issues > The one not found is 209081 / AUGEO® CRYSTAL DRUM 210 KG | > Fix Data Quality Issues with Registered Mark > Find the remaining products not containing Registered Mark > Default logic implementation |
| Product/Material | Material_Code | V_DIM_material | material_id | DQ | 99.72% | >The Material_Names not matched contain vales that seem to be default values "OTHER INDUSTRIAL SERVICES", "NONE", "OTHER PASS THROUGH ADMINISTRATION","WATER", "ELECTRICITY", "GAZ NON RAW MATERIAL", "AUGEO® CRYSTAL DRUM 210 KG" | > Product Codes to be found at the source > Default logic implementation |
| Customer | Ship_To_Name | V_DIM_customer | customer_medium_name | DQ | 98.68% | > All except 1 of the unmatched have Ship_To_Code > At least some not matching names due DQ Issues ("ACT CHEMICAL CO., LTD" Vs. "ACT CHEMICAL CO.. LTD") > Unmatched: WP1_400/NOT ASSIGNED | > NA > Default logic implementation |
| Customer | Ship_To_Code | V_DIM_customer | customer_id | OK | 99.86% | > 4 codes not found, 1 is set as NONE | > Ayoub to check the source of the codes to see where they coming from > Default logic implementation |
| Customer | Sold_To_Name | V_DIM_customer | customer_medium_name | DQ | 98.88% | > All except 1 have code > At least some not matching due DQ Issues in the names > Unmatched: WP1_400/NOT ASSIGNED | > NA - Attributed to DQ Issues > Default logic to be applied |
| Customer | Sold_To_Code | V_DIM_customer | customer_id | OK | 99.86% | > 2 codes not found, 1 is set as NONE | > Ayoub to check the source of the codes > Default logic to be applied |
| Customer | Sold_To_Group | V_DIM_customer | customer_corporate_group_name | DQ | 97.78% | > All except 1 have code > At least some not matching due DQ Issues in the names | > Several customer ids can be found under the same Sold_To_Group, which is a rolled-up customer level. So it should not be retrieved from customer id. Additionally, the Sold To Group Id is not available in the transparency dashboard. > Discussion needed to see if we need to take the ID from Salesforce, including Frank, Naveen, Ayoub... > Analysis is required to see if the dashboard has everything that is in CRM |
| GBU | Group_of_Activity | V_DIM_group_of_activity | Group of Activity Lake | OK | 87.50% | > Only unmatched value is "NOT ASSIGNED (#)" > Transformation Required. | > Default Logic to be applied > Transformation requirement to be discussed |
| Region | Country_Ship_To | V_DIM_country | Country Ship To Lake | OK | 98.86% | > Only unmatched value is "NONE" > Transformation Required. | > Default Logic to be applied > Transformation requirement to be discussed |
| Region | Country_Sold_To | V_DIM_country | Country Sold To Lake | OK | 98.80% | > Only unmatched value is "NONE" > Transformation Required. | > Default Logic to be applied > Transformation requirement to be discussed |
| Region | GBU_Region | V_DIM_geo_zone | GBU Region Lake | OK | 83.33% | > Only unmatched value is "NONE" > Transformation Required. | > Default Logic to be applied > Transformation requirement to be discussed |
| Markets | End_Use | V_DIM_gbr_enduse | gbr_enduse_name | OK | 98.61% | > Only unmatched value is "NONE" | > Default Logic to be applied |
| Region | GBU_Zone_H1 | V_DIM_mini_zone | GBU Zone H1 Lake | DQ | 50.00% | > 3 unmatched values "CS/# (#)", "EUROPE (EU)", "NONE" > Transformation Required. | > Transformation requirement to be discussed > Europe is the one real gap, needs to be added. All the others are Not Assigned > Default logic to be applied |
| Markets | Market | V_DIM_gbr_market | gbr_market_name | OK | 81.82% | > 2 unmatched values "NOT ASSIGNED", "NONE" | > Default logic to be applied |
| Customer | GBU_Customer_Segment | V_DIM_customer_segmentation | GBU Customer Segment Lake | OK | 60.00% | > 4 unmatched values "NOT ASSIGNED", "NONE", "NOT YET ASSIGNED", "NOT VALID" > Transformation Required. | > Transformation requirement to be discussed > Default logic to be applied |
| Customer | Group_Customer_Segment | V_DIM_customer_segmentation | Group Customer Segment Lake | OK | 60.00% | > 4 unmatched values "NOT ASSIGNED", "NONE", "NOT YET ASSIGNED", "NOT VALID" > Transformation Required. | > Transformation requirement to be discussed > Default logic to be applied |
| Product/Material | Product_Name | V_DIM_material | commercial_material_group_name | DQ | 15.33% | NA | > Matching logic based on GBU needs to be applied (this is for Novecare) > Default logic to be applied |
| Product/Material | Product_Name | V_DIM_material | material_name | DQ | 84.73% | > All except 1 have code > At least some not matching due DQ Issues in the names | > Product Name should be matched to the Material Group Name, which is higher level of the material name. These two need to be separated > Pau to investigate Material Group Name --> Only one value matched (OFFICE SVCS), non of the others > Default logic to be applied |
| Product/Material | Product_Code | V_DIM_material | commercial_material_group_id | OK | 99.94% | > The only unmatched is a "NONE" value > Transformation required to remove the zeros in front of the number |
|