What is your approach to designing data models for analytics?
Use the provided fact and dimension tables to demonstrate a concise analytics model and produce a product usage summary for Q1 2025.
product_id, product_name, total_events, active_users, and last_event_date.| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| product_id | INT | Product associated with the event |
| user_id | INT | User associated with the event |
| event_type | VARCHAR(40) | Recorded analytics event type |
| occurred_at | TIMESTAMP | Timestamp when the event occurred |
| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product display name |
| product_family | VARCHAR(60) | Product family or category |
| Column | Type | Description |
|---|---|---|
| user_idPK | INT | Unique user identifier |
| user_name | VARCHAR(100) | User display name |
| organization_name | VARCHAR(100) | User organization |