BI · Tableau
Where is service failing? OTIF vs 95% target, freight cost, and exception tickets across GTA and Buffalo-Detroit plants.
Synthetic North America ops demo data. Charts below mirror Tableau-ready extracts.
Latest month network pulse, with MoM deltas on OTIF and freight.
OTIF vs 95% target, freight by plant, inventory turns vs fill.
Dotted line = 95% service target
Cyan = Canada · Deep blue = US nodes
Color encodes OTIF; look for high-fill and low-turn or low-OTIF outliers
Ontario GTA · Golden Horseshoe vs New York Niagara and Michigan Auto Belt.
Latest month · target awareness by region
Marker size ≈ order volume · color = OTIF
Revenue contribution by category and product line for the latest month.
Cementitious · Aggregates · Packaged · Logistics add-ons
Where mix concentration creates service or margin risk
Root-cause Pareto plus highest-severity tickets, the action layer of the control tower.
Latest month exception volume
Critical → Action → Watch
| ID | Plant | Root cause | Impact | Severity | Owner |
|---|
Collapsed by default; open if you want skills notes, CSV list, or the coursework viz.
dim_plants + facts) ready for Tableau relationships.tableau/extracts/ (also in docs/assets/data/ for these web charts).dim_plants → facts on plant; publish sheets for KPI, OTIF, regional, category, exceptions.ops_control_tower.csv Plant-month OTIF, freight, turns, fill, sales, lat/lonsales_by_category.csv Category / product-line revenue & unitsotif_exceptions.csv Exception tickets, root cause, severityregional_performance.csv Country-region rollupsdim_plants.csv Plant dimension (market, country, geo)optimal_shipments.csv Network optimizer lanes for map overlays