Component orientation conventions in PCB Design - Real Business Scenario

Scenario Mode

👤 Your Role: You are a PCB design engineer working on a new electronic device.

📋 Request: Your manager wants a report showing how component orientation conventions affect assembly efficiency and error rates.

📊 Data: You have data on various PCB assemblies showing component types, their orientation angles, assembly time in minutes, and number of orientation-related errors.

🎯 Deliverable: Create a dashboard that visualizes average assembly time and error rates by component orientation conventions to help improve the design process.

Sample Data

Component	Orientation_Angle	Assembly_Time_Minutes	Orientation_Errors
Resistor	0	5	0
Capacitor	90	7	1
IC	180	12	3
Diode	0	6	0
Resistor	90	6	1
Capacitor	0	5	0
IC	90	10	2
Diode	180	8	2
Resistor	180	7	1
Capacitor	180	9	2
IC	0	11	1
Diode	90	7	1

1

Step 1: Load the sample data into your BI tool as a table with columns: Component, Orientation_Angle, Assembly_Time_Minutes, Orientation_Errors.

Import data as is from the provided HTML table.

Expected Result

Data table with 12 rows and 4 columns loaded correctly.

2

Step 2: Create a calculated measure to find the average assembly time by orientation angle.

Average Assembly Time = AVERAGE('Table'[Assembly_Time_Minutes])

Expected Result

Measure that calculates average assembly time for any filtered orientation angle.

3

Step 3: Create a calculated measure to find the total orientation errors by orientation angle.

Total Orientation Errors = SUM('Table'[Orientation_Errors])

Expected Result

Measure that sums orientation errors for any filtered orientation angle.

4

Step 4: Build a bar chart with Orientation_Angle on the X-axis, Average Assembly Time on the Y-axis, and color bars by Component type.

Configure chart: X=Orientation_Angle, Y=Average Assembly Time, Legend=Component

Expected Result

Bar chart showing average assembly time by orientation angle and component.

5

Step 5: Build a line chart with Orientation_Angle on the X-axis and Total Orientation Errors on the Y-axis to show error trends.

Configure chart: X=Orientation_Angle, Y=Total Orientation Errors

Expected Result

Line chart showing how orientation errors vary by angle.

6

Step 6: Add slicers for Component type to filter the charts interactively.

Add slicer control for 'Component' column.

Expected Result

User can filter charts by selecting one or more component types.

7

Step 7: Review the dashboard to identify which orientation angles cause higher assembly times or errors.

Use visual insights from charts.

Expected Result

Clear understanding that 180 degrees orientation tends to have higher errors and assembly times.

Final Result

Orientation Angle Dashboard

Orientation Angle (degrees)
0     90    180

Average Assembly Time (minutes)
| Resistor: 6 | Capacitor: 7 | IC: 11 |
| Diode: 6    |               |          |

Total Orientation Errors
0: 1 error
90: 5 errors
180: 8 errors

Use slicer to select Component: [Resistor] [Capacitor] [IC] [Diode]

✓Components oriented at 180 degrees have the highest average assembly time and error rates.

✓Orientation at 0 degrees generally results in the fastest assembly and lowest errors.

✓IC components show more sensitivity to orientation changes compared to resistors or diodes.

✓Using consistent orientation conventions can reduce assembly errors and improve efficiency.

Bonus Challenge

Create a heatmap visualization showing the combined effect of component type and orientation angle on assembly time and errors.

Show Hint

Use a matrix visual with Component on rows, Orientation Angle on columns, and color scale representing average assembly time or error count.