Scenario Mode

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

📋 Request: Your manager wants you to analyze the power integrity of the PCB to ensure stable voltage supply and minimize noise.

📊 Data: You have voltage measurements at various test points on the PCB under different load conditions, along with timestamps and load current values.

🎯 Deliverable: Create a report with charts showing voltage stability over time, identify any voltage drops or noise spikes, and provide recommendations to improve power integrity.

Progress0 / 8 steps

Sample Data

Timestamp	Test Point	Voltage (V)	Load Current (A)
10:00	TP1	3.3	0.5
10:00	TP2	3.28	0.5
10:05	TP1	3.25	1.0
10:05	TP2	3.22	1.0
10:10	TP1	3.20	1.5
10:10	TP2	3.18	1.5
10:15	TP1	3.15	2.0
10:15	TP2	3.10	2.0
10:20	TP1	3.12	2.5
10:20	TP2	3.08	2.5

1

Step 1: Load the data into your BI tool and create a table visualization showing Timestamp, Test Point, Voltage, and Load Current.

Use the raw data as is for initial inspection.

Expected Result

2

Step 2: Create a line chart with Timestamp on the X-axis and Voltage on the Y-axis. Use Test Point as the legend to show separate lines for TP1 and TP2.

Configure line chart: X=Timestamp, Y=Voltage, Legend=Test Point.

Expected Result

3

Step 3: Add Load Current as a secondary Y-axis on the same chart to see how voltage changes relate to load current.

Configure secondary Y-axis for Load Current with same X-axis (Timestamp).

Expected Result

4

Step 4: Calculate the voltage drop at each test point by subtracting the minimum voltage from the maximum voltage over the time period.

Create measure: Voltage Drop = MAX(Voltage) - MIN(Voltage) grouped by Test Point.

Expected Result

5

Step 5: Create a bar chart showing voltage drop for each test point.

Configure bar chart: X=Test Point, Y=Voltage Drop measure.

Expected Result

6

Step 6: Identify any noise spikes by calculating the difference between consecutive voltage readings at each test point.

Create measure: Voltage Change = Voltage at current timestamp - Voltage at previous timestamp, grouped by Test Point.

Expected Result

7

Step 7: Create a scatter plot with Timestamp on X-axis and Voltage Change on Y-axis, with Test Point as legend.

Configure scatter plot: X=Timestamp, Y=Voltage Change, Legend=Test Point.

Expected Result

8

Step 8: Summarize findings in a report: voltage drops increase with load current, TP2 shows slightly worse power integrity, and minor noise spikes occur at higher loads.

Write summary text based on visualizations and calculations.

Expected Result

Final Result

Power Integrity Report

Timestamp  | TP1 Voltage | TP2 Voltage | Load Current
-----------------------------------------------------
10:00     | 3.3 V       | 3.28 V      | 0.5 A
10:05     | 3.25 V      | 3.22 V      | 1.0 A
10:10     | 3.20 V      | 3.18 V      | 1.5 A
10:15     | 3.15 V      | 3.10 V      | 2.0 A
10:20     | 3.12 V      | 3.08 V      | 2.5 A

Voltage Drop (V): TP1=0.18, TP2=0.20

Observations:
- Voltage decreases as load current increases.
- TP2 has slightly higher voltage drop than TP1.
- Minor voltage noise spikes detected at 10:15.

Recommendations:
- Improve power delivery network at TP2.
- Add decoupling capacitors to reduce noise.
- Monitor voltage under peak loads.

✓Voltage at both test points drops as load current increases.

✓Test Point 2 (TP2) experiences a slightly higher voltage drop than TP1.

✓Small voltage noise spikes appear at higher load currents, especially around 10:15.

✓Improving power delivery and adding noise reduction components can enhance power integrity.

Bonus Challenge

Create a DAX measure or equivalent formula to calculate the average voltage for each test point during load currents above 1.5 A.

Show Hint