Multi-brand design systems in Figma - Real Business Scenario

Scenario Mode

👤 Your Role: You are a product designer at a company managing multiple brands.

📋 Request: Your manager wants a report showing how design components are reused across different brands to improve efficiency and consistency.

📊 Data: You have data on design components used in each brand, including component name, brand name, usage count, and last update date.

🎯 Deliverable: Create a dashboard that shows component reuse by brand, highlights the most reused components, and tracks update frequency.

Sample Data

Component Name	Brand	Usage Count	Last Update
Button Primary	Brand A	120	2024-05-10
Button Primary	Brand B	95	2024-04-22
Card Layout	Brand A	80	2024-03-15
Card Layout	Brand C	60	2024-05-01
Icon Set	Brand B	150	2024-05-05
Icon Set	Brand C	130	2024-04-28
Typography Heading	Brand A	200	2024-05-12
Typography Heading	Brand B	180	2024-05-08
Typography Heading	Brand C	170	2024-05-09

1

Step 1: Import the design components data into your BI tool.

Load the table with columns: Component Name, Brand, Usage Count, Last Update.

Expected Result

Data table with 9 rows loaded correctly.

2

Step 2: Create a pivot table to summarize total usage count by Component Name and Brand.

Rows = Component Name; Columns = Brand; Values = SUM of Usage Count.

Expected Result

Pivot table showing usage counts per component per brand.

3

Step 3: Add a calculated measure to find total usage count per component across all brands.

Total Usage = SUM(Usage Count) grouped by Component Name.

Expected Result

New column showing total usage per component.

4

Step 4: Create a bar chart showing total usage count per component, sorted descending.

X-axis = Component Name; Y-axis = Total Usage; Sort by Total Usage descending.

Expected Result

Bar chart highlighting most reused components.

5

Step 5: Create a table showing the latest update date per component and brand.

Use MAX aggregation on Last Update grouped by Component Name and Brand.

Expected Result

Table showing most recent update dates for each component in each brand.

6

Step 6: Build a dashboard combining the pivot table, bar chart, and update date table.

Arrange visuals with clear titles and legends; ensure color contrast and accessibility.

Expected Result

Dashboard showing component reuse and update frequency across brands.

Final Result

Typography Heading

↓

Icon Set

↓

Button Primary

↓

Card Layout

Bonus Challenge

Add a trend analysis showing how usage counts for each component have changed over the last 6 months.

Show Hint

Use time series data with monthly usage counts and create line charts per component.