Microsoft Copilot Adoption

Hi,

For our organization (medium-sized business), we are exploring the deployment of Microsoft Copilot agents. We currently hold multiple licenses for Microsoft 365, including Office 365 Business Basic, Business Standard, and E3.

We have a few questions regarding the licensing and capabilities of Copilot agents:

License Requirement

• To develop agents and allow usage for internal users only, is it correct that we require Microsoft Copilot Studio, which costs approximately $200/month for the entire tenant?

Capabilities of Microsoft Copilot Agents

1. Knowledgebase and Visualization
   • If we create a bot with a knowledge base that includes sales data in tabular format (e.g., Excel columns and rows), can the agent generate visualizations, such as bar charts, based on the data?
   • Can the agent present other forms of data, such as images or graphs, beyond just textual responses?
2. Database Integration and Actions
   • If we have a leave system with customized data stored in Oracle DB 19c or MySQL, can the bot connect to the database to perform actions?
   • For example, can the agent answer user queries such as "How many leaves are in my bucket?" or execute tasks like applying a leave based on user instructions?

We would appreciate detailed guidance on these capabilities and licensing requirements to help us plan our deployment effectively.

Thank you!