What is your process for creating a dashboard that is both aesthetically pleasing and functional for non-technical stakeholders at WebMD Health?
For this SQL exercise, prepare a dashboard-ready summary from the provided WebMD Health surface and event data. Include active surfaces for the January 2025 reporting period, including surfaces with no recorded activity.
surface_name, total_sessions, page_views, engaged_sessions, and engagement_rate| Column | Type | Description |
|---|---|---|
| surface_idPK | INT | Unique identifier for a WebMD Health digital surface |
| surface_name | VARCHAR(100) | Display name of the dashboard surface |
| is_active | BOOLEAN | Whether the surface should appear in the dashboard |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique event identifier |
| surface_id | INT | Surface associated with the event |
| session_id | VARCHAR(30) | Anonymous browsing session identifier |
| event_type | VARCHAR(30) | Type of interaction recorded |
| occurred_at | TIMESTAMP | Timestamp when the event occurred |