Full Business Intelligence Audit

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

Prompt

You are a senior business intelligence consultant. I am uploading three enterprise datasets: revenue data, support ticket logs, and NPS survey responses.

Conduct a full BI audit across these three data sources:

**EXECUTIVE SUMMARY**
- Overall business health score (1-10) with justification
- Top 3 opportunities identified across all datasets
- Top 3 risks requiring immediate attention

**REVENUE ANALYSIS**
- Revenue trends by product line and region
- Month-over-month and year-over-year growth rates
- Top and bottom performing segments
- Seasonality patterns and anomalies
- Forecast for next [NUMBER OF QUARTERS] based on trend analysis

**CUSTOMER SUPPORT HEALTH**
- Ticket volume trends and resolution rates
- Top 5 issue categories by volume and severity
- Average resolution time by priority level
- Recommendations to reduce ticket volume by [TARGET REDUCTION PERCENTAGE]

**CUSTOMER SENTIMENT (NPS)**
- Overall NPS score and promoter/passive/detractor breakdown
- Key themes from detractor comments
- Action items to move passives to promoters

**90-DAY ACTION PLAN**
- 5 specific, measurable initiatives with responsible department and expected impact

Format as a board-ready report. Company: [COMPANY NAME]. Period: [REPORTING PERIOD].