A retailer merges customer records from multiple systems before a targeted campaign. During review, analysts find duplicate names, inconsistent street abbreviations, and outdated addresses that would distort outreach results. Which step is most important before management trusts the analysis?

Question

BlackTom AI · Accepted Answer

Data quality determines whether analysis is trustworthy, so the essential step is data cleansing/scrubbing to standardize and correct records.

1. Relevant knowledge points and concepts
- Data quality dimensions: accuracy, completeness, consistency, timeliness, and uniqueness.  
- Master data management concepts: deduplication, canonicalization (standard forms), and record linkage.  
- Address validation/enrichment: using authoritative postal reference data to correct outdated addresses.  
- Impact on analytics: poor quality biases counts, response rates, segmentation, and A/B test results.

2. Step-by-step reasoning process
- Profile the merged dataset to quantify issues: count duplicates, inconsistent street abbreviations, nulls, and outdated addresses.  
- Define cleansing rules: unify abbreviations (e.g., "St." -> "Street"), normalize casing, remove punctuation, and standardize format for phone and postal codes.  
- Run address validation/enrichment against a postal service or geocoding API to update or flag invalid addresses.  
- Perform deterministic and fuzzy matching to identify duplicate customer records and merge them using a survivorship rule (which source is authoritative).  
- Recalculate data-quality metrics (percentage duplicates removed, address validation rate) to demonstrate improvement.

3. Intermediate steps (example)
- Initial duplicate count = 1,200; unique IDs after dedupe = 18,800 (so duplicates removed = 1,200).  
- Street abbreviation variations normalized: "St.", "St", "Street" -> "Street" (apply rule across N records).  
- Address validation success rate increased from 78% to 96% after enrichment.

4. Why the correct answer is correct
Cleaning directly fixes the identified problems (duplicates, inconsistent abbreviations, outdated addresses) that would distort campaign outreach and metrics. Only after standardization and validation can management trust counts, segments, and response projections.

5. Why the other options are incorrect
- Increasing records collected: quantity won’t fix existing quality issues and may introduce more noise.  
- Moving to single-tenant cloud: an infrastructure change; it does not correct data content problems.  
- Building a dashboard immediately: dashboards can visualize errors and mislead stakeholders if underlying data is unclean.

6. Conclusion
The most important step before management trusts the analysis is to "Run information cleansing/scrubbing to standardize and correct records," which matches the provided correct answer.

类似问题

Which data cleansing operation involves checking for consistency across different data systems?

A business analyst is improving data quality in a CRM system. Many customer records have missing or inconsistent information, such as incomplete addresses and duplicate entries. Which process should the analyst prioritize?

You own a bond that pays $64 in interest annually. The face value is $1,000 and the current market price is $1,021.61. The bond matures in 11 years. What is the yield to maturity?

Which of the following statements is CORRECT?

It will cost $9,600 to acquire an ice cream cart that is expected to produce cash inflows of $3,600 a year for three years. After the three years, the cart is expected to be worthless. What is the payback period?

更多留学生实用工具

智能学习助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单