[S2] - Create Copilot Chatbot

[raafatzarka]

As a Developer, I want to use Azure AI Studio to create a Copilot chatbot so that users can interact with the app by asking questions about consolidated denorm data or the PowerBI dashboard.

Resources:

• https://learn.microsoft.com/en-us/azure/ai-studio/tutorials/deploy-chat-web-app
• https://github.com/Azure-Samples/chat-with-your-data-solution-accelerator

Acceptance Criteria:

• Develop and deploy a chatbot using Azure AI Studio.
• Integrate the chatbot with Azure Functions or other scripts to process queries.
• Ensure the chatbot can query the consolidated denorm table, Archival SCORE Table Power BI dataset.