Optimisation de la
Rentabilité
Commerciale

SELECT product_id, category, SUM(revenue) AS total_revenue, SUM(cost) AS total_cost, SUM(revenue - cost) AS gross_margin, ROUND(SUM(revenue - cost) / NULLIF(SUM(revenue),0) * 100, 2) AS margin_pct FROM sales_fact sf JOIN product_dim pd ON sf.product_id = pd.id JOIN date_dim dd ON sf.date_id = dd.id WHERE dd.year = 2024 GROUP BY 1, 2 ORDER BY gross_margin DESC;    def extract_transform(filepath): df = pd.read_csv(filepath) df.columns = df.columns.str.strip().str.lower() df['sale_date'] = pd.to_datetime(df['sale_date']) df['margin'] = df['revenue'] - df['cost'] df.dropna(subset=['product_id','revenue'], inplace=True) return df    Margin_% = DIVIDE([Total Margin],[Total Revenue]) ABC_Class = VAR pct = CALCULATE([Revenue_Running_%]) RETURN IF(pct <= 0.8, "A", IF(pct <= 0.95, "B", "C"))