Draft angle feature in Solidworks - Real Business Scenario

Scenario Mode

👤 Your Role: You are a product design analyst at a manufacturing company.

📋 Request: Your manager wants a report showing how draft angles on parts affect manufacturing efficiency and defect rates.

📊 Data: You have data on parts with their draft angles, production time in hours, and number of defects per batch.

🎯 Deliverable: Create a dashboard that visualizes the relationship between draft angle and production efficiency, highlighting trends and key insights.

Sample Data

Part ID	Draft Angle (degrees)	Production Time (hours)	Defects per Batch
P001	0	10	5
P002	1	9	4
P003	2	8	3
P004	3	7	2
P005	4	6	1
P006	5	5	1
P007	6	5	0
P008	7	4	0

1

Step 1: Import the sample data into your BI tool.

Load columns: Part ID, Draft Angle (degrees), Production Time (hours), Defects per Batch.

Expected Result

Data table with 8 rows and 4 columns loaded correctly.

2

Step 2: Create a scatter plot with Draft Angle on the X-axis and Production Time on the Y-axis.

X-axis: Draft Angle (degrees), Y-axis: Production Time (hours).

Expected Result

Scatter plot showing production time decreasing as draft angle increases.

3

Step 3: Add a second scatter plot with Draft Angle on the X-axis and Defects per Batch on the Y-axis.

X-axis: Draft Angle (degrees), Y-axis: Defects per Batch.

Expected Result

Scatter plot showing defects decreasing as draft angle increases.

4

Step 4: Calculate the average Production Time and average Defects per Batch for draft angles grouped by 2-degree ranges.

Group draft angles: 0-1.99, 2-3.99, 4-5.99, 6-7.99; Calculate AVG(Production Time), AVG(Defects per Batch).

Expected Result

Table showing average production time and defects per batch for each draft angle group.

5

Step 5: Create a line chart showing average Production Time and average Defects per Batch by draft angle groups.

X-axis: Draft Angle Groups, Y-axis: Average Production Time and Average Defects per Batch (two lines).

Expected Result

Line chart showing both metrics decreasing as draft angle increases.

6

Step 6: Add titles, axis labels, and tooltips to all charts for clarity.

Title: 'Effect of Draft Angle on Production Efficiency'; X-axis label: 'Draft Angle (degrees)'; Y-axis labels: 'Production Time (hours)', 'Defects per Batch'.

Expected Result

Charts are clear, easy to understand, and accessible.

Final Result

Dashboard: Effect of Draft Angle on Production Efficiency

Draft Angle (degrees) -->

Production Time (hours)  |
10 | *
 9 |  *
 8 |   *
 7 |    *
 6 |     *
 5 |      **
 4 |       *
 3 |        
 2 |        
 1 |        
 0 | *

Defects per Batch       |
5  | *
4  |  *
3  |   *
2  |    *
1  |     **
0  |       **

Legend:
* = Data points or line markers

Summary:
- Production time and defects decrease as draft angle increases.
- Optimal draft angles reduce manufacturing time and defects.

✓Increasing the draft angle reduces production time from 10 to 4 hours.

✓Defects per batch decrease from 5 to 0 as draft angle increases.

✓Draft angles above 5 degrees show the best manufacturing efficiency.

Bonus Challenge

Add a filter to the dashboard to select parts by production time ranges and observe how draft angle effects vary.

Show Hint

Use slicers or filter controls on production time and update charts dynamically.