checklists.oneSign in
‹ Study plans

Steps to become a data analyst

Spreadsheets, SQL, statistics, Python and charts, then a small portfolio that shows you can answer real questions.

26 items · 6 sections · study, career, programming, sql, python

Start this checklist

Spreadsheets (3)

  • Clean a messy table: duplicates, blanks, wrong datesOpen
  • Learn lookups, SUMIFS and COUNTIFSOpen
  • Make a pivot table that answers one questionOpen

SQL (6)

  • SELECT, WHERE, ORDER BY and LIMITOpen
  • GROUP BY with COUNT, SUM and AVGOpen
  • Joins: inner and leftOpen
  • Subqueries and common table expressionsOpen
  • Window functions: ROW_NUMBER, running totalsOpen
  • Answer 20 practice questions on a free sample databaseOpen

Statistics (5)

  • Mean, median and why outliers matterOpen
  • Percentiles and spread
  • Correlation is not cause: find one example
  • Sampling and confidence intervals, in plain words
  • Run the numbers on a simple A/B test

Python (4)

  • Python basics: lists, dictionaries, functionsOpen
  • Learn pandas: load, filter, group and joinStart with the official getting started pages.Open
  • Handle missing values and wrong typesOpen
  • Do the free short courses on KaggleOpen

Charts and telling the story (3)

  • Pick the right chart: line for time, bar for comparing
  • Build one dashboard in Power BI, Tableau Public or Looker StudioOpen
  • Write one finding as three sentences a manager could act on

Portfolio and job hunt (5)

  • Finish 3 projects on public data, each answering one clear question
  • Publish each with its question, method, result and code
  • Practise 10 SQL interview questions out loud
  • Tailor your resume with numbers from your projects
  • Apply, and note what each rejected application asked for

Written from www.kaggle.com

Similar