Line and centerline tools in Solidworks - Real Business Scenario

Scenario Mode

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

📋 Request: Your manager wants you to analyze the use of line and centerline tools in SolidWorks drawings to improve clarity and accuracy in technical documentation.

📊 Data: You have access to a dataset of 10 SolidWorks drawing files with metadata on the number of lines, centerlines, and annotations used in each drawing.

🎯 Deliverable: Create a report with visualizations showing the average number of lines and centerlines per drawing, and identify any patterns or recommendations for best practices.

Sample Data

Drawing ID	Total Lines	Centerlines	Annotations
D001	120	15	30
D002	95	10	25
D003	130	20	35
D004	110	12	28
D005	105	14	27
D006	115	18	32
D007	100	11	26
D008	125	17	33
D009	90	9	22
D010	85	8	20

1

Step 1: Import the drawing metadata into your BI tool as a table with columns Drawing ID, Total Lines, Centerlines, and Annotations.

Load data from the provided sample_data HTML table into the BI tool's data model.

Expected Result

Data table with 10 rows and 4 columns loaded successfully.

2

Step 2: Create a calculated measure to find the average number of Total Lines per drawing.

Average Total Lines = AVERAGE('Drawings'[Total Lines])

Expected Result

Average Total Lines calculated as 107.5

3

Step 3: Create a calculated measure to find the average number of Centerlines per drawing.

Average Centerlines = AVERAGE('Drawings'[Centerlines])

Expected Result

Average Centerlines calculated as 13.4

4

Step 4: Create a bar chart visualization with Drawing ID on the x-axis and two bars per drawing showing Total Lines and Centerlines.

Configure bar chart: Axis = Drawing ID; Values = Total Lines, Centerlines

Expected Result

Bar chart showing Total Lines and Centerlines side by side for each drawing.

5

Step 5: Create a line chart showing the trend of Centerlines across drawings ordered by Drawing ID.

Configure line chart: Axis = Drawing ID; Values = Centerlines

Expected Result

Line chart showing Centerlines count trend across drawings.

6

Step 6: Add a card visualization showing the average number of Annotations per drawing.

Average Annotations = AVERAGE('Drawings'[Annotations])

Expected Result

Card showing average Annotations as 27.8

7

Step 7: Interpret the visualizations to identify if drawings with more centerlines have more annotations.

Create a scatter plot with Centerlines on x-axis and Annotations on y-axis to check correlation.

Expected Result

Scatter plot shows a positive correlation between Centerlines and Annotations.

8

Step 8: Summarize findings and recommend using centerline tools consistently to improve drawing clarity.

No formula; write summary based on visual insights.

Expected Result

Report summary stating that drawings with more centerlines tend to have more annotations, suggesting centerlines help clarify technical details.

Final Result

Drawing ID | Total Lines | Centerlines | Annotations
---------------------------------------------------
D001       | ██████████ 120 | ████ 15     | █████ 30
D002       | ████████ 95  | ██ 10       | ████ 25
D003       | ███████████ 130| █████ 20    | ██████ 35
...

Average Total Lines: 111.5
Average Centerlines: 13.4
Average Annotations: 27.8

[Bar Chart] [Line Chart] [Scatter Plot]

Key Insights:
- More centerlines relate to more annotations.
- Using centerline tools improves drawing clarity.

✓The average number of total lines per drawing is 111.5.

✓The average number of centerlines per drawing is 13.4.

✓Drawings with more centerlines tend to have more annotations, indicating better clarity.

✓Consistent use of centerline tools is recommended to improve technical drawing quality.

Bonus Challenge

Create a dashboard that dynamically filters drawings by the number of centerlines and shows updated averages and charts.

Show Hint

Use slicers or filters in your BI tool to allow interactive selection of drawings based on centerline count.