Why sketching is the foundation in Solidworks - Dashboard Impact

Dashboard Mode - Why sketching is the foundation

Business Question

How does sketching impact the success and efficiency of 3D modeling projects in SolidWorks?

Sample Data: Project Sketching and Modeling Metrics

Project	Sketches Created	Sketch Errors	Modeling Time (hrs)	Rework Time (hrs)	Final Quality Score (out of 10)
Alpha	15	2	20	5	8
Beta	10	5	25	10	6
Gamma	18	1	18	3	9
Delta	12	4	22	7	7
Epsilon	20	0	15	2	10

Dashboard Components

• KPI Card: Average Sketch Errors
  Formula: Average Sketch Errors = AVERAGE('Sketch Errors')
  Result: (2+5+1+4+0)/5 = 2.4
• KPI Card: Average Modeling Time
  Formula: Average Modeling Time = AVERAGE('Modeling Time (hrs)')
  Result: (20+25+18+22+15)/5 = 20 hrs
• Bar Chart: Sketches Created vs. Rework Time
  X-axis: Project
  Y-axis: Two bars per project: Sketches Created and Rework Time (hrs)
  This shows how more sketches with fewer errors reduce rework time.
• Scatter Plot: Sketch Errors vs. Final Quality Score
  X-axis: Sketch Errors
  Y-axis: Final Quality Score
  Shows negative correlation: fewer errors lead to higher quality.
• Table: Detailed Project Metrics
  Shows all columns from sample data for reference.

Dashboard Layout

+----------------------+----------------------+
| Average Sketch Errors | Average Modeling Time |
+----------------------+----------------------+
|                                              |
|   Bar Chart: Sketches Created vs Rework Time  |
|                                              |
+----------------------+----------------------+
| Scatter Plot: Sketch Errors vs Quality Score  |
+----------------------+----------------------+
|           Detailed Project Metrics Table      |
+----------------------------------------------+

Interactivity

A project filter dropdown allows selecting one or multiple projects. When a project is selected, all KPIs, charts, and the table update to show data only for those projects. This helps focus on specific projects to analyze sketching impact.

Self Check

If you add a filter to show only projects with zero or one sketch error, which components update and how?

• Average Sketch Errors KPI will show a lower average.
• Average Modeling Time KPI will update to reflect selected projects.
• Bar Chart will show sketches created and rework time only for filtered projects.
• Scatter Plot will show points only for projects with low sketch errors, likely showing higher quality scores.
• Table will list only the filtered projects.

Key Result

This dashboard shows how sketching quality affects modeling time, rework, and final quality in SolidWorks projects.