Skip to main content

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

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.

Back to the full Analytics Engineer roadmap