Ordering PCBs from fabricators in PCB Design - Dashboard Guide

Dashboard Mode - Ordering PCBs from fabricators

Goal

Understand the status and costs of PCB orders from different fabricators to manage production efficiently.

Sample Data

Order ID	Fabricator	PCB Type	Quantity	Unit Cost ($)	Order Date	Status
1001	FabTech	Type A	500	2.50	2024-05-01	Delivered
1002	PCBWorks	Type B	300	3.00	2024-05-03	In Production
1003	FabTech	Type C	200	4.00	2024-05-05	Pending
1004	QuickPCB	Type A	400	2.75	2024-05-02	Delivered
1005	PCBWorks	Type C	150	4.10	2024-05-06	In Production
1006	QuickPCB	Type B	350	3.10	2024-05-04	Pending

Dashboard Components

• Total Orders: Count of all orders.
  Formula: COUNT(Order ID)
  Result: 6
• Total Quantity Ordered: Sum of Quantity.
  Formula: SUM(Quantity)
  Result: 1900
• Total Cost: Sum of Quantity * Unit Cost.
  Formula: SUMX(Orders, Quantity * Unit Cost)
  Calculation:
  (500*2.50)+(300*3.00)+(200*4.00)+(400*2.75)+(150*4.10)+(350*3.10)=
  1250 + 900 + 800 + 1100 + 615 + 1085 = 5750
• Orders by Fabricator: Bar chart showing count of orders per fabricator.
  Data:
  FabTech: 2
  PCBWorks: 2
  QuickPCB: 2
• Order Status Distribution: Pie chart showing percentage of orders by status.
  Delivered: 2 (33%)
  In Production: 2 (33%)
  Pending: 2 (33%)
• Recent Orders Table: Table showing Order ID, Fabricator, PCB Type, Quantity, Unit Cost, Order Date, Status sorted by Order Date descending.

Dashboard Layout

+----------------------+-----------------------+
| Total Orders (KPI)   | Total Quantity (KPI)  |
+----------------------+-----------------------+
| Total Cost (KPI)                          |
+------------------------------------------+
| Orders by Fabricator (Bar Chart)          |
+------------------------------------------+
| Order Status Distribution (Pie Chart)     |
+------------------------------------------+
| Recent Orders Table                        |
+------------------------------------------+

Interactivity

Filter by Fabricator or Status using slicers. Selecting a fabricator updates all KPIs, charts, and the recent orders table to show only that fabricator's orders. Selecting a status filters the dashboard to show orders with that status only.

Self Check

If you add a filter for Fabricator = "FabTech", which components update and what changes?

• Total Orders: updates to 2
• Total Quantity Ordered: updates to 700 (500 + 200)
• Total Cost: updates to 2050 (500*2.50 + 200*4.00)
• Orders by Fabricator: bar chart highlights FabTech only
• Order Status Distribution: shows only FabTech orders status distribution
• Recent Orders Table: shows only FabTech orders

Key Result

Dashboard showing PCB order counts, quantities, costs, and status by fabricator.