CodeBaobab
SQL, analysis, and business decisions

Data Analyst

Learn to retrieve, clean, summarize, and explain data so a stakeholder can make a defensible decision.

By the end

Turn raw tables into trustworthy metrics, analytical reports, and clear product recommendations.

Suggested next course

Filtering Rows

Ask a table for exactly the rows and columns you mean, and nothing else.

Start with Filtering Rows
Jump to a phase 4 phases

Ask useful questions with SQL

4 courses

View phaseHide phase

Select the right records, summarize them, and combine related tables.

Learn the concepts

  1. SQL & DataSuggested nextFiltering Rows
  2. SQL & DataGrouping and Aggregation
  3. SQL & DataJoining Tables
  4. SQL & DataSubqueries, CTEs and Set Operations

Clean and reshape answers

5 courses · 1 practice activities

View phaseHide phase

Handle ordering, text, dates, duplicates, and awkward gaps in real data.

Learn the concepts

  1. SQL & DataSorting and Pagination
  2. SQL & DataStrings and Text
  3. SQL & DataNumbers and Dates
  4. SQL & DataDuplicates, Median and Mode
  5. SQL & Data · OptionalRanges and Gaps

Put it into practice

Build analytical reports

6 courses

View phaseHide phase

Use windows, reporting shapes, and product metrics to explain what changed and why.

Learn the concepts

  1. SQL & DataWindow Functions I: Ranking and Top-N
  2. SQL & DataWindow Functions II: Running Values
  3. SQL & DataReporting and Reshaping
  4. SQL & DataProduct Analytics Patterns
  5. SQL & Data · OptionalHierarchical and Recursive Queries
  6. SQL & Data · OptionalChanging Data

Add Python and statistical judgment

3 courses · 1 practice activities

View phaseHide phase

Move beyond a query to inspect data, quantify uncertainty, and evaluate an experiment.

Learn the concepts

  1. AI & Machine LearningPython for Data Work
  2. AI & Machine LearningProbability and Statistical Reasoning
  3. AI & Machine LearningExperimentation and Product Analytics

Put it into practice