Power symbols and ground connections in PCB Design - Real Business Scenario

Scenario Mode

👤 Your Role: You are an electronics design engineer working on a printed circuit board (PCB) layout.

📋 Request: Your manager wants a clear report showing how power symbols and ground connections are used across different PCB schematic sheets to ensure proper power distribution and grounding.

📊 Data: You have a dataset listing schematic sheets, components, their power symbols (like VCC, +5V, GND), and the number of ground connections per sheet.

🎯 Deliverable: Create a dashboard report summarizing power symbol usage and ground connection counts per schematic sheet, highlighting sheets with missing or inconsistent ground connections.

Sample Data

Schematic Sheet	Component	Power Symbol	Ground Connections
Sheet1	U1	VCC	2
Sheet1	U2	GND	2
Sheet2	U3	+5V	1
Sheet2	U4	GND	1
Sheet3	U5	VCC	0
Sheet3	U6	GND	0
Sheet4	U7	+3.3V	3
Sheet4	U8	GND	3

1

Step 1: Load the dataset into your BI tool and create a table view.

Import the data with columns: Schematic Sheet, Component, Power Symbol, Ground Connections.

Expected Result

A table showing all rows of components with their power symbols and ground connections.

2

Step 2: Create a summary table grouped by Schematic Sheet showing total ground connections.

Group by 'Schematic Sheet' and sum 'Ground Connections'.

Expected Result

Sheet1: 4, Sheet2: 2, Sheet3: 0, Sheet4: 6

3

Step 3: Create a count of distinct power symbols used per schematic sheet.

Group by 'Schematic Sheet' and count distinct 'Power Symbol'.

Expected Result

Sheet1: 2, Sheet2: 2, Sheet3: 2, Sheet4: 2

4

Step 4: Build a dashboard with two visuals: a bar chart for total ground connections per sheet and a table listing power symbols per sheet.

Bar chart: X-axis = Schematic Sheet, Y-axis = Sum of Ground Connections; Table: Schematic Sheet with list of Power Symbols.

Expected Result

Bar chart shows ground connection totals; table shows power symbols per sheet.

5

Step 5: Add a filter or highlight to identify sheets with zero ground connections.

Filter or conditional formatting where Sum of Ground Connections = 0.

Expected Result

Sheet3 is highlighted as having zero ground connections.

6

Step 6: Interpret the dashboard to find sheets with potential grounding issues.

Review highlighted sheets and low ground connection counts.

Expected Result

Sheet3 has no ground connections and may have grounding issues.

Final Result

Power Symbols and Ground Connections Dashboard

Schematic Sheets | Ground Connections
---------------------------------------
Sheet1           | ██████ 4
Sheet2           | ██ 2
Sheet3           |      0 <-- Check this sheet
Sheet4           | ██████████ 6

Power Symbols per Sheet:
Sheet1: VCC, GND
Sheet2: +5V, GND
Sheet3: VCC, GND
Sheet4: +3.3V, GND

✓Sheet3 has zero ground connections, indicating a possible grounding problem.

✓All sheets use at least two power symbols including ground.

✓Sheet4 has the highest number of ground connections, suggesting good grounding.

Bonus Challenge

Create a calculated measure that flags sheets where ground connections are less than the number of components using power symbols.

Show Hint

Use a formula comparing sum of ground connections to count of components per sheet.