Data

dbt Analytics Engineering

Modern analytics engineering with dbt, built around the NaijaCart e-commerce capstone.


Modern analytics engineering with dbt, built around the NaijaCart e-commerce capstone.

Every session is hands-on: participants work through guided labs, apply each module to realistic scenarios and leave with materials they can reuse at work.

Curriculum

  1. 01

    The analytics engineering workflow

    ELT, the modern data stack and where dbt fits.

  2. 02

    Models & materialisations

    Staging, intermediate and mart layers; views, tables and incremental models.

  3. 03

    Sources, tests & documentation

    Source freshness, generic and singular tests, docs site.

  4. 04

    Jinja & macros

    Reusable SQL with Jinja, macros and packages.

  5. 05

    Snapshots & seeds

    Slowly changing dimensions and reference data.

  6. 06

    NaijaCart capstone

    Modelling orders, customers and payments for a Nigerian e-commerce business.

Outcomes

  • Build a tested, documented dbt project
  • Design layered data models
  • Deliver analytics-ready marts