Why advanced routing handles high-speed signals in PCB Design - Business Case Study

Scenario Mode

👤 Your Role: You are a PCB design analyst at an electronics manufacturing company.

📋 Request: Your manager wants a report explaining why advanced routing techniques are important for handling high-speed signals in PCB design.

📊 Data: You have data on signal integrity issues, routing methods, and their impact on signal speed and quality from recent PCB projects.

🎯 Deliverable: Create a dashboard report that shows how advanced routing improves signal quality and reduces errors in high-speed PCB designs.

Sample Data

Routing Method	Signal Speed (MHz)	Signal Integrity Score (0-100)	Error Rate (%)
Basic Routing	100	70	5
Basic Routing	200	60	8
Basic Routing	400	50	12
Advanced Routing	100	85	2
Advanced Routing	200	80	3
Advanced Routing	400	75	5

1

Step 1: Create a pivot table with Rows = Routing Method, Columns = Signal Speed (MHz), Values = Average Signal Integrity Score

Use pivot table tool: Rows=Routing Method, Columns=Signal Speed, Values=Average of Signal Integrity Score

Expected Result

Pivot table showing higher average Signal Integrity Scores for Advanced Routing at all speeds

2

Step 2: Create a pivot table with Rows = Routing Method, Columns = Signal Speed (MHz), Values = Average Error Rate (%)

Use pivot table tool: Rows=Routing Method, Columns=Signal Speed, Values=Average of Error Rate

Expected Result

Pivot table showing lower average Error Rates for Advanced Routing at all speeds

3

Step 3: Create a line chart with X-axis = Signal Speed (MHz), Y-axis = Signal Integrity Score, Lines = Routing Method

Configure line chart: X=Signal Speed, Y=Signal Integrity Score, Series=Routing Method

Expected Result

Line chart showing Advanced Routing maintains higher Signal Integrity Scores as speed increases

4

Step 4: Create a line chart with X-axis = Signal Speed (MHz), Y-axis = Error Rate (%), Lines = Routing Method

Configure line chart: X=Signal Speed, Y=Error Rate, Series=Routing Method

Expected Result

Line chart showing Advanced Routing has lower Error Rates as speed increases

5

Step 5: Summarize findings in a report section explaining how advanced routing reduces signal degradation and errors at high speeds

Write summary text based on data visualizations and pivot tables

Expected Result

Clear explanation that advanced routing techniques improve signal integrity and reduce errors, especially at higher frequencies

Final Result

Signal Integrity Score vs Speed

Speed(MHz) 100   200   400
Basic      70----60----50
Advanced   85----80----75

Error Rate (%) vs Speed

Speed(MHz) 100   200   400
Basic      5-----8-----12
Advanced   2-----3-----5

✓Advanced routing consistently achieves higher signal integrity scores than basic routing at all tested speeds.

✓Error rates increase with signal speed for both methods, but advanced routing keeps errors significantly lower.

✓Advanced routing reduces signal degradation and noise, which is critical for maintaining performance in high-speed PCB designs.

Bonus Challenge

Add a calculated measure to show the percentage improvement in signal integrity score of advanced routing over basic routing at each speed.

Show Hint

Create a new column or measure: ((Advanced Routing Score - Basic Routing Score) / Basic Routing Score) * 100