Hello Data Analysts,
Let’s talk about data quality.
Bad data can have a big impact on a company's bottom line.
Poor-quality data is frequently blamed for operational blunders, incorrect analytics, and poorly thought-out company initiatives.
What should be reviewed?
Let’s talk about data quality.
Bad data can have a big impact on a company's bottom line.
Poor-quality data is frequently blamed for operational blunders, incorrect analytics, and poorly thought-out company initiatives.
What should be reviewed?
Organizations can detect data mistakes that need to be fixed and determine whether the data in their IT systems is suitable for the intended use by measuring data quality levels.
1. Check for completeness/uniqueness. Presence of missing data? Are data entries duplicated?
1. Check for completeness/uniqueness. Presence of missing data? Are data entries duplicated?
2. Check for accuracy and consistency. Are the formulas correct and consistent? Are the entered Data accurate?
3. Check for conformance and validity. Do the data meet required specifications?
4. Timeliness. Is it up to date? Is it readily available?
3. Check for conformance and validity. Do the data meet required specifications?
4. Timeliness. Is it up to date? Is it readily available?
5. Review the provenance. What is the source of this data? Can it be relied upon?
Thankfully, we can check data quality issues at every step of the analysis work. These are:
1. Fix quality issues before/as they are captured
2. Detect & fix issues inside source system
Thankfully, we can check data quality issues at every step of the analysis work. These are:
1. Fix quality issues before/as they are captured
2. Detect & fix issues inside source system
3. Detect & fix issues in ETL: Audit, Balance & Ctrl; Standardize during load & ensure Referential Integrity.
4. Detect & fix issues inside the database
5. Detect & fix issues in report or analysis
Avoid damaging the business with incorrect analysis.
#DataQuality #Analytics
4. Detect & fix issues inside the database
5. Detect & fix issues in report or analysis
Avoid damaging the business with incorrect analysis.
#DataQuality #Analytics
• • •
Missing some Tweet in this thread? You can try to
force a refresh
