1.Preparing Product Catalogs for ERP Onboarding
Waterfall Chart & Table · 2026
A product data manager utilized a waterfall chart and table to prepare a global product catalog for ERP onboarding. The analysis revealed that out of 44.9K raw catalog rows, 42.1K were duplicates removed, leaving 2.8K true unique variants, meaning 16.3 raw rows collapse into each surviving variant. The dashboard highlighted that missing attributes like "Best For" (38.7% fill rate) and "Subcategory" (66.4% fill rate) drove 98.0% of attribute gaps, while missing prices were not a blocker with 0 missing. A prioritized cleanup plan targeted the P1 93.9% duplicate rate, P2 27.5K missing "Best For" values, and P3 15.1K missing "Sub..." values to ensure clean data before managing backorders.
What it shows:
How to identify structural bloat and prioritize data cleanup for accurate inventory tracking.




