Ordering PCBs from fabricators in PCB Design - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Lead Time Impact on PCB Delivery

You are managing a PCB order with a fabricator. The fabricator states the lead time is 10 business days. If you place the order on a Wednesday, on which day will you expect the PCBs to arrive, assuming no holidays?

A The Wednesday two weeks later

B The following Friday (10 business days later)

C The Monday after 10 calendar days

D The second Friday after the order day

💡 Hint

Count only weekdays, excluding weekends.

Lead time counts business days. Starting Wednesday, 10 business days later lands on the Wednesday two weeks later.

❓ data_modeling

intermediate

Choosing Key Data Fields for PCB Order Tracking

Which set of data fields is most essential to track PCB orders effectively in a BI dashboard?

A Order ID, Fabricator Name, Order Date, Quantity, Delivery Date, Status

B Order ID, Customer Name, Payment Method, Delivery Address, Status

C Fabricator Name, Order Date, PCB Layer Count, Color, Status

D Order Date, Quantity, PCB Thickness, Delivery Address, Payment Method

💡 Hint

Focus on fields that track order progress and delivery.

Order ID, Fabricator Name, Order Date, Quantity, Delivery Date, and Status provide clear tracking of PCB orders and delivery status.

❓ dax_lod_result

advanced

Calculating Average Delivery Delay Using DAX

Given a table 'Orders' with columns 'OrderDate' and 'ActualDeliveryDate', which DAX measure correctly calculates the average delivery delay in days?

Average Delay = AVERAGEX(Orders, DATEDIFF(Orders[OrderDate], Orders[ActualDeliveryDate], DAY))

A Average Delay = AVERAGE(DATEDIFF(Orders[OrderDate], Orders[ActualDeliveryDate], DAY))

B Average Delay = AVERAGEX(Orders, DATEDIFF(Orders[OrderDate], Orders[ActualDeliveryDate], DAY))

C Average Delay = SUMX(Orders, Orders[ActualDeliveryDate] - Orders[OrderDate]) / COUNTROWS(Orders)

D Average Delay = CALCULATE(AVERAGE(Orders[ActualDeliveryDate] - Orders[OrderDate]))

💡 Hint

Use AVERAGEX to iterate row by row and calculate difference.

AVERAGEX iterates over each order calculating the date difference, then averages the results. Other options either misuse functions or produce errors.

❓ visualization

advanced

Best Visualization for PCB Order Status Overview

You want to show the current status distribution of PCB orders (e.g., Pending, In Production, Shipped, Delivered) on a dashboard. Which visualization type is best suited for this?

A Stacked bar chart showing counts per status

B Line chart showing status changes over time

C Pie chart showing percentage of orders per status

D Scatter plot showing order quantity vs. delivery time

💡 Hint

Think about showing parts of a whole clearly.

A pie chart clearly shows the proportion of orders in each status category at a glance, which is ideal for status distribution.

🔧 Formula Fix

expert

Identifying Error in DAX Measure for Total PCB Quantity

Review the following DAX measure intended to calculate total PCB quantity ordered:

Total Quantity = SUM(Orders[QuantityOrdered]) + SUM(Orders[QuantityShipped])

What is the main issue with this measure?

A SUM cannot be used on multiple columns in one expression

B It should use COUNT instead of SUM for quantities

C The measure syntax is invalid due to missing aggregation function

D It double counts quantities because QuantityOrdered and QuantityShipped overlap

💡 Hint

Consider what QuantityOrdered and QuantityShipped represent.

QuantityShipped is part of QuantityOrdered, so adding both sums counts shipped quantities twice.