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
- 01
The analytics engineering workflow
ELT, the modern data stack and where dbt fits.
- 02
Models & materialisations
Staging, intermediate and mart layers; views, tables and incremental models.
- 03
Sources, tests & documentation
Source freshness, generic and singular tests, docs site.
- 04
Jinja & macros
Reusable SQL with Jinja, macros and packages.
- 05
Snapshots & seeds
Slowly changing dimensions and reference data.
- 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