Data
Beginner
Diagnose a messy dataset
You export sales data.
Subscribers. The full prompt is part of the SMEMinds AI Playbook. See plans.
Before you use the output
Human review required.
AI output is a confident first draft, not a verified answer.
- Answer the Sharma Traders, Nashik question yourself before any merge. This is a business fact the model cannot know, and getting it wrong corrupts the top-20 list either way.
- Check the row count before and after every fix. A cleaning step that drops rows is the most common silent failure.
- After the customer-name fix, count distinct customers before and after. If it fell from 340 to 180, something over-merged.
- Ask specifically for the list of ambiguous dates in the full file, and resolve them against the source system rather than assuming.