# AI BI Agent Case Study: Dexlyn | DevOps TechLab

> Business questions answered through multi-step, evidence-based analysis. How DevOps TechLab built it on AWS.

- Page: https://devopstechlab.com/resources/cases/dexlyn
- Last updated: 2026-11-14
- Contact: sales@devopstechlab.com · +91 90670 77200 (call or WhatsApp) · Monday to Friday, 10 AM to 7 PM IST
- This is a plain-text copy of the page above for AI tools. The page itself is the reference.

---
1. [Home](https://devopstechlab.com/)
2. [Resources](https://devopstechlab.com/resources/)
3. [Case studies](https://devopstechlab.com/resources/case-studies)
4. Dexlyn

AI & GenAI AWS QueryDash Client story

Dexlyn

# The drivers behind quarterly revenue, explained by an AI analyst on AWS

DevOps TechLab deployed an agentic AI investigation platform on Amazon Bedrock that lets Dexlyn’s business users ask what is driving revenue and key metrics, and receive multi-step, evidence-based answers, with production data protected by read-only controls.

By Janak Thakkar, Founder & CEO, DevOps TechLab Business intelligence 5 min read

Quarterly revenue

- Factor 1
- Factor 2
- Factor 3
- Factor 4

The agent ranks the factors by how much they explain. Illustration, not client data.

In short

Dexlyn uses QueryDash, DevOps TechLab's agentic investigation platform on AWS, for business intelligence. Users ask questions such as what drives quarterly revenue, and an agent on Amazon Bedrock with Amazon Nova Pro investigates. It runs multi-step, evidence-based analysis with read-only SQL, replacing manual queries and results combined by hand.

Official references: [What is Amazon Bedrock](https://docs.aws.amazon.com/bedrock/latest/userguide/what-is-bedrock.html) · [AWS Well-Architected Framework](https://docs.aws.amazon.com/wellarchitected/latest/framework/welcome.html)

ISO 27001 · SOC 2 · Working with companies across India and abroad from Ahmedabad, in IST

## Executive summary

Dexlyn wanted business users to understand what drove revenue and other key metrics without waiting on technical teams. Each answer meant manual SQL and combining results by hand. DevOps TechLab deployed QueryDash, its agentic investigation platform built on Amazon Bedrock, as an autonomous business intelligence agent: users ask the question in plain language, and the agent works through the data step by step and explains its findings with evidence.

**Client:** Dexlyn · Business intelligence

**Business problem:** Explaining what moved revenue and key metrics needed manual SQL and hand-combined results.

**What we delivered:** An autonomous BI agent (QueryDash) on Amazon Bedrock with Amazon Nova Pro, connected read-only to Dexlyn’s business data.

**Engagement:** Discovery, build and onboarding, then managed operations and continuous optimisation by DevOps TechLab.

**Outcome:** Business users get multi-step, evidence-based answers to questions about revenue and performance.

## The business challenge

Understanding what drove revenue and other key metrics meant writing SQL manually and combining results by hand. Complex business questions took longer to answer than the business wanted, and answers depended on technical expertise.

### Why it mattered

- **Slow answers to strategic questions**

  Questions about what moved revenue waited on manual analysis.
- **Dashboards stop at “what”**

  Fixed reports showed that a metric changed, not which factors caused it.
- **Results combined by hand**

  Several queries had to be run and their results joined manually to see the full picture.
- **Expertise as a bottleneck**

  Only people with SQL skills could investigate, so business users waited for them.

## What Dexlyn set out to achieve

1. Answer business questions such as revenue drivers in plain language.
2. Rank the factors behind a change, backed by evidence.
3. Let users ask follow-up questions in the same investigation.
4. Keep production data safe from AI-generated queries.
5. Extend to new business questions without new analytics projects.

## The solution: an autonomous business intelligence agent

Users ask a business question, for example *“Determine the main factors affecting quarterly revenue.”* The agent plans a multi-step investigation, discovers the relevant data, generates and validates each query, analyses the results and explains which factors matter most, recovering on its own when a query fails.

The agent loop

**Understand the goal.** The agent restates what you are trying to find out.

**Production data stays protected.** Every SQL statement is validated before it runs; write and schema-changing operations are rejected.

### Key design choices

- **Managed generative AI**

  Amazon Bedrock with Amazon Nova Pro handles reasoning and tool use. There are no models to host and no GPU infrastructure to run.
- **No servers to manage**

  The application runs on Amazon ECS on AWS Fargate behind an Application Load Balancer, so it scales with demand.
- **Works on the data where it lives**

  The agent queries the existing operational databases directly, read-only, instead of copying data into a new warehouse.
- **Investigations that remember**

  Amazon DynamoDB keeps the conversation and investigation history, so follow-up questions build on what the agent already found.

## Security and governance

For leadership, the first question about AI on production data is risk. The platform is built so that AI-generated queries never touch the database directly.

- **Read-only by design**

  Only read statements (SELECT, WITH, SHOW, DESCRIBE, EXPLAIN) are allowed. Any write or schema change is rejected before it runs.
- **Validated before execution**

  Every query the AI writes passes through a server-side validation layer. The model never has a direct line to production data.
- **Protected performance**

  Results are capped, so a broad question cannot turn into a runaway query on a production database.
- **Managed credentials**

  Database credentials sit in AWS Secrets Manager, and access is governed by AWS IAM roles, not stored in code.

## Architecture on AWS

Architecture as built (QueryDash platform)

| AWS service | Role in the solution |
| --- | --- |
| Amazon Bedrock · Amazon Nova Pro | Agent reasoning, planning and tool use |
| Amazon ECS on AWS Fargate · Application Load Balancer | Runs the investigation service without servers to manage |
| Amazon RDS (MySQL) · Amazon Aurora PostgreSQL | The business data the agent investigates, read-only |
| Amazon DynamoDB | Conversation and investigation memory |
| Amazon CloudFront · Amazon S3 | Delivers the web application securely |
| AWS Secrets Manager · AWS IAM | Credentials and access control |
| Amazon CloudWatch | Application, infrastructure and agent monitoring |

## How we delivered

1. 01 **Discover**

   Mapped the questions Dexlyn’s users need answered, the data behind them and how it relates, and defined secure, read-only access to production.
2. 02 **Build & onboard**

   Connected Dexlyn’s data, configured Amazon Bedrock and Nova Pro, set up read-only validation, conversation memory and real-time streaming, and tested against representative investigation scenarios.
3. 03 **Run**

   DevOps TechLab operates the service: monitoring the application, the AWS environment and the agent, supporting queries and resolving production issues.
4. 04 **Improve**

   Ongoing tuning of agent planning, query generation and recovery, plus reviews of performance, cost and security as new questions are added.

## Business outcomes

Dexlyn’s business users now get evidence-based answers about what drives revenue in one conversation, instead of waiting for manual analysis.

- **Self-service business intelligence**

  Business users investigate revenue and key metrics in plain language, without SQL.
- **Drivers, not just numbers**

  The agent works through the data to identify the factors behind a change.
- **Evidence-based findings**

  Every answer comes with the analysis behind it, so leaders can act with confidence.
- **Zero write access to production**

  AI-generated queries are validated and read-only.
- **A platform, not a one-off**

  New business questions are added on the same platform, without a separate analytics project for each.

## What’s next

Because the architecture is reusable, Dexlyn can extend the agent to new business questions without building a separate analytics workflow for each. DevOps TechLab continues to advise on new investigation scenarios and further opportunities for AI-driven automation.

The same platform, other teams

- [**Chatwit** “Investigate why sales performance changed and guide me through the findings.”](https://devopstechlab.com/resources/cases/chatwit)
- [**TNBT Tech** “Identify unusual operational changes and determine their likely causes.”](https://devopstechlab.com/resources/cases/tnbt)
- [**Trueestate** “Investigate why property bookings declined.”](https://devopstechlab.com/resources/cases/trueestate)

**About DevOps TechLab**

DevOps TechLab is an AWS Advanced Tier Services Partner with the AWS Generative AI Competency and AWS SMB Competency. We design, build and run cloud and generative AI solutions on AWS for growing businesses, with 265+ cloud environments under management.

### Want answers like these from your own data?

Share the questions your leadership team asks most often. We will show how an AI investigation agent on Amazon Bedrock could answer them, safely and read-only.

[Next story · AI & GenAI **Trueestate: AI agent that investigates property and booking performance** Listing design · 2 min read](https://devopstechlab.com/resources/cases/trueestate)

## More client stories

[**−36%** monthly cloud bill Migration **Gamerji: From AWS to Azure in 3 weeks, with a 36% lower cloud bill**](https://devopstechlab.com/resources/cases/gamerji) [Migration **Devine Globe: From managed hosting to a secure, production-ready AWS environment**](https://devopstechlab.com/resources/cases/devine-globe) [AI & GenAI **HK Infosoft: Semantic product discovery: search the catalogue the way customers talk**](https://devopstechlab.com/resources/cases/hk-infosoft)

Keep exploring

## The work behind this story

- [Service **AI consulting services** Assistants, chatbots and agents on Bedrock, Azure OpenAI or Vertex AI.](https://devopstechlab.com/solutions/generative-ai-data/)
- [Partner **AWS partner in India** Advanced Tier Services Partner with SMB and Generative AI Software Competencies.](https://devopstechlab.com/partners/aws/)
- [Case study **Conversational AI agent case study** Chatwit: an agent that investigates why sales changed.](https://devopstechlab.com/resources/cases/chatwit)
- [Case study **AI anomaly investigation agent** TNBT Tech: unusual operational changes and their likely causes.](https://devopstechlab.com/resources/cases/tnbt)

FAQ

## Questions about the Dexlyn BI agent

**Still have a question?**

Send it with the form below and an engineer will reply.

Ask us

###

A typical question is "Determine the main factors affecting quarterly revenue." The agent answers through multi-step, evidence-based analysis rather than a single query. It can rank factors by how much they explain.

A React web app on CloudFront and S3 sits behind an Application Load Balancer. The agent runs on Amazon ECS Fargate with Amazon Bedrock and Amazon Nova Pro. Memory sits in DynamoDB, credentials in Secrets Manager and monitoring in CloudWatch.

Access is read-only and controlled. Every SQL statement is validated before it runs, and write or schema-changing operations are rejected. The agent can analyse production data without changing it.

Onboarding covered database connectivity, Bedrock and Nova Pro configuration, secure credentials, read-only SQL validation, conversational context and real-time streaming. Representative scenarios were validated before use.

Yes. The platform extends to new questions without building a new analytics workflow each time. Chatwit, TNBT Tech and Trueestate use the same platform for sales, operations and property questions.

Talk to an engineer

## Start with a 20-minute review. Leave with a plan.

An engineer looks at your current setup, points out what’s costing you money or risk, and tells you what we’d fix first. No sales deck, no obligation to go ahead.

[Sales and general enquiries **sales@devopstechlab.com**](mailto:sales@devopstechlab.com) [Call us **+91 90670 77200**](tel:+919067077200)

Every month you wait, the bill grows, the audit gets harder and the AI project waits another quarter.
