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?

Question

BlackTom AI · Accepted Answer

Data cleansing to standardize and correct inaccurate or incomplete data.

1. Relevant knowledge points and concepts
- Data quality dimensions: completeness (missing fields), accuracy (correct values), consistency (uniform formats), and uniqueness (no duplicates).
- Data cleansing (a.k.a. data cleaning or data scrubbing): processes to detect and correct or remove corrupt, inaccurate, or duplicate records; includes standardization, validation, enrichment, and deduplication.
- Other data activities: predictive modeling (uses clean data to forecast), data visualization (presents data), and data mining (discovers patterns). These rely on good data quality but do not fix poor data.

2. Complete reasoning process step by step
- Start from the symptoms: incomplete addresses and duplicate entries directly map to low completeness and poor uniqueness.
- Identify the immediate goal: make records usable—fill or flag missing fields, standardize address formats, merge duplicate customer records.
- Match the appropriate process: data cleansing explicitly performs these tasks (standardization, validation, deduplication, enrichment).
- Recognize sequencing: cleansing should occur before downstream tasks like predictive modeling, visualization, or mining, since those assume reliable inputs.

3. Intermediate steps (detailed actions)
- Standardize addresses: apply address parsing and normalization (e.g., "St." → "Street", consistent country/state codes).
- Validate/complete: use reference data or third-party enrichment to fill missing fields (postal codes, city).
- Deduplicate: use matching rules or fuzzy matching to identify and merge duplicate customer records while preserving audit trails.
- Run quality checks and set automated rules to prevent recurrence.

4. Why the correct answer is correct
- The question describes missing and inconsistent information and duplicates—precisely the issues data cleansing is designed to resolve. Cleansing directly improves completeness, consistency and uniqueness, enabling accurate downstream analysis.

5. Why other options are incorrect
- Predictive modeling: useful for forecasting but ineffective on poor-quality raw records; it should follow cleansing.
- Data visualization: displays trends but does not fix incomplete or duplicate data; visualizations may be misleading if data are dirty.
- Data mining: discovers patterns but also requires high-quality input; it won’t resolve missing/inconsistent entries.

6. Conclusion
- Therefore, the analyst should prioritize: Data cleansing to standardize and correct inaccurate or incomplete data. This matches the provided correct answer.

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?单项选择题

类似问题

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

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?

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搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单