From Excel to Web Tool: A Product Design Case Study
Transforming manual hardware selection into an intelligent, user-friendly digital experience that saves time and eliminates costly errors.
My Role
Product Manager
Strategic Leadership
Led the end-to-end development of an innovative motherboard compatibility tool, replacing complex manual processes with streamlined digital verification.
Cross-Functional Coordination
Orchestrated collaboration across UX designers, engineering teams, quality assurance specialists, and marketing stakeholders to deliver a cohesive product.
User-Centric Focus
Championed a design-first approach to transform how hardware professionals and enthusiasts verify component compatibility across the entire product ecosystem.
Pain Point
Manual Compatibility Checking
Hardware professionals faced significant challenges with outdated verification methods that created bottlenecks and errors throughout the selection process.
100+
Motherboard Models
Tracked across sprawling Excel spreadsheets with 50+ chassis combinations
30
Minutes Per Query
Average time spent on each customer compatibility enquiry
15%
Error Rate
Manual mismatches leading to costly returns and frustrated customers
Desktop-only Excel lookups meant zero mobile accessibility for technicians working on-site or away from their primary workstations.
Research
User Pain Points & Market Gaps
Discovery Phase
Conducted comprehensive interviews with 10 hardware technicians, PC builders, Purchasing Specialist to understand real-world workflows and friction points.
Key Findings
Outdated Methods
80% of professionals still relied on spreadsheets for compatibility verification
Market Gap
No comprehensive, easy-to-use search tool existed in the market
Critical Need
Fast, accurate verification for CPUs, GPUs, RAM, and chipsets
Solution
Live Kontron Demo
01
Advanced Filters
02
Compatibility Badges
03
Detailed Preview
The solution bridges the gap between technical complexity and user accessibility, transforming hours of manual verification into seconds of automated matching.
Wireframe
User Journey Snapshot
INTERACTION PATTERNS
① Kontron Exclusive
Only for kontron MB for B to B application
Reduces user input time by 80%
② Hierarchical Filtering
Form Factor selection cascades to motherboard options
Invalid combinations —> "0 result"
③ Real-time Results
10-20 products load in <1 second
Status badges (NEW/UPCOMING) instant recognition
④ Inline Details
Detail page to explore more
Easily to share
Results
Impact & Metrics
The compatibility tool delivered measurable improvements across efficiency, accuracy, and user satisfaction, validating our user-centric design approach.
60%
Time Reduction
Users complete searches faster than Excel-based methods, validated through controlled testing
95%
Match Accuracy
Compatibility predictions verified by hardware experts across diverse configurations
4.7
User Satisfaction
Average rating from pilot users, indicating strong product-market fit