What Does a Data Analyst Do?
A data analyst turns raw numbers into answers a business can act on. When a store wants to know why sales fell last month, when a hospital wants to know which clinic has the longest waits, or when a website wants to know why visitors leave at checkout, a data analyst finds the data, checks it, analyzes it, and explains what it means in plain language. The job sits between the data and the decision: analysts spend their days with spreadsheets, databases, and dashboards, and their value comes from judgment, not just formulas. One honest note up front: the U.S. Bureau of Labor Statistics has no occupation called data analyst, so there is no official data analyst salary, and any page that quotes one as a BLS figure is guessing. This guide explains the role and gives the closest official pay figures with their labels attached. It is part of our Jobs and Education hub.

What a data analyst does day to day
A typical day starts with a question, not a dataset. A manager asks why returns spiked, or which marketing channel brings the best customers, or whether a price change worked. The analyst's first job is to sharpen the question: what exactly do we need to know, and what would we do differently depending on the answer? A vague question gets a vague analysis, so this step matters more than beginners expect.
Then comes the data work. The analyst pulls data from databases, spreadsheets, or company systems, checks it for gaps and errors, and cleans it: fixing dates, removing duplicates, filling in or flagging missing values. Cleaning is unglamorous and takes a large share of the time, often more than the analysis itself. Next comes the analysis: grouping, comparing, and testing the data to find patterns, usually with SQL queries, spreadsheet formulas, or a scripting language. Finally, the analyst presents the findings, often as a dashboard or a short report with charts, and explains what the numbers mean and what they do not prove. The last step, communication, is where good analysts earn their keep: a correct analysis that nobody understands changes nothing.
The core skills
- SQL. The language for asking questions of databases. Almost every analyst job asks for it, and it is the first technical skill to learn.
- Spreadsheets. Excel and Google Sheets remain the everyday tools for quick analysis, and pivot tables and lookup functions cover a surprising amount of real work.
- Statistics. Averages, distributions, correlation, and basic significance testing: enough to know when a difference is real and when it is noise.
- Visualization. Turning numbers into charts people can read at a glance, and knowing which chart fits which question.
- A scripting language. Python or R, for work that outgrows spreadsheets: larger datasets, repeatable analysis, and simple automation.
- Communication. Writing a clear summary, presenting to non-technical colleagues, and saying plainly what the data cannot tell you.
- Business sense. Understanding what the numbers mean for the company, not just what they are. An analyst who knows the business asks better questions and gives more useful answers.
Tools of the trade
The toolkit is smaller than the job ads suggest. Spreadsheets (Excel, Google Sheets) handle day-to-day analysis. SQL queries databases. A visualization tool such as Tableau or Power BI turns results into dashboards that update as new data arrives. Python, with its data libraries, handles bigger jobs and anything that needs repeating. That is the core of it. Job ads also list cloud platforms, version control, and specialized tools, and those help, but an analyst who is strong in SQL, spreadsheets, and one visualization tool can do most of the job. Tools change every few years; the thinking behind them does not, which is why employers who hire well test for reasoning, not just software names.
What data analysts earn
Here is the honest picture. The BLS does not publish a data analyst occupation, so there is no official data analyst median. Analyst work is counted where the duties fit, across several occupations, and the closest official figures are these, all from BLS May 2025 data:
| Closest BLS occupation | Median annual wage (May 2025) |
|---|---|
| Data scientists (includes business intelligence analysts) | $120,230 |
| Operations research analysts | $88,940 |
| Market research analysts | $78,760 |
The data scientist figure needs a warning label: it covers machine learning and advanced statistics roles that pay more than most analyst jobs, so a typical data analyst earns less than $120,230. O*NET, the Labor Department's occupation database, files business intelligence analysts as a specialty inside the data scientist occupation (code 15-2051.01 under SOC 15-2051), which is why the same median shows up for that title. The operations research figure, $88,940, is probably the closest official guide to a typical analyst's pay, and self-reported pay sites put the average data analyst salary in the mid-$80,000s, which points the same way. Treat any single data analyst salary figure as an estimate from its source, not an official statistic, and check the source before trusting it.
How to become a data analyst
Most data analysts hold a bachelor's degree, often in mathematics, statistics, computer science, business, or economics, but the degree matters less than the portfolio. Employers want proof that you can take a messy dataset and produce a clear answer, so the strongest path is to learn SQL and spreadsheets, complete a few real projects with public datasets, and publish the work: a dashboard, a short write-up, a cleaned dataset with your reasoning shown. Certificates from online courses help, especially for career changers, but they do not replace a portfolio.
A realistic timeline is six to twelve months of focused study for someone starting from scratch, including time to build three or four solid projects. Entry-level titles to look for include data analyst, reporting analyst, business intelligence analyst, and analytics associate. The first job is the hardest to get; after two years of experience, the market opens up considerably.
Job outlook
The outlook for the closest official occupation is very strong. Employment of data scientists is projected to grow 35 percent from 2025 to 2035, much faster than the average for all occupations, adding about 95,400 jobs, with about 24,800 openings a year. Data scientists held about 275,600 jobs in 2025. That growth reflects how much of the economy now runs on data, and it pulls analyst hiring up with it, even though analysts are counted across several occupations rather than one. The risk to watch is automation: AI tools now write basic SQL and build simple dashboards, which pushes the value of the job toward judgment, business knowledge, and communication, the parts that are hardest to automate.
Frequently asked questions
Do you need a degree to become a data analyst?
Most analysts hold a bachelor's degree, often in math, statistics, computer science, business, or economics. The degree matters less than a portfolio that proves you can turn messy data into clear answers.
Should I learn SQL or Python first?
SQL first. Almost every analyst job asks for it, and it is the fastest route to doing real analysis. Add Python once you are comfortable with SQL and spreadsheets.
What is the difference between a data analyst and a data scientist?
Analysts answer questions about what happened and why, using SQL, spreadsheets, and dashboards. Data scientists build predictive models and work with machine learning. The BLS tracks data scientists as an occupation but has no separate data analyst category.
How long does it take to become a data analyst?
About six to twelve months of focused study for someone starting from scratch, including time to build three or four portfolio projects with real datasets.
Is data analysis a good career?
The closest official occupation, data scientists, is projected to grow 35 percent from 2025 to 2035, with about 24,800 openings a year. Pay is strong and the skills transfer across industries.
Sources
- U.S. Bureau of Labor Statistics — Occupational Outlook Handbook: Data Scientists — Median $120,230 in May 2025 ($57.80 an hour); 275,600 jobs in 2025; 35 percent growth 2025-35; +95,400 jobs; about 24,800 openings a year; bachelor's degree typical entry.
- U.S. Bureau of Labor Statistics — Occupational Employment and Wage Statistics, May 2025 (national table) — National employment and wage data by occupation, May 2025, including operations research analysts ($88,940) and market research analysts ($78,760).