How to become a data analyst: the skills and certifications that matter
Data analysis is one of the most popular routes into tech without a computer science degree. Employers care much less about your degree than about whether you can answer a business question with data. Here's what that takes.
The four core skills
- SQL: pulling data out of databases. SELECT, WHERE, JOINs, GROUP BY and, later, window functions. Most technical interviews include a SQL test
- Excel: still everywhere. XLOOKUP, pivot tables, conditional formulas and cleaning messy data
- A BI tool: Power BI (more common in UK corporate jobs) or Tableau. Building dashboards, data models and measures
- Statistics basics: averages and medians, spread, distributions, correlation vs causation, and simple significance
Certifications that help
Certifications won't replace a portfolio, but they get your CV past filters and give you a structured way to learn:
- Microsoft Power BI Data Analyst (PL-300): the most recognised BI certification in UK job adverts
- Tableau certifications, such as Tableau Desktop Specialist, if you're targeting Tableau roles
- Entry-level analytics certificates are a good starting point if you're brand new
A 3-month plan
- Month 1: SQL and Excel. Practise daily with real questions, not just videos
- Month 2: Power BI or Tableau. Build two dashboards from public datasets (ONS, NHS or Kaggle data works well)
- Month 3: statistics, then a portfolio project that answers a real question end to end. Prepare for the certification exam alongside it
Practise like the interview
Interview tasks are usually a short SQL test plus a take-home dashboard. The best preparation is solving many small, realistic questions: "Which region grew fastest?" "Which customers haven't ordered in 90 days?" Do that until the patterns feel natural.
Mock Night's Data Analyst track has practice for SQL, Excel, Power BI (PL-300), Tableau and statistics, with worked answers. It's a quick daily habit alongside your projects.
Daily questions with explanations and timed mock tests. Free for 14 days, on the web or Telegram.
Start practisingFrequently asked questions
Do I need a degree to become a data analyst?
Not necessarily. Many employers hire on skills: SQL, Excel, a BI tool and the ability to explain findings. A portfolio of projects helps a lot.
Should I learn Power BI or Tableau?
In the UK, Power BI appears in more job adverts, especially in corporate and public sector roles. Tableau is common in some industries. Learn one well first.
Is PL-300 worth it?
It's the most recognised Power BI certification and helps your CV get noticed, especially alongside a portfolio.
Exam rules and fees can change. Always check the official exam body before you book. Mock Night is an independent practice resource, a product of The 36th Solutions Ltd.