Skip to content

ACCA Strategic Professional · Strategic Business Leader · Big data and data analytics

Vexel Manufacturing's analytics team finds that 15% of records in its supplier database have missing or outdated payment terms, causing flawed spend analysis. Management wants a lasting solution rather than a one-off clean-up. Which approach is most appropriate?

Assigning data stewards, setting quality rules at the point of entry and monitoring quality metrics is the most appropriate approach. It prevents errors at source and creates continuing accountability, whereas annual clean-ups or individual private corrections only treat symptoms and let inconsistent or poor data recur.

  1. ARun a one-off cleansing exercise each year before the annual report
  2. BHave analysts correct errors individually as they find them in their own copies
  3. CAssign data stewards, set quality rules at the point of entry and monitor quality metrics regularlyCorrect
  4. DStop using the supplier database for analysis

Explanation

Lasting quality needs preventive controls and ongoing accountability: stewards, validation at entry and regular monitoring. Annual clean-ups let errors recur, and private corrections create inconsistent copies. Abandoning the data loses its value.

Did you get it right without looking?

One question tells you little. A timed set on Big data and data analytics shows your real accuracy, how long you take and where you lose marks.

Practise Big data and data analyticsFree diagnostic mock

More Big data and data analytics questions