Schematic editor interface in PCB Design - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a report showing the usage frequency of different schematic components across recent projects to optimize component inventory.

📊 Data: You have data listing schematic components used in each project, including component type, project name, and quantity used.

🎯 Deliverable: Create a dashboard that shows total usage count per component type and highlights the top 3 most used components.

Sample Data

Project	Component Type	Quantity Used
Project A	Resistor	50
Project A	Capacitor	30
Project B	Resistor	40
Project B	Inductor	20
Project C	Capacitor	25
Project C	Diode	15
Project D	Resistor	60
Project D	Capacitor	35
Project E	Diode	10
Project E	Inductor	5

1

Step 1: Load the data into your BI tool with columns: Project, Component Type, Quantity Used.

Import the sample data table as is.

Expected Result

Data table with 10 rows loaded correctly.

2

Step 2: Create a measure to calculate total quantity used per component type.

Total Quantity = SUM('Table'[Quantity Used])

Expected Result

Measure that sums Quantity Used for each Component Type.

3

Step 3: Create a table visualization with rows as Component Type and values as Total Quantity measure.

Rows = Component Type; Values = Total Quantity

Expected Result

Table showing total quantity used per component type: Resistor=150, Capacitor=90, Inductor=25, Diode=25.

4

Step 4: Sort the table by Total Quantity in descending order to identify top components.

Sort by Total Quantity descending

Expected Result

Table sorted with Resistor first, then Capacitor, Inductor and Diode.

5

Step 5: Create a bar chart visualization showing Component Type on X-axis and Total Quantity on Y-axis.

X-axis = Component Type; Y-axis = Total Quantity

Expected Result

Bar chart visually showing usage counts with Resistor bar tallest.

6

Step 6: Highlight the top 3 components in the bar chart using a different color.

Apply conditional formatting: if rank <= 3 then color = highlight color

Expected Result

Top 3 components (Resistor, Capacitor, Inductor) bars highlighted.

7

Step 7: Add a title and labels to the dashboard for clarity and accessibility.

Title: 'Component Usage Frequency'; X-axis label: 'Component Type'; Y-axis label: 'Total Quantity Used'

Expected Result

Dashboard with clear title and axis labels.

Final Result

Component Usage Frequency Dashboard

Component Type | Total Quantity Used
-------------------------------------
Resistor       | █████████████████████ (150)
Capacitor      | ████████████          (90)
Inductor       | ████                  (25)
Diode          | ████                  (25)

Top 3 components are highlighted in bold bars.

✓Resistors are the most used component with 150 units across projects.

✓Capacitors are the second most used with 90 units.

✓Inductors and Diodes have equal usage of 25 units each.

✓Focus inventory management on Resistors and Capacitors for efficiency.

Bonus Challenge

Create a time trend line chart showing how component usage changes over projects ordered by date.

Show Hint

Add a Project Date column to your data and use a line chart with Project Date on X-axis and Total Quantity on Y-axis, filtered by Component Type.