What is your preferred methodology for creating data visualizations that effectively tell a story to non-technical stakeholders? Write a PostgreSQL query that produces a concise, visualization-ready summary from the provided organizational data. Return one row per department and calendar month where initiatives were recorded, including the requested measures and a stable presentation order.
department_name, activity_month, total_initiatives, completed_initiatives, completion_rate, total_budgetcompletion_rate is the percentage of initiatives marked completed, rounded to two decimalsactivity_month ascending, then department_name ascending| Column | Type | Description |
|---|---|---|
| department_idPK | INT | Unique department identifier |
| department_name | VARCHAR(100) | Department display name |
| Column | Type | Description |
|---|---|---|
| initiative_idPK | INT | Unique initiative identifier |
| department_id | INT | Owning department identifier |
| started_at | TIMESTAMP | Initiative start timestamp |
| status | VARCHAR(30) | Current initiative status |
| budget | NUMERIC(12,2) | Allocated initiative budget |