ENES

Data analyst

The person who turns a business question into numbers, and the numbers into an answer.

A question, why did sales drop in March, goes into a table of data, comes out as a bar chart with one low bar, and ends as a short answer

A data analyst takes a question someone in the business has, like "why did sales drop in March?" or "which stores sell the most on weekends?", finds the data that can answer it, and explains what the data says. The result is usually a chart, a short report or a dashboard, plus a plain-language conclusion.

The everyday toolkit is modest and powerful: spreadsheets, SQL to pull data out of databases, a business intelligence tool like Power BI, Tableau or Looker to build charts, and sometimes Python. Much of the time goes into steps nobody sees: understanding what each column really means, cleaning odd values and checking that the numbers match what finance reports.

It is often confused with data science. The line is blurry, but a data analyst mostly describes and explains what already happened, while a data scientist more often builds models that predict or automate. A good analyst is valuable less for fancy techniques than for asking the right follow-up question and saying clearly what the data does and does not show.

Keep in mind

Go deeper

Related terms

More in Data