Careers › Data & Analytics › Data Analyst
For students and early-career professionals
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.
What's in the plan
Practice 18 practice tasks Tasks from the real work of the job, 10 to 30 minutes each
Projects 2 projects you keep Sales dashboard with 5 KPIs and weekly trends App funnel metric dictionary with drop-off analysis
Interview 20 interview questions Practise your answers, with feedback
People 4 people to reach Who they are, with 4 messages ready to send
Also: choose your route in (7 credentials compared, none required) and 3 life skills courses.
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 quality Write checks for a table and run them before sharing Ch 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 understanding Trace how one business number affects money earned or spent Ch 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 thinking Spot a weak assumption and ask where numbers come from Ch 6 What you'll learn
The hidden assumption Argue the other side The base rate Fact vs inference Wanting it to be true Problem solving Test each possible cause of a problem instead of guessing Ch 6 What you'll learn
Problem vs symptom Clean problem splits Root cause Deciding under uncertainty Statistical thinking Check chart claims and test whether chance could explain them Ch 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 Communication Rewrite an update for two different readers, cutting extra lines Ch 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 others Contribute to group work, ask for help and credit teammates Ch 9 What you'll learn
Early team friction Clear ownership Challenge ideas, not people Lead or follow Documenting data work Write data field definitions that others can use unaided Ch 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 Start Free
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
8 1–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
12 1–2 wks Answer the questions interviewers ask Interview
13 1–2 wks Decide how you will get in Decide
14 on 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 Start Free
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 Start Free
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 Start Free
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 Review dashboard alerts and investigate any sudden metric changes Meet with a team to confirm the question, timeline, and data needed Pull data with SQL, clean it, and run checks before analysis Build charts or a dashboard view, then write a short summary of findings Share results, collect feedback, and log follow-up questions for next steps Tools Spreadsheets: Excel, Google Sheets Databases: SQL BI tools: Tableau, Power BI, Looker Programming: Python, R Notebooks: Jupyter Version 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 Life skills in this plan: Networking · Job interviews · Job search
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.
Already have an account? Sign in