Exercise 2, Task 2: Use Copilot in Excel to analyze historical RFP data
Before you can finalize what your EcoSense 360 RFP Response Agent should know, you need data to guide your priorities when responding to RFPs. Fabrikam’s Sales Operations team maintains a record of past RFP submissions, including details on requested features, deal size, and won/loss outcomes.
Using Copilot in Excel, you plan to analyze this historical RFP data to uncover patterns, such as:
- What are the top requested features?
- Which requirements are most important to hotel clients?
- Where has Fabrikam lost deals in the past?
These insights can help ensure that the EcoSense 360 RFP Response Agent focuses on the topics that matter most to prospective customers and avoids common pitfalls in future RFPs.