milestone 6/6 Customer & product reporting contracts

Produce customer and product reports at a defined level of detail.

Warehouse and Reporting · Profile raw CRM/sales records, build Silver and Gold tables in the disposable lab, explore the fact table, and publish repeatable reporting logic.

approach

A reusable report combines identity, totals, dates, and meaningful segmentation at one entity grain. Preserve entities with no sales when requested. These exercises define recency against 2025-04-01 rather than today, so the answer is reproducible.

SELECT
  c.customer_id,
  c.name,
  COUNT(f.sale_key) AS sales_lines,
  COALESCE(SUM(f.sales),0) AS total_sales
FROM dim_customer c
LEFT JOIN fact_sales f ON f.customer_key=c.customer_key
GROUP BY c.customer_key,c.customer_id,c.name;

data for this milestone