Use this checklist to see where you stand. For each skill, ask yourself honestly: could I do this in an interview without looking anything up?
Technical skills
SQL (essential)
- Filter, sort and limit rows.
- Aggregate with GROUP BY and HAVING.
- Join several tables correctly.
- Use CASE WHEN, handle NULLs, work with dates and text.
- Write subqueries and CTEs.
- Use window functions for ranking, running totals and comparisons.
Excel or Google Sheets (essential)
- Sort, filter, remove duplicates, text-to-columns.
- XLOOKUP/VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF and IFERROR.
- Pivot tables and pivot charts.
- Basic charts and conditional formatting.
A BI tool (usually expected)
- Power BI or Tableau: connecting data, cleaning it, building a simple model, creating measures and designing a one-page dashboard.
Python (increasingly expected)
- Core Python: strings, lists, dictionaries, loops, functions.
- pandas: reading files, filtering, groupby, merge, cleaning, dates.
- Charts with Matplotlib or Seaborn.
Statistics (essential basics)
- Mean, median, percentiles, standard deviation.
- Distributions and outliers.
- Correlation and why it is not causation.
- The idea behind A/B tests and p-values.
Soft skills
Asking good questions
Before any analysis: what decision is this for, what period, what definition? The best analysts clarify first.
Business understanding
Knowing what drives revenue, cost and customer behaviour in the industry you work in. This is why domain projects are valuable.
Communication
Explaining findings clearly to people who do not care about your SQL. Leading with the answer, then the evidence.
Attention to detail
Catching the duplicate, the wrong filter or the total that does not match last month's.
Curiosity
Asking "why" one more time than required usually leads to the real insight.
How to build these together
Practise technical skills on focused questions, then combine them in projects that require soft skills too: reading a brief, choosing questions and writing findings. Our practice tracks cover the technical side; live projects bring them together. For the order to learn things in, see the roadmap for freshers.
Practise what you just read
Reading helps; writing the code yourself is what sticks. Start here: