How to become a data analyst

1. 1Build math and computer basics in high school

   Time: 4 years (high school)Sources 1

   Take the most math your school offers, ideally through statistics or calculus, and any computer science course. BLS points to algebra, calculus and probability and statistics as the foundation for data science work. Outside class, a spreadsheet project using real public data, such as sports results or local census figures, teaches sorting, formulas and charts. Practice writing a few sentences explaining what your chart shows; that habit is half the job.

2. 2Earn a bachelor's degree with statistics and programming

   Time: 4 yearsCost: $11,377/yr median public in-state tuition (data analytics bachelor's)Sources 1, 2, 8

   Common majors are statistics, mathematics, computer science, economics, data analytics and business. Whatever the major, take at least two statistics courses, a database course that teaches SQL, and Python or R. Electives in one field you might work in (finance, marketing, public health) make you more useful to employers there. Some jobs, especially statistician and research roles, expect a master's degree, so check postings for the jobs you want before your last year.

3. 3Or take a career-change certificate

   Time: 3-6 months part timeCost: About $49/month (Coursera, U.S.)Sources 7

   If you already have a degree or work experience, a structured certificate can fill the technical gap. The Google Data Analytics Professional Certificate on Coursera has 9 courses, needs no prior experience, and takes under 6 months at about 10 hours a week. It covers spreadsheets, SQL, Tableau and Python and ends with a case study you can show employers. A certificate alone rarely gets a job; pair it with your own projects.

4. 4Build a portfolio of real analyses

   Time: 2-6 months, alongside studySources 1

   Pick three or four public datasets and answer a specific question with each one, for example which bus routes run late most often in your city. Show the SQL or code, the cleaning steps, a clear dashboard and a one-page written conclusion. Host the work on GitHub or a public dashboard site. Hiring managers use portfolios to judge whether you can handle messy data and explain results to people who are not analysts.

5. 5Add an optional tool certification

   Time: 1-3 months of studyCost: Exam fee (varies by country)Sources 5, 6

   Certifications are never required, but they can help a résumé pass a screen. Microsoft's PL-300 exam leads to the Power BI Data Analyst Associate credential; it is a proctored 100-minute exam and must be renewed every 12 months through a free online assessment. CompTIA Data+ (DA0-002) is a vendor-neutral exam of up to 90 questions in 90 minutes, and CompTIA recommends 18-24 months of analyst experience first.

6. 6Land a first analyst job and specialize

   Time: OngoingSources 1, 3

   Entry titles include data analyst, reporting analyst, business intelligence analyst, marketing analyst and operations analyst. Internal moves are common: people in finance, customer support or operations who start building reports often transfer into analytics. Once hired, learning one industry's data deeply, plus more statistics and Python, opens the path to senior analyst, analytics manager or data scientist roles.

Programs, tuition and graduates’ earnings

U.S. Department of Education, College Scorecard (most recent cohorts, released 2026-10-15). Scorecard groups programs by 4-digit field, so a row can include related programs. Tuition is the median published undergraduate tuition and fees of the colleges offering the program (shown only for undergraduate credentials); debt is the median of programs’ median federal loan debt at completion; earnings are the national median for the field and credential four years after completion.

Requirements differ by state. Check your state’s rules in the CareerOneStop License Finder (U.S. Department of Labor) before you enroll.

SQL

Almost every analyst request starts with pulling and joining tables from a company database, and many interviews include a live SQL test.

Statistics

Knowing whether a 2% change in sales is real or noise keeps managers from acting on random swings.

Data cleaning

Duplicate customers, mismatched dates and missing values can quietly wreck a result, and fixing them takes much of an analyst's week.

Data visualization

A dashboard has to show the one number a manager needs at a glance, without misleading scales or clutter.

Plain-language communication

The analysis only matters if a non-technical audience understands it well enough to change a budget, staffing plan or campaign.

Business knowledge

Understanding how claims, orders or patient visits are actually recorded tells you which numbers to trust and which questions are worth asking.

O*NET 31.0 rates these skills as most important for the occupation: mathematics, critical thinking, reading comprehension, speaking, active learning.

Training cost

$294–$45.5K

Before financial aid

Time

4 years (bachelor's degree)

Typical path

Median pay

$120,230

All US jobs: $50,980

Payback once qualified

Under 1 year

Pay above the all-jobs median vs. cost

Low: the Google Data Analytics Professional Certificate at about 6 months x Coursera's $49/month U.S. subscription = $294, for someone who already has a degree. High: 4 years x College Scorecard median published in-state tuition at public colleges for data analytics bachelor's programs, $11,377 = $45,508. Not included: fees, books, living costs, optional certification exam fees, or a master's degree (median federal loan debt for data analytics master's graduates is $34,250).

Rough guide only: ignores taxes, aid, interest and earnings given up during training. How we calculate it.

• Data scientist$120,230 median

  Requires stronger Python or R, statistics and machine learning; many people add a master's degree or build modeling projects on the job.

• Business analyst / management analyst$101,860 median

  Analysts who enjoy process and requirements work move into business or management analysis, sometimes with a project or process certification.

• Financial analyst$102,740 median

  Analysts in finance teams can move into financial analysis by adding accounting, valuation and forecasting coursework.

• Actuary$130,000 median

  Needs a strong math background and passing a series of professional actuarial exams, usually while working at an insurer.