Design review checklist in PCB Design - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Key Elements in a PCB Design Review Checklist

Which of the following is NOT typically included in a PCB design review checklist?

A Component placement and orientation verification

B Signal integrity and impedance matching checks

C Thermal management and heat dissipation analysis

D Marketing strategy for the PCB product

💡 Hint

Think about what is directly related to the technical quality and functionality of the PCB.

Marketing strategy is not part of the technical design review checklist. The checklist focuses on technical aspects like component placement, signal integrity, and thermal management.

❓ data_modeling

intermediate

Structuring a PCB Design Review Checklist in BI

You want to create a BI report that tracks the status of each item in a PCB design review checklist across multiple projects. Which data model structure is best suited for this?

A A flat table with columns: ProjectID, ChecklistItem, Status, Reviewer

B Separate tables for Projects, ChecklistItems, and ReviewStatus linked by keys

C A single table with all project details and checklist items as columns

D A table with only ProjectID and overall review score

💡 Hint

Consider normalization and flexibility for reporting on checklist items independently.

Using separate tables linked by keys allows better organization, easier updates, and more flexible reporting on checklist items and projects.

❓ dax_lod_result

advanced

Calculating Percentage of Completed Checklist Items

Given a table 'ReviewStatus' with columns: ProjectID, ChecklistItem, Status ('Complete' or 'Incomplete'), which DAX measure correctly calculates the percentage of completed checklist items for a selected project?

PCB Design

Percentage Complete = DIVIDE(
    CALCULATE(COUNTROWS(ReviewStatus), ReviewStatus[Status] = "Complete"),
    COUNTROWS(ReviewStatus)
)

A Percentage Complete = DIVIDE(CALCULATE(COUNTROWS(ReviewStatus), ReviewStatus[Status] = "Complete"), COUNTROWS(ReviewStatus))

B Percentage Complete = CALCULATE(COUNTROWS(ReviewStatus[Status] = "Complete")) / COUNTROWS(ReviewStatus)

C Percentage Complete = SUMX(ReviewStatus, IF(ReviewStatus[Status] = "Complete", 1, 0)) / COUNTROWS(ReviewStatus)

D Percentage Complete = COUNTROWS(FILTER(ReviewStatus, ReviewStatus[Status] = "Complete")) / COUNTROWS(ReviewStatus)

💡 Hint

Look for correct use of CALCULATE and COUNTROWS with filter conditions.

Option A uses CALCULATE with a filter on Status correctly and divides by total rows. Option A has syntax errors. Option A is missing CALCULATE and may not respect filter context. Option A uses SUMX but is less efficient.

❓ visualization

advanced

Best Visualization for PCB Design Review Progress

You want to show the progress of checklist completion for multiple PCB projects in a dashboard. Which visualization type is best to clearly compare progress across projects?

A Line chart showing checklist item completion over time for one project

B Pie chart showing overall completion percentage for all projects combined

C Stacked bar chart showing completed vs incomplete items per project

D Scatter plot showing project size vs number of checklist items

💡 Hint

Think about comparing parts of a whole across multiple categories.

A stacked bar chart allows easy comparison of completed and incomplete checklist items across multiple projects side by side.

🔧 Formula Fix

expert

Identifying Error in DAX Measure for Checklist Completion

Review the following DAX measure intended to calculate the count of incomplete checklist items per project:

Incomplete Count = COUNTROWS(FILTER(ReviewStatus, ReviewStatus[Status] = "Incomplete"))

What is the main issue with this measure when used in a report filtered by ProjectID?

A It ignores the current ProjectID filter and counts all incomplete items across projects

B It causes a syntax error due to missing CALCULATE function

C It returns the total number of checklist items instead of incomplete ones

D It double counts incomplete items if multiple filters are applied

💡 Hint

Consider how FILTER and context interact in DAX measures.

The FILTER function inside COUNTROWS does not automatically respect external filters like ProjectID. Without CALCULATE, the measure ignores the report filter context on ProjectID.