For students and early-career professionals

Data Analyst

Turns raw data into clear insights using analysis, dashboards, and reporting.

14 chapters · About 5–6 months · 15–30 min a day

Start this plan free →

Chapter 1 is free.

Skills

14 skills, and what you'll learn in each

Each skill is a few short lessons, then practice. You rate yourself at the start and again at the end.

Core to the job

Chapter 2

Data cleaning

Clean a messy data set and note each fix

What you'll learn

  • Tidy table shape
  • First data profile
  • Missing value choice
  • Repeatable cleaning steps

Practice

  • Clean a Messy Dataset and Document Your Fixes10 min
  • Decide what the cleaning script may do on its own15 min

Chapter 2

Python

Summarise a data file and write a small reusable function

What you'll learn

  • Data frame basics
  • Function inputs and outputs
  • Read a traceback
  • Clear code names

Practice

  • Load a CSV and Summarise It in a Jupyter Notebook20 min

Chapter 3

SQL

Write queries that filter and summarise data and join tables

What you'll learn

  • Query output shape
  • Join logic
  • Grouping level
  • Query plan

Practice

  • Find the bug in a SQL query15 min
  • Refactor a tangled query into tested steps30 min
  • Check the query an AI assistant wrote15 min

Chapter 5

Dashboards

Build a dashboard with clear filters and honest charts

What you'll learn

  • Question before charts
  • Chart choice
  • Data-ink ratio
  • Filters and refreshes
  • Calculated measure

Practice

  • Pick the right chart for four questions15 min
  • Audit a cluttered dashboard20 min

Chapter 5

Spreadsheets

Build a spreadsheet summary that updates when filters change

What you'll learn

  • Formula references
  • Lookup logic
  • Pivot tables
  • Auditable workbook

Practice

  • Answer 3 manager questions with a pivot table20 min

Chapter 10

Data storytelling

Choose fitting charts and rewrite a finding for a manager

What you'll learn

  • Audience decision
  • Action headline
  • Chart choice
  • Chart clutter

Practice

  • Rewrite a Technical Finding for a Manager10 min
  • Push back on a bad data request20 min

8 more in the plan

Data qualityWrite checks for a table and run them before sharingCh 2

What you'll learn

  • Data checks
  • Plausible values
  • Root cause fix

Practice

  • An alert says sign-ups fell: real, data bug or the weekend10 min
Business understandingTrace how one business number affects money earned or spentCh 6

What you'll learn

  • Business model
  • Key business metrics
  • Metric context
  • Decision before analysis
  • Unit economics
  • Revenue drivers
  • Request to brief

Practice

  • Write the brief before the assistant runs the analysis20 min
Critical thinkingSpot a weak assumption and ask where numbers come fromCh 6

What you'll learn

  • The hidden assumption
  • Argue the other side
  • The base rate
  • Fact vs inference
  • Wanting it to be true
Problem solvingTest each possible cause of a problem instead of guessingCh 6

What you'll learn

  • Problem vs symptom
  • Clean problem splits
  • Root cause
  • Deciding under uncertainty
Statistical thinkingCheck chart claims and test whether chance could explain themCh 7

What you'll learn

  • Compared to what
  • Sample and variation
  • Base rate
  • Correlation and cause
  • Effect size

Practice

  • Read a cohort table and write the takeaway15 min
  • Estimate capacity with simple math15 min
  • Pressure-test a fast first answer10 min
CommunicationRewrite an update for two different readers, cutting extra linesCh 9

What you'll learn

  • Lead with the point
  • Match detail to the reader
  • Said versus heard
  • Specific feedback

Practice

  • Write a Six-Line Delay Message10 min
Working with othersContribute to group work, ask for help and credit teammatesCh 9

What you'll learn

  • Early team friction
  • Clear ownership
  • Challenge ideas, not people
  • Lead or follow
Documenting data workWrite data field definitions that others can use unaidedCh 10

What you'll learn

  • Metric definition
  • Data lineage
  • Assumptions and trade-offs
  • Documentation types

Practice

  • Write data dictionary entries for 5 fields25 min

Your plan

Chapter by chapter.

14 chapters, in this order. Chapter 1 is free.

1~2 wks

See the work of a Data Analyst

StartFree
2~2 wks

Get messy data ready to trust

Skills
3~2 wks

Pull the data you need with SQL

Skills
4~2 wks

Build a sales dashboard with five KPIs

Project
5~2 wks

Turn numbers into charts people read

Skills
6~2 wks

Know the business behind the numbers

Skills
7~2 wks

Tell a real signal from coincidence

Skills
81–2 wks

Talk to two working analysts

People
9~2 wks

Make yourself understood across a team

Skills
10~2 wks

Write up data work others can reuse

Skills
11~2 wks

Capstone: build a funnel metric dictionary

Project
121–2 wks

Answer the questions interviewers ask

Interview
131–2 wks

Decide how you will get in

Decide
14on your timeline

Send your first applications

Apply

