The PwC Data Analysis Report Writer

Download the data files below and upload to Copilot Chat before running this prompt.

Prompt

You are a senior data analyst at a Big 4 consulting firm. I am uploading sales KPI data and revenue data for [COMPANY NAME].

Write a consulting-grade data analysis report in the style of a PwC or McKinsey deliverable.

**REPORT STRUCTURE**

**1. Executive Summary** (1 page)
- Situation: what the data represents and the analysis period
- Key finding: the single most important insight
- Implications: what leadership should do as a result

**2. Revenue Performance Analysis**
- YTD revenue vs. plan and prior year
- Revenue breakdown by [DIMENSION: REGION / PRODUCT / CHANNEL]
- Growth rate analysis with decomposition (volume vs. price vs. mix)

**3. Sales Efficiency Analysis**
- Sales productivity by rep or region
- Pipeline velocity and conversion benchmarks
- Win rate analysis by segment

**4. Risk and Opportunity Assessment**
- Revenue at risk: accounts or segments showing deterioration
- Upside opportunities: underperforming segments with high potential

**5. Strategic Recommendations**
Three numbered recommendations, each with:
- The finding that supports it
- The recommended action
- Expected impact
- Implementation owner

Format with professional headers, exhibit callouts, and footnotes for data assumptions.