Intelligent Integrated Chatbot Agent (IICA) for Power BI

Intelligent Integrated Chatbot Agent (IICA) is a unified AI assistant that enables enterprises to interact with their organizational data across multiple sources using natural language. Built on Azure OpenAI, Flask, and Microsoft Graph, the chatbot intelligently routes queries to the most relevant backend — APIs, databases, SharePoint lists, or indexed documents — and responds with accurate, context-aware answers in real time. Key Capabilities Secure, Vendor-Scoped Access Access controlled through encrypted vendor keys (vendor_keys.txt) with session-based authentication, automatic expiry, and HTTPS-only cookies. AI-Driven Query Understanding Uses Azure OpenAI GPT-4o-mini for intent detection, contextual rewriting, and entity recognition — handling follow-up questions naturally. Multi-Source Connectivity Azure PostgreSQL – Generates and executes SQL queries safely. Microsoft Graph / SharePoint – Retrieves project and task details dynamically. Azure Cognitive Search – Extracts insights from company documents. Azure Blob Storage – Fetches schemas and metadata. OMDb API – Adds optional movie data for demonstration or external references. Rich Conversational Interface A responsive web UI with a modern chat design (iICA) that provides HTML-formatted answers, tables, color-coded task statuses, and document citations. Context Retention & Follow-Up Intelligence Maintains short-term conversation history, detects vague pronouns like “that project,” and reformulates queries to keep responses relevant.