Preparing the next view without exposing private workflow data.
Data engineering · Phased project
Make a subscription analytics mart reproducible
A fictional SaaS analyst reports expansion revenue differently from finance because snapshots, refunds and contract changes are joined at incompatible grains.
Practice brief · Version 5
Project scope
10 tickets / 3 phases
Total focused work estimate
30h + setup
Suggested stack
SQL · PostgreSQL · dbt
Recommended next step
Start with ADBT-101
Open the first ticket for its prerequisites, acceptance criteria, verification plan, and an editable task draft.
Practice analytical modeling and explainable transformation contracts.
What the team gains
Review trustworthy reporting definitions and the cost of correcting historical reports.
Before you start
Create a synthetic source schema and local transformation project.
Use integer minor units and distinct reporting currencies.
Delivery agreement
Ten scoped tickets across three phases. Build a synthetic local service or select a ticket after recreating its prerequisites; estimates exclude setup.
AI tools are welcome during implementation. Record assumptions, review the result, and verify its behavior.