Prompt UsedFetch the defective products data from my Qlik app and build a standalone HTML dashboard with KPIs, charts, and styled visuals.
SAP Procurement Intelligence · Live Analysis
Defective Products Dashboard
Source: SAP BW · Global Holding Company · Jul 2016 – Jun 2020
Generated · March 2026
1,713 Vendors Tracked
52 Plant Locations
48 Monthly Periods
Total Defects
293,630
units across all periods
↓ Declining Trend
01
Defect Rate
0.22%
of total goods received
Within Threshold
02
Cost of Defects
€146.7M
total financial exposure
High Impact
03
Improvement
~50%
reduction since 2016 peak
↑ Positive Trend
04
Monthly Defect Volume & Cost
Jul 2016 – Jun 2020 · Actual data
Trend
Top Vendors by Defects
Ranked by total defect count
Risk
📈
Forecast Model · Linear Regression with Seasonal Decomposition
Based on 48 months of actuals (Jul 2016–Jun 2020), a linear regression trend was fitted and extended 12 months forward (Jul 2020–Jun 2021). The model captures the sustained ~50% decline trajectory. Confidence interval: ±15% (P80).
Defect Forecast — Jul 2020 to Jun 2021
Actuals (solid) + 12-month projection (dashed) with confidence band
Forecast
~3,200
Forecast Avg / Month
~38,400
Projected 12-Month Total
~8%
Further Decline Expected
Cost by Plant
Top 8 locations
Geography
Defects by Year
Annual aggregation
YoY
Cost vs Defects
Monthly correlation
Correlation
All data, outputs, and examples presented on this site are based on demo datasets for illustrative purposes only. No real customer, vendor, or business data is represented.