What a data analyst actually does
A data analyst takes a business question (which products are selling slowly, where customers drop off) and answers it with data. The work falls into three parts: getting and cleaning the data, analysing it, and explaining what it means to the people who’ll act on it.
That last part is why students from commerce, economics and arts often do well: understanding the business question matters as much as the tools.
The roadmap
- Spreadsheets: sorting, filtering, formulas, pivot tables and simple charts in Excel or Google Sheets.
- SQL: selecting, filtering, joining and grouping data in a database. It’s how you get data out of most company systems.
- Python for data: pandas for tables, Matplotlib for charts, run in a notebook such as Jupyter or Colab.
- Statistics you’ll use: averages and spread, percentages, correlation, and why a sample can mislead.
- Visualisation and dashboards: choosing the right chart, and building a dashboard someone else can use.
- Communication: a one-page summary that leads with the answer and the recommendation.
Practise on real questions
For each step, finish one small project that answers a question with a public dataset: government open data, a sports season, your own expenses. Three finished, explained projects beat ten half-done tutorials.
