DataSci10X
My ProgressSearchStart Learning
Menu
P94Data CleaningIntermediateChoose14 min

Choose an Outlier Treatment Before Revenue Aggregation

Choose a context-aware treatment for extreme revenue values before reporting a KPI.

#choose#outliers#revenue

Scenario

This month's orders include $18,000, $21,500, $24,000, $310,000, and $3,100,000. The $310,000 row is a documented enterprise annual contract; the $3,100,000 row has currency='USD' but source notes show a 31,000 EUR invoice imported by a new connector.

Problem statement

Decide how to treat the extremes before calculating revenue and justify the next validation steps.

Your Task

  1. Separate legitimate large transactions from suspected data errors.
  2. Choose retain, investigate, correct, exclude, or cap with justification.
  3. State how the KPI should be communicated while the issue is unresolved.

Related Concepts

Data qualityOutliersMetric governance

Ready to count this problem?

Mark it complete when you have reasoned through the solution in your own words.