Manufacturing constraints awareness in PCB Design - Real Business Scenario

Scenario Mode

👤 Your Role: You are a PCB design engineer working closely with the manufacturing team.

📋 Request: Your manager wants a report that highlights which PCB designs meet manufacturing constraints and which do not, so the team can focus on fixing the problematic designs before production.

📊 Data: You have a dataset of PCB designs with columns: Design ID, Layer Count, Minimum Trace Width (mm), Minimum Hole Diameter (mm), and whether each design meets the manufacturing constraints for these parameters.

🎯 Deliverable: Create a dashboard showing the count of designs that pass and fail manufacturing constraints, and a detailed table listing designs with issues.

Sample Data

Design ID	Layer Count	Min Trace Width (mm)	Min Hole Diameter (mm)	Meets Constraints
D001	4	0.15	0.3	Yes
D002	6	0.1	0.25	No
D003	2	0.2	0.35	Yes
D004	8	0.08	0.2	No
D005	4	0.18	0.3	Yes
D006	6	0.12	0.22	No
D007	2	0.16	0.3	Yes
D008	4	0.14	0.28	Yes

1

Step 1: Load the PCB design data into your BI tool.

Import the table with columns: Design ID, Layer Count, Min Trace Width (mm), Min Hole Diameter (mm), Meets Constraints.

Expected Result

Data table with 8 rows loaded.

2

Step 2: Create a calculated measure to count how many designs meet manufacturing constraints.

Count of designs where 'Meets Constraints' = 'Yes'.

Expected Result

Count = 5

3

Step 3: Create a calculated measure to count how many designs do not meet manufacturing constraints.

Count of designs where 'Meets Constraints' = 'No'.

Expected Result

Count = 3

4

Step 4: Build a bar chart showing counts of designs passing and failing constraints.

Axis: 'Meets Constraints' (Yes/No), Values: Count of Design ID.

Expected Result

Bar chart with two bars: Yes=5, No=3.

5

Step 5: Create a table visual listing all designs that do not meet constraints with their details.

Filter data where 'Meets Constraints' = 'No', show Design ID, Layer Count, Min Trace Width, Min Hole Diameter.

Expected Result

Table with 3 rows: D002, D004, D006 and their details.

6

Step 6: Add a summary card showing total number of designs.

Count of all Design IDs.

Expected Result

Total designs = 8

Final Result

Bar Chart

↓

Table: Designs Failing Constraints

↓

Summary

✓5 out of 8 PCB designs meet manufacturing constraints.

✓3 designs (D002, D004, D006) fail due to trace width or hole diameter being below limits.

✓Focus on fixing these 3 designs to avoid manufacturing issues.

Bonus Challenge

Create a new measure that calculates the percentage of designs meeting constraints out of total designs.

Show Hint

Divide the count of designs meeting constraints by total designs, then multiply by 100.