Live Google BigQuery showcase — public theLook commerce facts plus synthetic budget, forecast, and supplier extensions. Dashboards query reporting views at runtime; figures are for design and KPI validation only, not operating company data.
Notation (IBCS-style)
| Symbol | Meaning |
|---|---|
| AC | Actual — measured result for the selected period. |
| PL | Plan / budget reference. |
| FC | Forecast reference. |
| PY | Prior year (same period last year). |
| ΔPY | Variance vs prior year (AC − PY). |
| ΔPL | Variance vs plan (AC − PL). |
| ΔFC | Variance vs forecast (AC − FC). |
Favourable variance: higher sales and margin. Unfavourable: delay, cost pressure, or risk signals.
Order line status
| Status | Definition |
|---|---|
| Processing | Line created; not yet shipped. |
| Shipped | In transit or awaiting completion. |
| Complete | Fulfilled and closed. |
| Cancelled / Returned | Excluded from gross sales KPIs; used in diagnostic views. |
Gross sales KPIs use Processing, Shipped, and Complete unless noted otherwise.
Executive & planning
| KPI | Definition |
|---|---|
| Gross sales | Sum of sale price for Processing, Shipped, and Complete lines in period. |
| Gross margin | Sales minus product cost at order-line level. |
| Gross margin % | Gross margin ÷ gross sales. |
| ΔPY / ΔPL / ΔFC | Absolute and % variance vs prior year, plan, or forecast. |
Pricing & margin
| KPI | Definition |
|---|---|
| Margin bridge | Splits margin change into volume, price, cost, and residual. |
| PPV | Purchase price variance vs standard cost index. |
| Target margin gap | Actual margin rate minus supplier target rate. |
Supply chain
| KPI | Definition |
|---|---|
| Order item volume | Count of order lines in the period. |
| Late shipment proxy | Share of lines with >72 hours from create to ship. |
| Avg hours to ship | Mean hours between line creation and shipment. |
Inventory (season-first)
| KPI | Definition |
|---|---|
| On-hand units / cost | Open stock at the retail calendar snapshot date. |
| May stance | Peak depth, wind-down, off-season clear, or year-round band. |
| Business issue / action | Plain-language exception and recommended next step. |
Inventory in this showcase uses calendar stance and May on-hand — not trailing 12-month cover days (misleading for fashion buying cycles).
Attributes & drill paths
Time
Drill path: Year → Month → Week → Day
Calendar year equals financial year in the demo. Filters apply across all pages consistently.
| Relationship | Cardinality |
|---|---|
| Month → Day | 1 : many |
| Week → Day | 1 : many |
Product
Drill path: Department → Category → Product → SKU
Brand and supplier are cross-filters, not strict hierarchy children. Product name is not unique.
| Relationship | Cardinality |
|---|---|
| SKU ↔ Product ID | 1 : 1 |
| Category → Product | 1 : many |
| Brand ↔ Category | many : many |
Customer
Drill path: Country → Region → City → Customer
Profile attributes reflect current master data, not necessarily values at order time.
| Relationship | Cardinality |
|---|---|
| Customer → Order lines | 1 : many |