Prepare for Level 2

Junior Data Analyst → Data Analyst

10 chapters · 18 skills · 17 practice exercises · Chapter 1 is free

1

Take stock of what the next level asks

StartFree
2

Data prep and coding

Skills
3

Charts and reports people trust

Skills
4

Framing the right question

Skills
5

Statistics, experiments and privacy

Skills
6

Communicating and collaborating

Skills
7

Spreadsheets and documenting your work

Skills
8

Be seen at the level you are reaching for

People
9

Decide if a bigger credential is worth it now

Decide
10

Make your review count

Review

Prepare for Level 3

Data Analyst → Senior Data Analyst

10 chapters · 19 skills · 11 practice exercises · Chapter 1 is free

1

Take stock of what the next level asks

StartFree
2

Set and hold the bar for good work

Skills
3

Move things beyond the teams you run

Skills
4

Communicating and collaborating

Skills
5

Framing the right question

Skills
6

Predictive models and their risks

Skills
7

Design data models on a cloud platform

Skills
8

Be seen at the level you are reaching for

People
9

Decide if a bigger credential is worth it now

Decide
10

Make your review count

Review

Prepare for Level 4

Senior Data Analyst → Analytics Lead

10 chapters · 15 skills · 3 practice exercises · Chapter 1 is free

1

Take stock of what the next level asks

StartFree
2

Set and hold the bar for good work

Skills
3

Move things beyond the teams you run

Skills
4

Communicating and collaborating

Skills
5

Data prep and coding

Skills
6

Storing data and designing tables

Skills
7

Framing the right question

Skills
8

Be seen at the level you are reaching for

People
9

Decide if a bigger credential is worth it now

Decide
10

Make your review count

Review

The job

What a Data Analyst does

Help teams make better decisions by cleaning, analyzing, and explaining data in reports and dashboards.

The work

  • Collect data from spreadsheets, databases, and apps, and check it for errors
  • Clean and combine data so it is ready for analysis and reporting
  • Analyze trends and drivers to answer business questions with evidence
  • Build dashboards and recurring reports for key metrics and goals
  • Write clear notes that explain definitions, assumptions, and limits
  • Work with stakeholders to clarify questions and success measures
  • Monitor data quality and flag unusual changes in important metrics

A typical day

  1. Review dashboard alerts and investigate any sudden metric changes
  2. Meet with a team to confirm the question, timeline, and data needed
  3. Pull data with SQL, clean it, and run checks before analysis
  4. Build charts or a dashboard view, then write a short summary of findings
  5. Share results, collect feedback, and log follow-up questions for next steps

Tools

Spreadsheets: Excel, Google SheetsDatabases: SQLBI tools: Tableau, Power BI, LookerProgramming: Python, RNotebooks: JupyterVersion control: Git

Ways in

There is more than one route.

Ways to study

  • Bachelors degree in data analytics, statistics, economics, computer science, or business
  • Diploma or certificate in analytics, business intelligence, or database basics
  • Online courses or bootcamps focused on SQL, dashboards, and practical projects
  • Self-taught path with a portfolio plus short credentials in analytics tools

How people get their first job

  • Apply for data analyst internships or reporting internships
  • Start in a reporting or operations role and take on analytics tasks
  • Build a portfolio with 2 to 4 projects using real public datasets
  • Earn a practical SQL certificate and a dashboard tool certificate
  • Volunteer to analyze data for a student club or local nonprofit

How the work is changing

What AI is doing to this role

How AI is changing this role · one of 6 tasks we track

Clean and join messy datasets

Sped up a lot

What AI does

AI scripts handle deduplication, type casting, and column matching.

Still yours

You decide what a bad row means and whether to drop or fix it.

Reviewed September 2026

In the app · Premium

The rest is in the app

  • How AI affects the other 5 tasks
  • Whether this job is growing or shrinking
  • How hard the first job is to get
  • Similar roles that are easier to get into
  • Updated every month, with sources
See it in the app →

How we rate a job →

Already working

Already a Data Analyst?

Plan your move to Senior Data Analyst: 10 chapters that end with a strong case for your next review.

Grow in the role →

Other roles in Data & Analytics

Questions

Questions about this plan

How long does it take to become a data analyst with Welica?

The plan is 14 chapters, 5–6 months at 15 to 30 minutes a day. You can go faster or slower; the plan moves with you.

Do I need a degree?

Not always. Common routes are bachelors degree in data analytics, statistics, economics, computer science, or business, diploma or certificate in analytics, business intelligence, or database basics, online courses or bootcamps focused on SQL, dashboards, and practical projects, or self-taught path with a portfolio plus short credentials in analytics tools.

What is free?

Chapter 1, See the work of a Data Analyst, is free for good. Premium unlocks the rest of the plan.

Start the Data Analyst plan.

Chapter 1 free. About 15 to 30 minutes a day.

Start on web Continue your session Download for MacMac Get the iPhone appiPhone Get it on Google PlayAndroid