Data Analyst Skills: The Technical and Soft Skills Employers Actually Ask For
The core data analyst skills are SQL, spreadsheets (Excel or Google Sheets), a BI tool (Power BI or Tableau), basic statistics, and, increasingly, Python. On top of these sit the soft skills that decide who gets hired: framing business questions, communicating findings clearly and checking data quality. For beginners the order matters: SQL and spreadsheets first, then BI, then Python.
Key takeaways
- Learn skills in the order employers screen for them: SQL, spreadsheets, BI, statistics, Python.
- Soft skills separate a good analyst from a query writer.
- Domain knowledge (finance, marketing, operations) multiplies the value of technical skills.
- Show skills through projects. Listing them isn’t enough.
Technical data analyst skills, ranked for beginners
| Priority | Skill | What “job-ready” looks like |
|---|---|---|
| 1 | SQL | JOINs, GROUP BY, subqueries/CTEs, window functions, date handling |
| 2 | Spreadsheets | XLOOKUP/INDEX-MATCH, pivot tables, charts, data cleaning |
| 3 | BI tool | Data model, relationships, measures (DAX or calculated fields), an interactive dashboard |
| 4 | Statistics | Mean, median, variance, distributions, correlation vs causation, A/B test basics |
| 5 | Python | pandas for cleaning and aggregation; matplotlib or seaborn charts; Jupyter |
| 6 | Data cleaning | Handle duplicates, nulls, inconsistent formats and outliers |
| 7 | Version control and documentation | Readable, commented queries; basic Git |
SQL
Most organisations keep their data in relational databases, so SQL is the analyst’s main tool. Our SQL for data analysis guide covers the queries analysts use daily.
Spreadsheets
Even in data-mature companies, stakeholders live in Excel. You will import, clean, pivot and share there constantly. For finance-flavoured roles, see Excel skills for finance.
BI and visualisation
Dashboards are how your work reaches decision-makers. Learn chart choice (bar for comparisons, line for trends), layout and filters. Power BI vs Tableau helps you pick a tool.
Python
Python handles larger datasets and automates repetitive work. If you’re weighing it against spreadsheets, read Python vs Excel for data analysis.
Soft skills that get analysts hired
- Question framing. Turning “Can you look at sales?” into “Which regions missed target this quarter, and why?”
- Data storytelling. Leading with the answer, then showing the evidence.
- Scepticism. Checking whether a surprising number is a data error before presenting it.
- Stakeholder management. Agreeing definitions (“What counts as an active user?”) before building anything.
- Prioritisation. Knowing which request matters most to the business.
The AI skill layer
AI assistants now draft SQL, explain unfamiliar code and summarise results. Employers value analysts who use them and can verify the output. That still requires the fundamentals above. See how to use generative AI at work.
How to show these skills on a CV
- Replace skill lists with outcome bullets: “Wrote SQL pipeline + Power BI dashboard tracking 12 KPIs; adopted by 3 teams.”
- Link a portfolio with two or three projects; see data analyst portfolio projects.
- Add a certification if it fits your target market, such as PL-300 for Power BI.
For the full step-by-step path, read the pillar guide how to become a data analyst.
Build the skills with a mentor
Tutopiya is planning live Data Analytics with Python & SQL and Business Intelligence (Power BI & Tableau) cohorts, with practising analysts as mentors and real-data projects. They aren’t running yet. Tell us which data skill you want to learn. There’s nothing to pay, and the most-requested programmes open first.
Sources
Frequently asked questions
What is the most important skill for a data analyst? +
SQL. It appears in the large majority of analyst job descriptions because most company data lives in databases. Close behind are spreadsheet skills, a BI tool and the ability to explain findings clearly.
Do data analysts need advanced maths? +
No. Descriptive statistics, basic probability and an understanding of A/B testing cover most analyst work. Advanced mathematics matters more for data science and machine learning roles.
Which soft skills matter most for data analysts? +
Asking the right business question, communicating findings to non-technical people, attention to detail, and healthy scepticism about data quality.
Should I put AI skills on my data analyst CV? +
Yes, if you can show them. Using AI assistants to write and debug SQL or Python, or to summarise analysis, is increasingly valued, as long as you can also verify the output yourself.
Founding cohorts · nothing charged
Want to learn this live, with a mentor?
Tutopiya is planning small, mentor-led online cohorts in English test prep, data & AI, business & finance and digital careers. Tell us which one you want. The programmes with the most interest open first, and the people on the waitlist hear about them first.
See the planned programmesWritten by
Tutopiya Careers Desk
Professional courses & career skills research · Tutopiya
The Tutopiya team researching which professional and certificate programmes to build next. We have taught live online since 2015. These guides answer the questions our waitlist asks most, with sources linked so every claim can be checked.
Related Articles
AI Jobs Without Coding: 9 Non-Technical Roles and How to Get Into Them
AI jobs without coding: non-technical AI roles in operations, product, content, training, governance and sales, with the skills each needs and how to start.
Business Analyst vs Data Analyst: Which Career Fits You?
Business analyst vs data analyst: responsibilities, skills, tools and certifications compared, with five quick questions to help you choose.
Data Analyst Portfolio Projects: 8 Ideas That Impress Hiring Managers
Data analyst portfolio project ideas that get interviews, plus the structure every project needs, where to find real datasets and how to present your work.