Circle and arc tools in Solidworks - Real Business Scenario

Scenario Mode

👤 Your Role: You are a product designer using SolidWorks CAD software.

📋 Request: Your manager wants a report showing how often circle and arc tools are used in recent design projects to understand design complexity.

📊 Data: You have a dataset listing design projects with counts of different tool usages including circle and arc tools.

🎯 Deliverable: Create a dashboard showing total usage counts of circle and arc tools per project and overall trends.

Sample Data

ProjectID	ProjectName	CircleToolCount	ArcToolCount	OtherToolCount
101	Gear Assembly	15	8	20
102	Valve Design	10	12	18
103	Bracket Model	5	3	10
104	Engine Block	20	15	25
105	Pipe Layout	8	10	12
106	Chassis Frame	12	7	15
107	Wheel Hub	18	9	22
108	Control Panel	7	5	14

1

Step 1: Load the project usage data into your BI tool.

Import the table with columns: ProjectID, ProjectName, CircleToolCount, ArcToolCount, OtherToolCount.

Expected Result

Data table with 8 projects and tool usage counts loaded.

2

Step 2: Create a calculated measure for Total Circle and Arc Tool Usage per project.

TotalCircleArcUsage = CircleToolCount + ArcToolCount

Expected Result

A new column showing sum of CircleToolCount and ArcToolCount for each project.

3

Step 3: Build a bar chart with ProjectName on X-axis and TotalCircleArcUsage on Y-axis.

Configure bar chart: X-axis = ProjectName, Y-axis = TotalCircleArcUsage (sum).

Expected Result

Bar chart showing total circle and arc tool usage per project.

4

Step 4: Create a card visual showing overall total usage of circle and arc tools across all projects.

OverallTotal = SUM(CircleToolCount) + SUM(ArcToolCount)

Expected Result

Card visual displays total count of circle and arc tool usage combined.

5

Step 5: Add a line chart showing trend of circle and arc tool usage by project ID (assuming project ID order reflects timeline).

Line chart with X-axis = ProjectID, Y-axis = TotalCircleArcUsage

Expected Result

Line chart showing how circle and arc tool usage changes across projects.

6

Step 6: Format all visuals with clear titles, axis labels, and color coding for accessibility.

Set titles: 'Total Circle and Arc Tool Usage by Project', 'Overall Total Usage', 'Usage Trend by Project'. Use high contrast colors and readable fonts.

Expected Result

Dashboard visuals are clear, accessible, and easy to understand.

Final Result

---------------------------------------------
| Total Circle and Arc Tool Usage by Project |
|-------------------------------------------|
| Gear Assembly   | ██████████████ (23)     |
| Valve Design    | █████████████ (22)      |
| Bracket Model   | ██████ (8)              |
| Engine Block    | ██████████████████ (35) |
| Pipe Layout     | ███████████ (18)        |
| Chassis Frame   | ███████████ (19)        |
| Wheel Hub       | ███████████████ (27)    |
| Control Panel   | ███████ (12)            |
---------------------------------------------

Overall Total Usage: 164

Usage Trend by Project (ProjectID vs Total Usage):
101 - 23
102 - 22
103 - 8
104 - 35
105 - 18
106 - 19
107 - 27
108 - 12

✓Engine Block project has the highest combined usage of circle and arc tools (35).

✓Bracket Model project uses the least circle and arc tools (8).

✓Overall, circle and arc tools are heavily used across all projects, totaling 164 uses.

✓Usage trend shows some fluctuation but generally high usage in mid to later projects.

Bonus Challenge

Create a report that breaks down circle and arc tool usage separately and compares their proportions per project.

Show Hint

Use stacked bar charts with CircleToolCount and ArcToolCount as separate series to visualize proportions.