AI Data Analyst in Microsoft Teams: Answers From Live Operational Data
AI Agents •AI Development •Data Analytics •Generative AI

AI Data Analyst in Microsoft Teams: Answers From Live Operational Data

A US title and settlement company runs every closing through about twenty workflow stages, each with a turnaround goal. Managers needed answers the dashboards did not already hold. The solution is an AI agent in Microsoft Teams that reads the operational database, computes metrics by the company's own rules, and shows the query behind every number.

Facing a similar challenge? Tell us about the task, and we will show how we would build it for your business.

Build Something Like This for Me

Free 30-min call · One-page solution outline within three business days · No commitment

Questions the Dashboards Could Not Answer

Every closing the company handles passes through about twenty workflow stages, and each stage has a turnaround goal the company answers for to its own clients. Managers see the data through a set of Power BI dashboards built on stored procedures. A refresh can take minutes, and a dashboard covers only what it was built to show.

A question outside the dashboards goes to an analyst and waits in a queue. The rules for what counts as on time sit in one place only: inside hundreds of lines of procedure code.

Where Chat-With-Your-Database Tools Go Wrong

  • The model invents the business metric. On time differs from stage to stage: which event starts the clock, business hours or calendar hours, which holidays count, which clients are excluded. A model that improvises the formula returns a plausible number that disagrees with the dashboard, and the manager stops trusting both.
  • Milestones are found by name. A text match also finds workflow events the company does not use. Milestones have to be fixed, verified codes.
  • The tables are large and shared. One unfiltered query over the largest tables stalls the server that production reporting runs on. The check has to happen before the query is sent.
  • Similar things are easy to mix up. Clients, closers, offices and property states look alike in a schema. Confusing them never shows as an error, only as a wrong number.
  • Two hand-picked questions always look fine. Real defects show when the same fact, asked two ways, gives two answers.

Two Paths for Two Kinds of Question

A manager asks a question in Teams the way they would ask a colleague. The agent reads the database with a read-only login and replies with concrete numbers and names, together with the query it ran. SLA questions and open questions take different paths, because they carry different risks.

  1. SLA questions. The model recognizes the stage, the period and the filters, and code assembles the query from a catalog transcribed from the company's own procedures. The same question always produces the same query, so the chat and the dashboard show the same number.
  2. Open questions. For volumes, revenue, workloads and comparisons, the model picks from about 150 verified query patterns and a catalog of tables and business definitions, and writes a single read-only query.
  3. The check. Before anything runs, code verifies that the query is a read and that it does not scan a very large table without an indexed filter.
  4. The answer. Numbers, names and the query that produced them. If the result is empty or misses the question, the agent asks a follow-up of its own, a bounded number of times.

Where a stage cannot be measured for part of the business, the agent says so and explains why, instead of offering a neighboring number.

Technology Stack

Azure OpenAI LangChain Python Microsoft TeamsPower BI

Why the Chat and the Dashboard Agree

Turnaround figures are what the company reports to its clients, so a merely plausible number is worse than none. The model's job is to understand the question. The arithmetic follows the company's own definitions, in code.

  • Read-only by construction. A read-only login, one read query per step, and a cost check before anything reaches the server.
  • Quirks are settled by the business. Each stage is copied from the company's procedure as it is. The catalog is designed so that, if the business decides a quirk is a defect, the fix is a change to one field.
  • Defects become checks. An offline test suite that needs neither the database nor the model runs every query variant a change can produce. The process is designed so that a defect is written as a failing check before anyone fixes it.

Built to Handle

Each item below describes what the agent is built to do.

  • No writes to the company database: a read-only login and read queries only.
  • A query over a very large table without an indexed filter is rejected before it is sent.
  • SLA queries are assembled by code from the stage catalog.
  • An answer contains concrete numbers and names, every item when a list is asked for, and the query that produced them.
  • The language model can run in the client's own cloud subscription, and the agent also works with OpenAI, Google and open-weight models.

Other Operations With the Same Shape

Turnaround goals, a large operational database and a wall of reports: the combination is common.

  • dozens of reports built on stored procedures, each taking minutes to refresh;
  • managers' questions that go beyond what the reports were built to show;
  • a key metric whose definition exists only inside procedure code;
  • a database shared with production reporting, where a careless query has a cost.

Title and escrow, mortgage servicing, insurance claims, logistics and field service all run this way. The same agent can also answer in Slack or a web chat, and read other databases and reporting tools. The earlier AI assistant for report generation answered analysts' ad-hoc questions in a similar manner, and the text-to-SQL entry in our glossary explains the technique. Our AI agent development and data analytics services pages cover how we scope this work.

