CommandManager and toolbars in Solidworks - Real Business Scenario

Scenario Mode

👤 Your Role: You are a product engineer at a manufacturing company using SolidWorks.

📋 Request: Your manager wants a report showing how frequently different CommandManager tabs and toolbars are used by the design team over the last month.

📊 Data: You have usage logs that record each time a user clicks a CommandManager tab or toolbar button, including the user name, date, and the name of the tab or toolbar used.

🎯 Deliverable: Create a dashboard that shows total clicks per CommandManager tab and toolbar, trends over the month, and highlights the most and least used features.

Sample Data

User	Date	Feature Type	Feature Name	Clicks
Alice	2024-05-01	CommandManager Tab	Features	5
Bob	2024-05-01	Toolbar	Sketch Tools	3
Alice	2024-05-02	CommandManager Tab	Evaluate	2
Charlie	2024-05-02	Toolbar	View Tools	4
Bob	2024-05-03	CommandManager Tab	Features	6
Alice	2024-05-03	Toolbar	Sketch Tools	7
Charlie	2024-05-04	CommandManager Tab	Surfaces	1
Bob	2024-05-04	Toolbar	View Tools	5
Alice	2024-05-05	CommandManager Tab	Evaluate	3
Charlie	2024-05-05	Toolbar	Sketch Tools	2
Bob	2024-05-06	CommandManager Tab	Features	4
Alice	2024-05-06	Toolbar	View Tools	6

1

Step 1: Import the usage log data into your BI tool.

Load the table with columns: User, Date, Feature Type, Feature Name, Clicks.

Expected Result

Data table with 12 rows loaded for analysis.

2

Step 2: Create a measure to calculate total clicks per Feature Name.

Total Clicks = SUM(Clicks)

Expected Result

Measure that sums clicks for each feature.

3

Step 3: Create a pivot table with rows as Feature Name, columns as Feature Type, values as Total Clicks.

Rows = Feature Name, Columns = Feature Type, Values = Total Clicks

Expected Result

Pivot table showing total clicks by feature and type.

4

Step 4: Create a line chart showing daily total clicks over the month.

Axis = Date, Values = SUM(Clicks)

Expected Result

Line chart showing click trends by date.

5

Step 5: Highlight the most and least used CommandManager tabs and toolbars using conditional formatting.

Apply color scale on Total Clicks measure in pivot table.

Expected Result

Dashboard highlights features with highest and lowest usage.

6

Step 6: Add slicers to filter by User and Feature Type for interactive analysis.

Add slicers for User and Feature Type fields.

Expected Result

User can filter dashboard by user or feature type.

Final Result

CommandManager and Toolbars Usage Dashboard

+----------------------+----------------+------------+
| Feature Name         | CommandManager | Toolbar    |
+----------------------+----------------+------------+
| Features             | 15             |            |
| Evaluate             | 5              |            |
| Surfaces             | 1              |            |
| Sketch Tools         |                | 12         |
| View Tools           |                | 15         |
+----------------------+----------------+------------+

Daily Clicks Trend (May 1 - May 6):
2024-05-01: 8 clicks
2024-05-02: 6 clicks
2024-05-03: 13 clicks
2024-05-04: 6 clicks
2024-05-05: 5 clicks
2024-05-06: 10 clicks

Most used: View Tools (15 clicks), Features tab (15 clicks)
Least used: Surfaces tab (1 click)

✓The 'Features' CommandManager tab and 'View Tools' toolbar are the most frequently used features.

✓The 'Surfaces' tab is the least used among CommandManager tabs.

✓Usage peaks on May 3 with 13 clicks and dips on May 5 with 5 clicks.

✓Users tend to use both CommandManager tabs and toolbars actively, with some variation by feature.

Bonus Challenge

Create a heatmap calendar visualization showing daily usage intensity for each CommandManager tab and toolbar.

Show Hint

Use a matrix visual with dates on one axis and features on the other, color-coded by total clicks.