Projects for Analytics Engineers
Projects are the capstone builds that turn the skills into portfolio evidence: an end-to-end dbt project from raw data to marts, a CI and CD pipeline with slim CI, a governed metrics layer behind a dashboard, and an incremental event model with quality monitoring.
Stage: Capstone and Career · Part of the Analytics Engineer roadmap · Last reviewed 19 November 2026
What to learn in Projects
- Build a dbt project from raw source tables to documented marts
- Set up CI that tests only changed models on pull requests
- Define governed KPIs and connect them to a dashboard
- Create an incremental event model with freshness and volume checks
- Write a project README explaining design choices
Projects interview questions
What makes an analytics engineering portfolio project convincing?
A realistic messy dataset, a clear layered structure, tests and documentation, CI, and a short write-up of the modelling decisions and trade-offs. A reviewer should be able to run it and see why choices were made.
Which public datasets work for a dbt project?
Choose datasets with several related tables and some mess, such as e-commerce orders, ride or bike trips, or open event data. Having raw tables with keys, timestamps and duplicates lets you show staging, modelling and testing.
Where Projects fits in the Analytics Engineer roadmap
Projects belongs to the Capstone and Career stage (advanced level), which takes about 5 hours. Build a portfolio project.
Other units in this stage
Back to the full Analytics Engineer roadmap