Tell me about your proficiency in Excel and advanced data manipulation techniques as you would apply them to Gartner's data needs.
For the SQL portion, write a query that evaluates Gartner account engagement performance using the provided data. Include accounts without qualifying 2025 engagements.
account_id, client_name, market_segment, completed_engagements, total_contract_value, avg_satisfaction, performance_band, and segment_rank.market_segment, segment_rank, and account_id.| Column | Type | Description |
|---|---|---|
| account_idPK | INT | Unique account identifier |
| client_name | VARCHAR(100) | Client account name |
| market_segment | VARCHAR(50) | Account market segment |
| Column | Type | Description |
|---|---|---|
| engagement_idPK | INT | Unique engagement identifier |
| account_id | INT | Referenced account |
| engagement_date | DATE | Engagement completion or activity date |
| status | VARCHAR(30) | Engagement status |
| contract_value | DECIMAL(12,2) | Contract value associated with the engagement |
| satisfaction_score | DECIMAL(3,2) | Client satisfaction score from 1.00 to 5.00 |