Start for Free

Intermediate Data Analysis in 21 days

SQL joins, window functions, funnel and cohort analysis, A/B testing, and statistics for analysts.

  • Daily plan, 45-60 min a day
  • 7 lessons + 21 exercises
  • AI tutor included
duration21-day sprint
Topics7 total
Exercises21 total
levelIntermediate
  • No prior coding experience required
  • Practice tasks every day
  • Build impressive portfolio project

What you will learn

A powered by mentors Intermediate plan with structured subtopics, quizzes, and practice tasks.

01Core

SQL joins, aggregations, and window functions

Use JOIN, GROUP BY, HAVING, PARTITION BY, ROW_NUMBER, and LAG for multi-table analysis.

02Core

Funnel and conversion analysis

Track user journeys through steps, measure drop-off rates, and identify conversion blockers.

03Core

Cohort and retention analysis

Group users by acquisition date and measure how retention changes over time.

04Core

Business metrics deep dive

Build reliable calculations for DAU/MAU, LTV, CAC, churn, and product health metrics.

05Challenge

A/B testing and experiment analysis

Design experiments, define success metrics, run significance tests, and interpret results.

06Core

Probability and statistics for analysts

Apply distributions, hypothesis testing, p-values, and confidence intervals to real data.

07Challenge

Capstone: product metrics dashboard

Build a complete SQL-powered dashboard tracking acquisition, activation, retention, and revenue.

See the quiz + practice flow

Three answered questions and a filled code task so you know exactly what to expect.

Quiz preview

2/3 correct

1. How long is the Data Analysis plan?

Correct
21-day sprint
5-day sprint
7-day sprint
10-day sprint

2. What level is this Data Analysis plan?

Incorrect
Beginner
Intermediate
Advanced
Expert

3. Which of these appears in the Data Analysis outline?

Correct
SQL joins, aggregations, and window functions
Data Analysis workflow playbook
Data Analysis best-practice checklist
Data Analysis case study

Code practice preview

Submitted

Format a lesson title

Build a helper that formats a lesson label with a padded index and title.

Loved by Lifelong Learners

See how students, professionals, and forward-thinkers are upgrading their minds with Kavka.

“Kavka helped our engineers learn faster without the noise. The plans feel tailored, actionable, and incredibly effective.”

Adam K.NovaStack

“The practice tasks felt like real work, so the lessons actually stuck.”

Miguel TorresBackend Engineer

“Thirty minutes a day and I was shipping again. The structure keeps me honest.”

Emily ChenUX Designer

Ready to start learning?

A focused, prebuilt plan with quizzes and practice tasks — start in seconds, no setup required.

You might also like

Beginner

Learn Data Analysis in 10 days

Spreadsheets, basic statistics, data cleaning, SQL fundamentals, and business metrics.

Advanced

Advanced Data Analysis in 30 days

Causal inference, attribution modeling, advanced experimentation, data storytelling, and end-to-end analytics projects.

Beginner

Learn SQL for Analytics in 7 days

Joins, aggregates, and query patterns for business insights.