SELECT order_id, order_date, customer_name, product_name, product_category, quantity, gross_revenue, net_revenue, gross_profit, margin_pct, status, channel FROM marts.fct_orders ORDER BY order_id LIMIT 15

order_id▲	order_date▲	customer_name▲	product_name▲	category▲	qty▲	gross_rev▲	net_rev▲	profit▲	margin%▲	status▲	channel▲

15 de 50 filasmarts.fct_orders

SELECT customer_id, full_name, country, segment, total_orders, completed_orders, lifetime_revenue, lifetime_profit, avg_order_value, value_tier FROM marts.dim_customers ORDER BY lifetime_revenue DESC

id▲	full_name▲	country▲	segment▲	orders▲	completed▲	lifetime_rev▲	lifetime_profit▲	avg_order▲	value_tier▲

10 de 10 filas (completo)marts.dim_customers

SELECT strftime(order_month,'%Y-%m') as month, count(*) as orders, sum(quantity) as units, round(sum(net_revenue),2) as revenue, round(sum(gross_profit),2) as profit, round(avg(margin_pct),1) as avg_margin FROM marts.fct_orders WHERE is_completed GROUP BY 1 ORDER BY 1

month▲	orders▲	units▲	revenue▲	profit▲	avg_margin%▲

10 mesesAgregación sobre fct_orders

SELECT product_category, count(*) as orders, round(sum(net_revenue),2) as revenue, round(sum(gross_profit),2) as profit, round(avg(margin_pct),1) as avg_margin FROM marts.fct_orders WHERE is_completed GROUP BY 1 ORDER BY revenue DESC

category▲	orders▲	revenue▲	profit▲	avg_margin%▲

4 categoríasAgregación sobre fct_orders

SELECT customer_country, count(*) as orders, round(sum(net_revenue),2) as revenue, round(avg(margin_pct),1) as avg_margin FROM marts.fct_orders WHERE is_completed GROUP BY 1 ORDER BY revenue DESC

country▲	orders▲	revenue▲	avg_margin%▲

5 paísesAgregación sobre fct_orders

Revenue Mensual (2023)

Revenue por Categoría

Revenue por País

Distribución de Clientes por Valor

stg_customers.sql