Dashboard
When SAP and Salesforce finally talk to each other, this is what the full picture looks like.
KPIs are pulled live from the metrics_customer_health Gold view in Unity Catalog — a join of SAP order history and Salesforce CRM signals. Revenue trend uses 24 months of fact_sap_orders from the Silver layer. Customer Health distribution comes from the XGBoost churn model: probability scores are bucketed into High (>60%), Medium (30–60%), and Low (<30%) tiers. The AI Insights strip calls GPT-4o in the background with the live KPI values and returns a 3-sentence executive summary — it fires after page load so it never blocks rendering.
Today's Priority Briefing
LiveApex Technologies — 87% churn probability, 94 days silent, 4 open cases. Recommend urgent outreach today.
Cloud Storage - 1TB — only 67% of 6-month forecast demand covered by current SAP stock. Critical reorder required.
4 of 12 accounts are at High churn risk — $1,203,000 in revenue exposed this quarter.
Total Customers
70
Total Revenue
$9,247,832
At-Risk Customers
13
19% of customer base
Avg Revenue / Customer
$132,112
Monthly Revenue Trend
SAP orders aggregated by month
← scroll →
Revenue by Category
COMP · MOBI · ACCS product mix
Monthly Units Ordered
Quantity shipped across all SKUs
← scroll →
Customer Health Overview
XGBoost churn risk across all accounts
Inventory Health
Stock gap = 6-month ML forecast demand minus current SAP MARD on-hand stock. Critical = stock covers <80% of forecast, Warning = 80–120%, OK = above 120%. Source: gold_demand_vs_supply_gap Gold view — joins demand_forecast_predictions and bronze_sap_mard_stock.
4 SKUs Critical
Stock covers <25% of 6-month forecast demand
3 SKUs Warning
Stock covers 25–50% of 6-month forecast demand
5 SKUs OK
Stock exceeds 120% of forecast demand
Forecast Demand vs Current Stock (Top 8 by Gap)
Blue = 6M ML forecast · Green = current SAP MARD stock
← scroll to see all products →
| Product | Coverage | Risk |
|---|---|---|
| Business Laptop Pro 15" | 67.0% | Critical |
| Ultrabook Slim 13" | 132.0% | OK |
| Workstation Desktop i9 | 35.0% | Critical |
| All-in-One Desktop 27" | 122.0% | OK |
| Smartphone Pro Max 256GB | 53.0% | Critical |
| Business Tablet 11" | 129.0% | OK |
| Wireless Earbuds Pro | 129.0% | OK |
| Smartwatch Series 5 | 21.0% | Critical |
| USB-C Hub 10-Port | 131.0% | OK |
| Mechanical Keyboard Wireless | 91.0% | Warning |
| 4K USB Webcam Pro | 90.0% | Warning |
| Laptop Stand & Dock | 117.0% | Warning |
Top Risk Customers — Immediate Action Required
Highest churn probability from the XGBoost model · full details on Customer Risk tab
| Customer | Churn Risk |
|---|---|
| Apex Technologies | 87% |
| Meridian Finance | 79% |
| Solaris Healthcare | 71% |
| Nova Retail Group | 64% |
| Quantum Logistics | 58% |