Data quality in a sales report

Problem

In a sales report at a large beverage company, some figures did not fully reflect reality, which could steer territorial decisions the wrong way.

Approach

• Cross-checking the report against the sources and locating where consistency broke.
• Correcting the model logic and adding validations to detect deviations.

Result (qualitative)

Reliable data for deciding by territory: decisions now rest on correct figures.

Skills demonstrated

Data quality, reasoning about semantic models, communicating findings to the business.