Revolved boss/base 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 the use of the Revolved Boss/Base feature in SolidWorks affects the production time and cost of parts.

📊 Data: You have data on parts designed with and without the Revolved Boss/Base feature, including design time (hours), production time (hours), and cost ($).

🎯 Deliverable: Create a dashboard that compares average design time, production time, and cost for parts using Revolved Boss/Base versus parts that do not.

Sample Data

Part ID	Uses Revolved Boss/Base	Design Time (hours)	Production Time (hours)	Cost ($)
101	Yes	3.5	5.0	120
102	No	4.0	6.5	150
103	Yes	3.0	4.5	110
104	No	4.5	7.0	160
105	Yes	3.8	5.2	130
106	No	4.2	6.8	155
107	Yes	3.6	5.1	125
108	No	4.3	7.2	165

1

Step 1: Load the data into your BI tool and create a new report.

Import the sample data table with columns: Part ID, Uses Revolved Boss/Base, Design Time, Production Time, Cost.

Expected Result

Data table loaded with 8 rows and 5 columns.

2

Step 2: Create a calculated measure to find the average Design Time grouped by 'Uses Revolved Boss/Base'.

Average Design Time = AVERAGE('Table'[Design Time (hours)]) grouped by 'Uses Revolved Boss/Base'

Expected Result

Average Design Time for 'Yes' = 3.475 hours, for 'No' = 4.25 hours.

3

Step 3: Create a calculated measure to find the average Production Time grouped by 'Uses Revolved Boss/Base'.

Average Production Time = AVERAGE('Table'[Production Time (hours)]) grouped by 'Uses Revolved Boss/Base'

Expected Result

Average Production Time for 'Yes' = 4.96 hours, for 'No' = 6.875 hours.

4

Step 4: Create a calculated measure to find the average Cost grouped by 'Uses Revolved Boss/Base'.

Average Cost = AVERAGE('Table'[Cost ($)]) grouped by 'Uses Revolved Boss/Base'

Expected Result

Average Cost for 'Yes' = $121.25, for 'No' = $157.5.

5

Step 5: Build a dashboard with three bar charts side by side: one for average Design Time, one for average Production Time, and one for average Cost. Each chart should compare 'Yes' and 'No' for 'Uses Revolved Boss/Base'.

Configure bar charts with X-axis = 'Uses Revolved Boss/Base' (Yes/No), Y-axis = respective average measure.

Expected Result

Dashboard shows clear visual comparison: parts using Revolved Boss/Base have lower design time, production time, and cost.

6

Step 6: Add clear titles and labels to each chart and ensure color contrast for accessibility.

Title each chart: 'Average Design Time by Revolved Boss/Base', 'Average Production Time by Revolved Boss/Base', 'Average Cost by Revolved Boss/Base'. Use distinct colors for Yes and No with sufficient contrast.

Expected Result

Dashboard is easy to read and accessible.

Final Result

-------------------------------------------------------------
|                 Revolved Boss/Base Analysis                 |
-------------------------------------------------------------
| Average Design Time (hours) | Average Production Time (hours)| Average Cost ($) |
|----------------------------|-------------------------------|-----------------|
| Yes: 3.48                  | Yes: 4.96                     | Yes: 121.25     |
| No: 4.25                   | No: 6.88                      | No: 157.50      |
-------------------------------------------------------------

✓Parts designed using the Revolved Boss/Base feature take about 0.77 hours less in design time on average.

✓Production time is reduced by nearly 1.92 hours on average for parts using Revolved Boss/Base.

✓Average cost is about $36.25 lower for parts designed with Revolved Boss/Base.

✓Using Revolved Boss/Base improves efficiency and reduces cost in part manufacturing.

Bonus Challenge

Add a time trend analysis showing how the use of Revolved Boss/Base affects design and production time over the last 12 months.

Show Hint

Include a date column in your data and create line charts grouped by month and 'Uses Revolved Boss/Base'. Use filters to compare trends.