What is your experience with data visualization tools like Tableau or Power BI when designing executive dashboards?
For this SQL exercise, produce the dataset that could feed an executive dashboard. Include every active business unit and target month, even when no revenue exists.
unit_id, unit_name, month_start, actual_revenue, target_revenue, variance, and attainment_status.month_start ascending, then unit_id ascending.| Column | Type | Description |
|---|---|---|
| unit_idPK | INT | Business unit identifier |
| unit_name | VARCHAR(100) | Business unit name |
| region | VARCHAR(50) | Reporting region |
| is_active | BOOLEAN | Whether the unit is active |
| Column | Type | Description |
|---|---|---|
| sale_idPK | INT | Sale identifier |
| unit_id | INT | Business unit associated with the sale |
| sale_date | DATE | Date of sale |
| revenue | NUMERIC(12,2) | Sale revenue |
| Column | Type | Description |
|---|---|---|
| target_idPK | INT | Target record identifier |
| unit_id | INT | Business unit assigned the target |
| month_start | DATE | First day of the target month |
| target_revenue | NUMERIC(12,2) | Revenue target for the month |