How do you use Tableau to visualize and communicate insights?
Write a PostgreSQL query that prepares a Tableau-ready dataset for an HCA Healthcare view. Return monthly facility metrics for the first quarter of 2025, including only months with at least one completed encounter.
facility_name, report_month, completed_encounters, average_length_of_stay, and readmission_rate_pct.report_month ascending, then facility_name ascending.| Column | Type | Description |
|---|---|---|
| facility_idPK | INT | Unique facility identifier |
| facility_name | VARCHAR(120) | Facility display name |
| Column | Type | Description |
|---|---|---|
| encounter_idPK | INT | Unique encounter identifier |
| facility_id | INT | Facility associated with the encounter |
| admit_date | DATE | Encounter admission date |
| status | VARCHAR(30) | Encounter status |
| length_of_stay_days | INT | Length of stay in days |
| readmission_30d | BOOLEAN | Whether the patient was readmitted within 30 days |