Intermediate Data Analysis in 21 days
SQL joins, window functions, funnel and cohort analysis, A/B testing, and statistics for analysts.
- Plan diario, 45-60 min al día
- 7 lecciones + 21 ejercicios
- Tutor de IA incluido
- No se requiere experiencia previa en programación
- Tareas prácticas todos los días
- Construye un proyecto de portafolio impresionante
Lo que aprenderás
Un plan Intermedio diseñado por mentores con subtemas estructurados, cuestionarios y tareas prácticas.
SQL joins, aggregations, and window functions
Use JOIN, GROUP BY, HAVING, PARTITION BY, ROW_NUMBER, and LAG for multi-table analysis.
Funnel and conversion analysis
Track user journeys through steps, measure drop-off rates, and identify conversion blockers.
Cohort and retention analysis
Group users by acquisition date and measure how retention changes over time.
Business metrics deep dive
Build reliable calculations for DAU/MAU, LTV, CAC, churn, and product health metrics.
A/B testing and experiment analysis
Design experiments, define success metrics, run significance tests, and interpret results.
Probability and statistics for analysts
Apply distributions, hypothesis testing, p-values, and confidence intervals to real data.
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 correct1. How long is the Data Analysis plan?
Correct2. What level is this Data Analysis plan?
Incorrect3. Which of these appears in the Data Analysis outline?
CorrectCode practice preview
SubmittedFormat a lesson title
Build a helper that formats a lesson label with a padded index and title.
Amado por aprendices de por vida
Mira cómo estudiantes, profesionales y mentes visionarias están potenciando su mente con Kavka.
“Kavka ayudó a nuestros ingenieros a aprender más rápido sin el ruido. Los planes son personalizados, accionables e increíblemente efectivos.”
“Las tareas prácticas se sintieron como trabajo real, así que las lecciones realmente se quedaron.”
“Treinta minutos al día y volví a entregar proyectos. La estructura me mantiene constante.”
¿Listo para empezar a aprender?
Un plan enfocado y prediseñado con cuestionarios y tareas prácticas — empieza en segundos, sin configuración.
También te puede interesar
Learn Data Analysis in 10 days
Spreadsheets, basic statistics, data cleaning, SQL fundamentals, and business metrics.
Advanced Data Analysis in 30 days
Causal inference, attribution modeling, advanced experimentation, data storytelling, and end-to-end analytics projects.
Learn SQL for Analytics in 7 days
Joins, aggregates, and query patterns for business insights.