RPubs will retire in June 2027. Your existing documents will stay accessible through December 31, 2031
and Connect Cloud is the recommended home for new publishing. Read the blog post
gravatar

BanKing

Oh_Banking

Recently Published

Validity Issues RCA
The analysis of validity and outliers revealed that the data engineers failed to address invalid entries in the "surname" field of the dataset obtained from Kaggle. This oversight resulted in an increased occurrence of outliers, as the Bayesian and frequency-based methods employed were adversely affected by the dense concentration of erroneous surname data. Consequently, the dataset will be returned to the data owner for correction and remediation of the invalid surname entries. Upon successful rectification, the dataset can be reprocessed to obtain more reliable and accurate results, free from the distortions caused by the outliers stemming from the invalid surname data. The data quality issue and its identified root cause highlight the importance of rigorous data validation and cleansing processes to ensure the integrity and usability of datasets, particularly those sourced from external platforms. momentarily this will end my investigation, for further questions please email me.
The Deeper Discrepancies
The data quality assessment revealed the presence of outliers in the system, indicating potential validity issues that need to be addressed. Upon closer examination, it became evident that these outliers were not merely isolated occurrences but rather indicative of underlying data quality concerns. A thorough investigation into the root causes of these outliers was deemed necessary to ensure the integrity and reliability of the dataset. Outliers can arise from various sources, including data entry errors, system glitches, or even genuine but extreme observations. Distinguishing between valid and invalid outliers is crucial to avoid misguided decision-making or flawed analyses. The data stewards and owners must collaborate to establish clear guidelines and criteria for identifying and handling outliers effectively. Once identified, outliers can be addressed through various techniques, such as data cleansing, imputation, or removal, depending on their nature and the specific requirements of the analysis. Robust statistical methods may also be employed to mitigate the impact of outliers on analytical models and ensure accurate insights are derived from the data. Addressing validity issues and outliers is essential to maintain the overall quality and trustworthiness of the dataset, enabling stakeholders to make informed decisions based on reliable and accurate information, Next Question is; "what are those?
DQ Dimensions for Validity
The summary statistics for the credit score data provide valuable insights into the distribution of scores within the dataset. Key observations are as follows: Symmetry: The mean credit score (650.5) and median credit score (652.0) are very close in value, indicating an approximately symmetric or bell-shaped distribution. This symmetry suggests a lack of extreme skewness, with credit scores evenly distributed across the range rather than heavily skewed towards low or high values. Range: The credit scores range from 350 to 850, covering almost the entire possible range for credit scores (typically 300 to 850). This wide range demonstrates that the dataset includes a diverse representation of credit scores, from poor to excellent. Spread: The interquartile range (IQR) of 134 indicates a moderate spread in the middle 50% of the data. While the central portion of credit scores is relatively concentrated, there are still substantial variations within this range. Overall Distribution: Based on the summary statistics, the distribution of credit scores appears to be proportional and balanced, without extreme fluctuations or skewness. This proportional representation of credit scores across the range suggests that the dataset is representative of the population being studied. In summary, the symmetric shape, wide range, and moderate spread of the credit score data indicate a well-balanced and diverse distribution. This balanced representation enhances the validity and reliability of any analyses or conclusions drawn from this dataset.
DQ Dimension; Duplicate and Uniqueness checking
The Kaggle data engineering team meticulously prepared and cleaned the dataset, addressing missing values, outliers, and other anomalies. Their deduplication efforts yielded minimal discrepancies, ensuring data integrity. Leveraging this curated dataset, they extracted valuable inferential insights using statistical methods. Their commitment to quality, ethical considerations, and transparent documentation sets a high standard. Researchers can confidently explore this robust resource, informed by impactful insights.