20

SLA stages whose queries are built by code from the company's own procedures

~150

query patterns for open questions, each verified before use

0

writes to the company database

Other cases

AI Agent Platform With Governed Model Access: Many Agents, One Runtime

AI Agent Platform With Governed Model Access: Many Agents, One Runtime

Read more ›
AI Candidate Screening That Checks CV Claims Against Public Evidence

AI Candidate Screening That Checks CV Claims Against Public Evidence

Read more ›
ChatGPT-Powered Content Generation Platform

ChatGPT-Powered Content Generation Platform

Read more ›
AI Data Verification Layer for Property Data: Rules First, a Person on Borderline Cases

AI Data Verification Layer for Property Data: Rules First, a Person on Borderline Cases

Read more ›
AI Delegation Agent for Executive Teams: Assignments, Statuses and Scores in One Loop

AI Delegation Agent for Executive Teams: Assignments, Statuses and Scores in One Loop

Read more ›
AI Image Annotation Solution for Medical Assessment

AI Image Annotation Solution for Medical Assessment

Read more ›
ML/Computer Vision + Data Annotation for ADAS

ML/Computer Vision + Data Annotation for ADAS

Read more ›
AI/ML-Driven Telecom Network Optimization

AI/ML-Driven Telecom Network Optimization

Read more ›
Custom GenAI Medical Drug Search Accelerator

Custom GenAI Medical Drug Search Accelerator

Read more ›
ML/Computer Vision-Powered Data Annotation for Sports

ML/Computer Vision-Powered Data Annotation for Sports

Read more ›
OCR Retail Receipt Data Extraction Tool

OCR Retail Receipt Data Extraction Tool

Read more ›
Computer Vision + Image Annotation for Insurance

Computer Vision + Image Annotation for Insurance

Read more ›
AI Presale Assistant for a Marketing Agency: From Meeting Transcript to Sourced Draft

AI Presale Assistant for a Marketing Agency: From Meeting Transcript to Sourced Draft

Read more ›
AI Pricing Engine for an Equipment Distributor: The Model Proposes, a Person Approves

AI Pricing Engine for an Equipment Distributor: The Model Proposes, a Person Approves

Read more ›
AI Trade Contractor Sourcing: Verified Profiles and Pre-Screening for a Home Builder

AI Trade Contractor Sourcing: Verified Profiles and Pre-Screening for a Home Builder

Read more ›
Cinema Scheduling and Pricing Optimization: A Week of Showtimes, Computed

Cinema Scheduling and Pricing Optimization: A Week of Showtimes, Computed

Read more ›
Computer Vision + ChatGPT-Powered Recommendations

Computer Vision + ChatGPT-Powered Recommendations

Read more ›
Data Annotation for AI-Driven Sports Analytics

Data Annotation for AI-Driven Sports Analytics

Read more ›
Generative AI Bot for Customer Service

Generative AI Bot for Customer Service

Read more ›
Generative AI Solution for Code Compliance

Generative AI Solution for Code Compliance

Read more ›
SaaS Marketing Content Generation Platform for Healthcare

SaaS Marketing Content Generation Platform for Healthcare

Read more ›
Interactive Chatbot with an Animated Avatar

Interactive Chatbot with an Animated Avatar

Read more ›
Managed Video Annotation Pipeline for a Client's Own Human-Motion Footage

Managed Video Annotation Pipeline for a Client's Own Human-Motion Footage

Read more ›
ML/AI Technical Due Diligence for Startup Acquisition

ML/AI Technical Due Diligence for Startup Acquisition

Read more ›
OCR Solution for Invoice Processing

OCR Solution for Invoice Processing

Read more ›
Property Management Platform With an AI Voice Assistant for Multiple HOAs

Property Management Platform With an AI Voice Assistant for Multiple HOAs

Read more ›
AI-Powered Platform for Real Estate

AI-Powered Platform for Real Estate

Read more ›
AI Assistant for Report Generation & Visualization

AI Assistant for Report Generation & Visualization

Read more ›
Sitecore Migration

Sitecore Migration

Read more ›
ML/AI Technical Due Diligence for SporTech

ML/AI Technical Due Diligence for SporTech

Read more ›
Voice Interview to Social Posts: AI Content in the Professional's Own Voice

Voice Interview to Social Posts: AI Content in the Professional's Own Voice

Read more ›

Let's talk about your project

We'll help you harness AI and ML technologies to create innovative software solutions

File requirements: pdf, doc, docx, rtf, ppt, pptx — max 15 MB

No file selected