Most reporting problems are not caused by formulas. They come from data that was incomplete, duplicated or out of date. A short, repeatable checklist catches most of these before a manager sees the numbers.
1. Completeness
- How many rows are blank in key columns such as customer ID, date and amount?
- In Excel, use a filter or
=COUNTBLANK(range); in SQL,WHERE customer_id IS NULL.
2. Duplicates
- Are there repeated rows, such as the same order ID twice?
- Check uniqueness of the key:
SELECT order_id, COUNT(*) FROM orders GROUP BY order_id HAVING COUNT(*) > 1;
3. Valid ranges
- Are amounts negative when they should not be?
- Are dates in the future, or before the business started?
- Are percentages above 100?
4. Consistency
- Is the same category spelled three ways, such as “Bangalore”, “bangalore” and “Bengaluru”?
- Do totals in the summary match the detailed rows?
- Do dates use one format throughout?
5. Freshness
- When was the data last updated?
- Are there gaps, such as no rows for a whole week?
6. Reconciliation
Compare totals with an independent source: the bank statement, the ad platform, or the finance system. Differences need an explanation before you publish.
Document what you found
Keep a short note: what was checked, what was wrong, and what you did about it. When a number is questioned later, that note is what protects your credibility.
Automate the routine checks
Once you have a checklist, turn it into queries or Power Query steps that run on every refresh. Automated checks catch problems when nobody is looking.
Related: data cleaning in Excel, how to read a dataset before you analyse it and Excel text functions for analysts.
Data quality is practised on real messy datasets in our 5-month Data Analytics course in Bangalore.
Book a free demo class at our BTM Layout centre, and ask a counsellor for batch details.
