AI-native BI in under 7 days.

with customer_quarters as (
  select
    customer_id,
    sum(case when fiscal_quarter = '2026-Q1'
      then recognized_revenue else 0 end) as prior_revenue,
    sum(case when fiscal_quarter = '2026-Q2'
      then recognized_revenue else 0 end) as current_revenue,
    max(case
      when acquisition_close_date >= date '2026-04-01'
       and acquisition_close_date < date '2026-07-01'
      then 1 else 0
    end) as acquired_in_q2
  from finance.fct_reported_revenue
  where fiscal_quarter in ('2026-Q1', '2026-Q2')
  group by customer_id
),
classified as (
  select
    case
      when acquired_in_q2 = 1 then 'Acquisition'
      when prior_revenue = 0 and current_revenue > 0 then 'New business'
      when prior_revenue > 0 and current_revenue = 0 then 'Churn'
      when current_revenue > prior_revenue then 'Expansion'
      when current_revenue < prior_revenue then 'Contraction'
    end as driver,
    case
      when acquired_in_q2 = 1 then current_revenue
      else current_revenue - prior_revenue
    end as revenue_change
  from customer_quarters
)
select driver, sum(revenue_change) as revenue_change
from classified
where driver is not null
group by driver
order by revenue_change desc;