Available learning path

Analyse · KPI · Qualité

SQL Data Analyst

Analyse a business dataset, produce controlled KPIs and explain the limits of the conclusion.

Start the pathSyllabus

Prerequisites

Master SELECT, filters, aggregates, joins and CTEs.

Syllabus

10 structured lessons

  1. 01

    Choose the level of detail and prevent double counting

    Secure a KPI before a join between multiple 1:N relationships.

    28 min · Related practice: Avoid double counting after several joins
    Access required →
  2. 02

    Building cohorts and measuring retention

    Track the same counts over time with a stable denominator.

    32 min · Related practice: Building a cohort and measuring retention
    Access required →
  3. 03

    Segment a portfolio with RFM

    Transform recency, frequency and value into explainable business rules.

    30 min · Related practice: Build a complete RFM segmentation
    Access required →
  4. 04

    Measure a funnel without inflating conversions

    Move from a noisy event log to a controlled funnel.

    30 min · Related practice: Measure a funnel without counting duplicate events
    Access required →
  5. 05

    Master windows, partitions and frames

    Distinguish between PARTITION BY, ORDER BY, ROWS and RANGE to avoid ambiguous indicators.

    35 min · Related practice: Analyze a time series with missing months
    Access required →
  6. 06

    Deduplicate with ROW_NUMBER without losing the truth

    Choose a winning line with a complete and auditable rule.

    28 min · Related practice: Deduplicate with a deterministic rule
    Access required →
  7. 07

    Analyze margin and contribution without confusing revenue and profit

    Link sales, discounts and costs at the right level of detail.

    32 min · Related practice: Analyze the margin and real contribution
    Access required →
  8. 08

    Build a KPI with its quality controls

    Deliver a figure accompanied by its scope and consistency tests.

    30 min · Related practice: Audit a KPI before publication
    Access required →
  9. 09

    Auditing an imperfect dataset

    Profile NULL, formats, duplicates, domains and breaks before analysis.

    34 min · Related practice: Clean an imperfect dataset before analysis
    Access required →
  10. 10

    Conduct a standalone SQL analysis

    Move from an ambiguous question to a repeatable recommendation.

    40 min · Related practice: Conduct an autonomous seller analysis
    Access required →