Before you analyse a dataset, spend a few minutes understanding it. Most wrong results come from misreading the data, not from a wrong formula.
Questions to ask first
- What does one row represent: one order, one customer, one day?
- What period does the data cover, and are any days missing?
- Which columns are numbers, dates and text?
- Who created the data, and how?
Quick checks
- Count the rows and look at the first and last few.
- Check the minimum and maximum of each number column for impossible values.
- Count blanks in each column.
- Look for duplicates in the column that should be unique.
Write down what you find
Keep short notes, such as “dates before March are missing” or “amounts include tax”. Mention them when you share the result.
Next step: see our data analytics course at ScholarLogic, or book a free demo class. A counsellor will share the fee and the next batch dates.
