Version control for PCB projects in PCB Design - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants a report showing how PCB project versions have changed over time, highlighting the number of changes per version and identifying the most active projects.

📊 Data: You have a dataset listing PCB projects with their version numbers, dates of version release, and the count of changes made in each version.

🎯 Deliverable: Create a dashboard that shows version history trends per project, total changes per project, and highlights the project with the most changes.

Sample Data

Project	Version	Release Date	Number of Changes
AlphaBoard	v1.0	2023-01-15	5
AlphaBoard	v1.1	2023-02-10	3
AlphaBoard	v2.0	2023-04-05	8
BetaCircuit	v1.0	2023-01-20	4
BetaCircuit	v1.2	2023-03-15	6
BetaCircuit	v2.0	2023-05-01	7
GammaChip	v1.0	2023-02-01	2
GammaChip	v1.1	2023-03-10	3
GammaChip	v1.2	2023-04-20	1

1

Step 1: Import the PCB version data into your BI tool.

Load the table with columns: Project, Version, Release Date, Number of Changes.

Expected Result

Data table with 9 rows loaded correctly.

2

Step 2: Create a line chart to show the number of changes over time for each project.

X-axis: Release Date; Y-axis: Number of Changes; Legend: Project.

Expected Result

Line chart showing change trends per project over release dates.

3

Step 3: Create a calculated measure to sum total changes per project.

Total Changes = SUM('Table'[Number of Changes]) grouped by Project.

Expected Result

Measure that shows total changes for each project.

4

Step 4: Create a bar chart showing total changes per project.

X-axis: Project; Y-axis: Total Changes measure.

Expected Result

Bar chart showing total changes for AlphaBoard, BetaCircuit, and GammaChip.

5

Step 5: Highlight the project with the highest total changes in the dashboard.

Identify project with MAX(Total Changes).

Expected Result

BetaCircuit is highlighted as the project with the most changes.

Final Result

#########

↓

###########

↓

###

✓BetaCircuit has the highest total number of changes (17) across versions.

✓AlphaBoard shows steady increase in changes with major jump at version 2.0.

✓GammaChip has fewer changes and smaller version updates.

Bonus Challenge

Add a filter to the dashboard to select a specific project and see its detailed version history and changes.

Show Hint

Use a slicer or dropdown filter on the Project field to dynamically update the charts.