Revenue
The metric everyone quotes, documented from models/marts/fct_revenue.sql.
Lineage

Definition
select
d.month_key,
c.segment,
sum(o.net_amount) as revenue
from {{ ref('stg_orders') }} o
join {{ ref('dim_customer') }} c on c.customer_sk = o.customer_sk
join {{ ref('dim_date') }} d on d.date_key = o.order_date
where o.order_status = 'fulfilled'
group by 1, 2
Notes
- Net revenue, recognised monthly. Only fulfilled orders count.
- The lineage above is embedded from the canvas, so it stays current.








