AI Analyst: Correct KPIs in Plain Language | AgentixLake
AGENT · AI ANALYST

Ask in plain language.Get the correct KPI.

AI Analyst is an analytics agent we build on your data platform: Snowflake, Databricks, AWS, Google Cloud or on-premises. It answers business questions from one governed set of KPI definitions, shows the query behind every number and can check your dashboards against the same definitions. An analyst approves every change.

ANALYST REPLAY · QUESTION → GOVERNED KPI → ANSWER
Acme
Channels
# general# sales-leads# finance
Direct messages
AI Analyst APP
# sales-leads14 members
HS
Head of Sales09:41
Why did gross margin drop in March?
2 replies
Message #sales-leads
Thread
HS
Head of Sales09:41
Why did gross margin drop in March?
AI AnalystAPP09:42

Gross margin was 41.8% in March, down 2.3 pts from February. Most of the drop comes from higher freight costs.

MonthGross marginFreight cost shareFeb 202644.1%6.9%Mar 202641.8%8.3%
metrics.gross_margin · semantic layer v3 · 2 queries · 1.4 s
HS
Head of Sales09:43
Is that in every region?
AI AnalystAPP09:43
No. Most of the increase is in DACH, where freight cost share rose from 7.0% to 9.6%.
Reply…
{{ typingDots }}AI Analyst is typing

Works in Slack, Microsoft Teams or your BI tool.

THE CHALLENGE

Every team has its own version of the numbers.

Sales, finance and operations each calculate the same KPI their own way. Meetings start with whose number is right, and simple questions wait days for the data team.

WHAT WE TYPICALLY SEE
  • Two dashboards, two numbers for the same KPI
  • KPI logic buried in SQL and spreadsheets
  • Simple questions queued for analysts
  • AI chatbots that guess what a KPI means
WHAT WE DELIVER

Define, answer, check with review.

01 · DEFINE

We turn each KPI into one governed definition, agreed with finance and the business owner.

  • One definition per KPI
  • Versioned in Git
  • An owner for every metric
02 · ANSWER

People ask in plain language where they already work. The agent answers from the governed definitions.

  • Number and explanation
  • Query and definition shown
  • Your access rights apply
03 · CHECK WITH REVIEW

It can build dashboards from the same definitions and flag tiles that drift from them, in BI tools such as Power BI, Tableau or Looker.

  • Dashboards from governed KPIs
  • Mismatches flagged
  • Fixes approved by an analyst
EXAMPLE QUESTIONS

What teams ask.

SALES
  • “Which deals slipped out of this quarter?”
  • “How did win rate change by region?”
  • “Which accounts are ordering less than usual?”
FINANCE
  • “Why is gross margin down this month?”
  • “How does DSO compare with last quarter?”
  • “Which cost lines grew fastest this year?”
OPERATIONS
  • “Which warehouses missed their delivery target last week?”
  • “Where are returns rising?”
  • “How long does an order take from payment to shipping?”
WHAT IT NEEDS

A semantic layer comes first.

AI Analyst answers from a semantic layer: the governed definitions of your KPIs, with their joins and filters, kept in code. Without one, any AI model has to guess what a KPI means from table names, and two people asking the same question can get different numbers. If you don’t have a semantic layer yet, we build it as the first step.

01
Semantic layer

dbt Semantic Layer, Snowflake semantic views, Databricks metric views, Cube or LookML. We use the one that fits your stack.

02
Warehouse access

Read-only access to your warehouse or lakehouse, set up so each query runs with the asker’s own permissions.

03
Where people ask

Slack, Microsoft Teams or your BI tool. Every answer names the definition and the query it used.

One definition

For each KPI, agreed with finance and versioned in Git.

Traceable

Every answer shows the query and the definition behind it.

Reviewed

The agent never changes a KPI definition or dashboard on its own. It proposes each change, and one of your analysts approves it.

FAQ

Questions we hear

How is this different from a chatbot on our data?+

A generic chatbot writes SQL against raw tables and guesses what a KPI means. AI Analyst queries only the definitions you approved, and shows the query and definition with every answer.

We already have Cortex Analyst or Genie. Why AI Analyst?+

Use them. Where they fit, we build AI Analyst on Snowflake Cortex Analyst or Databricks AI/BI Genie, and add what they need to give correct answers: the semantic layer, a test set of real questions, and access from Slack or Teams. If your data sits on more than one platform, or your dashboards are in Power BI, Tableau or Looker, we add our own agent layer on top.

Does it change dashboards on its own?+

No. It proposes each change, and an analyst reviews and approves it.

Which tools does it work with?+

It connects to your warehouse or lakehouse, your BI tool and the channels your teams already use, such as Slack or Microsoft Teams. We confirm your stack during scoping.

Where does the model run?+

On the AI service already in your cloud account: Amazon Bedrock, Snowflake Cortex, Databricks Mosaic AI Model Serving or Vertex AI. On-premises, we host open-source models on your infrastructure.

Who can see which numbers?+

We set it up so each query runs with the asker’s own access rights, so people only see data they are already allowed to see.

Can we add it to a running platform?+

Yes. It can be part of a Production Sprint or added to a platform that’s already live.

Where does it run, and who controls it?+

Everything we build for you is yours: pipelines, data models, infrastructure code and documentation, in your own cloud account and repositories. Our agents and accelerators come with a licence that keeps working even if you stop working with us. If you need full source access, we offer that too.

Stop debating whose number is right.

Tell us which platform and BI tool you run.

Add it to your platform→