This chart shows the average score (1–5 scale) for each of the six SRM evaluation pillars, compared to the global benchmark (reference line). Values above the line indicate above-average performance; values below the line identify areas for improvement.
Distribution of average Overall score by region. Click any bar to filter the dashboard to the selected region.
Average Overall score by procurement category. Categories with small samples (n < 5) require cautious interpretation.
Heatmap of average Overall score for each region × category combination. Empty cells indicate no data available. Click a cell to apply the combined filter.
Percentage distribution of suppliers across the five performance tiers. Concentration above 30% in the lower tiers (Weak, At-risk) signals a systemic issue.
Suppliers with the highest Overall score in the filtered set.
Suppliers with the lowest Overall score. Consider prioritising corrective actions.
Sortable table with score for each pillar. Click a row to filter the dashboard by the selected supplier.
List of survey respondents, groupable by supplier. Email addresses are clickable for direct outreach.
Detailed evaluation matrix: each row is a supplier, each column a pillar. Colors indicate the performance tier (green = excellent, red = at risk). Click a row to drill into the supplier profile.
Distribution of responses across performance tiers for each pillar. Pillars with concentration >25% in the lower tiers require intervention.
Multi-pillar comparison across the three regions. Regions with small samples are shown but should be interpreted cautiously.
Recurring topic clusters auto-extracted from supplier comments. The numeric value indicates how many responses mention at least one keyword from the cluster.
Most-frequent words (≥4 characters) in comments after stopword removal. Click a word to filter the dashboard.
Distribution of open-text comments across region/category combinations.
Full verbatim feedback, ordered by supplier. Click the supplier name to filter.
Suppliers with Overall score < 3 and at least 2 respondents (high-confidence signal). Schedule SBR within 4 weeks.
Suppliers with Overall score ≥ 4.5 and at least 2 respondents. Consider for Tier-1 partnership programs.
Region × category combinations with the lowest score (≥ 2 responses). Prioritise corrective actions in these areas.
The following statistics are computed at runtime from the deduplication and aggregation pipeline. Open the browser console and inspect window.DEDUP_LOG for the full audit trail.
| Metric | Value |
|---|---|
| Original records | — |
| Duplicates removed (Level 1 + Level 2) | — |
| Vendors aggregated | — (from — records) |
| Suspected duplicates (Level 3, flagged) | — |
Level 1 — exact duplicate: all key fields identical (supplier, respondent name, respondent email, created date) → kept the most recent record.
Level 2 — fuzzy duplicate: same normalized vendor name + same date → merged into a single record (free-text fields concatenated).
Level 3 — suspected duplicate: same normalized vendor, dates within ±3 days → flagged with ! SUSPECTED badge in the Respondents table; not removed.
Records aggregated under a single vendor profile are marked with AGGREGATED (N) in supplier tables, where N = number of unified feedback entries.
This report provides an aggregated and filterable view of DCSP supplier performance evaluations collected through the AWS Performance Survey (External Survey) as part of the FY2026 SRM (Supplier Relationship Management) program. The objective is to support Supplier Business Review (SBR) activities, SOC2 audits, and supplier tiering decisions through a single interactive data source.
Primary audience: DCPG Program Manager, DCSP Procurement Category Managers, L7 Regional Leads, GRC team.
Data source: Smartsheet Form — app.smartsheet.com/b/form/3de1545b018e4b9a9f0515eda3b04908. Extraction: Excel file downloaded from Smartsheet, processed via Python script with normalization, deduplication, and scoring.
| Metric | Definition | How to interpret |
|---|---|---|
| Overall Score | Arithmetic mean of the six pillar scores (excluding null pillars when no data is available). | Scale 1–5. Values ≥ 4 = satisfactory performance. Values < 3 = intervention required. |
| Pillar Score | Mean of the question scores belonging to that pillar. | Identifies the specific weakest area for the supplier. |
| Top Tier (≥ 4.5) | Suppliers with Overall Score in the Excellent tier. | Candidates for Tier-1 strategic partnership. |
| At Risk (< 3) | Suppliers with Overall Score in the Weak or At-risk tiers. | Urgent SBR within 4 weeks recommended. |
| Low n (n=1) | Suppliers with a single respondent. | Score is not statistically significant. Solicit additional responses before drawing conclusions. |
| Data Quality | Percentage of survey cells with a validly mapped answer (excluding empty values and "N/A or do not know"). | Minimum acceptable threshold: 85%. Lower values require survey or scoring rule review. |
| Δ vs Global | Difference between the filtered set's score and the global average. | Δ > +0.30 = significant out-performance. Δ < -0.30 = under-performance. |
Horizontal bar chart. Shows the average score for each of the 6 SRM pillars (Strategy, Safety, Security, Relationship, Operation, Financial). The reference line represents the global average (3.92 / 5 in the current dataset).
Data source: Survey Q1–Q33 mapped to 1–5 scale. Calculation: arithmetic mean of question scores, excluding N/A.
Vertical bar charts. Show the average Overall score aggregated by region (AMER/EMEA/APAC) or DCSP category (GC/DE/CPI/Cx/Controls/SS).
Calculation: mean of the Overall scores of all responses in the group.
Heatmap. Each cell shows the mean Overall score for the combination and the number of responses (n=). Clicking a cell applies both filters (region + category).
Stacked bar. Distribution of suppliers across the 5 performance tiers.
Two-entry heatmap table. Quickly identifies which supplier has which specific weakness. Useful during SBR preparation.
Aggregation of open comments via keyword matching across 8 predefined clusters: Schedule & Timing, Change Orders & Cost, Process & Documentation, Communication, Construction & OFCI, Safety, Strategy & Planning, Staffing & Decision.
Limitation: rule-based approach. Not semantic NLP. A single comment may be counted in multiple clusters.
Each survey answer (Likert, frequency, percentage of time, incident count) is mapped to a 1–5 scale where 5 = excellent, 1 = critical. "N/A or do not know" answers are excluded from the mean calculation (do not penalise the supplier).
Pillar scores are simple arithmetic means. Overall Score is the mean of the valid pillar scores.
Supplier names are normalized before aggregation: lowercase, removal of punctuation, corporate suffixes (Inc, LLC, Ltd, Corp...). The canonical name displayed is the most-frequent variant.
Current effect: 1 supplier deduplicated (Langan Engineering) → 36 → 35 unique suppliers.
The embedded file includes 78 work email addresses of supplier contacts. Classification: Amazon-Internal. Do not distribute externally.
This report does not replace the official SBR documentation archived in SharePoint, which remains the primary source for SOC2 audits.
Executive Edition. Complete restyling in JP Morgan / Bloomberg Terminal style: restricted three-color data palette, tabular-nums typography, methodological description on every chart, structured Documentation tab. All emojis and decorative effects removed. English-only formal language.
Tableau-style redesign with vertical sections, KPI with semantic border-left, sub-tabs Pillar/Supplier/Comments/Actions.
Filter system rewrite with single source of truth and active filter pill bar.
See docs/CHANGELOG.md for detail of all earlier versions.
SRM Program Owner: Adora Loh, DCPG Program Manager — lohador@
Dashboard developer: Lorenzo Pupo — lorepupo@
Program references:
SRM Wiki,
SBR Process,
Smartsheet Analytics