eCommerce

Ask Saras iQ's Business Analyst What Your Dashboards Can't Answer

Sumeet Bose
Content Marketing Manager
Last updated:
July 27, 2026
15
min read
The iQ Business Analyst is the AI analyst inside Saras iQ, built for $15M+ Shopify brands. Ask in plain English and get a certified answer, plus the chart and SQL behind it.
TL;DR
  • The iQ Business Analyst is the AI analyst inside Saras iQ. Ask a business question in plain English and get a certified answer with the chart and the SQL behind it.
  • It answers the questions teams ask every week; be it contribution margin, customer cohorts and segmentation, or sales and marketing performance.
  • It works through a five-step pipeline, context, plan, SQL, summary, and visual, that you can audit at every step.
  • Same question, same number, for every person, because it runs on your governed business logic, and it tells you when it cannot answer.
  • Use it in the iQ app, in Slack, and in Claude through iQ MCP, with the same answer on every surface.

When somebody in a DTC eCommerce team asks why margin dropped last month, the dashboard shows the drop and stops there. Eventually, the question becomes a Slack message to the one person who can pull the numbers. However, in most situations the answer lands two days later, after the business decisions have already been made. The iQ Business Analyst is built to end that loop.  

Ask it in plain English, in the moment, and it comes back with the answer, a chart, and the SQL it ran, straight from your certified data. It works off your own business logic, so "margin" and "new customer" mean what they mean in your business, and the answer is one your sharpest analyst would sign off on. In this article, we will walk through what it answers, how it works, and how it stays accurate.

What the iQ Business Analyst Is

The iQ Business Analyst is the business-question half of Saras iQ, an AI analyst built for eCommerce that turns a plain-English question, such as what contribution margin was by channel last week, into a written answer, a chart, and the SQL behind it, all grounded in your certified data. It is powered by Claude.

The word "analyst" is the part that matters. It is easy to pull the rows, but equally hard to interpret them the right way. The iQ Business Analyst does that interpreting by reading your certified data. It works in the same the way a teammate would and come back with the answer you asked for. It is one half of the Saras iQ AI Data Team, working alongside the iQ Data Engineer, which fields the questions about the data itself.

Core Capabilities of iQ Business Analyst

The iQ Business Analyst is there the moment someone has a question, at 11pm or five minutes before a Monday board call. These are the five capabilities:

Capability How it works How it helps
iQ Chat Ask a business question in plain English and get a written answer with a chart, grounded in certified data. No SQL to write and no dashboard to search through.
Show Your Work Open any answer to view the plain-English summary, the exact SQL behind it, and the chart. Business leaders review the conclusion while analysts verify the logic.
Smart Follow-Up When a question is ambiguous, iQ asks the most useful clarifying question and states any assumptions it makes. It avoids guessing without turning the interaction into an interrogation.
Share Answers Send an answer or visual to Slack, email, or Teams in one click. Insights reach the right people without screenshots or rerunning the analysis.
Scheduled Reports Set up a recurring report once and have it run and arrive automatically. No one has to rebuild the same report every week.

How the iQ Business Analyst Works

Behind every answer the iQ Business Analyst generates, it runs a short pipeline. Five specialized agents each handle one step, and you can watch every step, so nothing is hidden behind a black box.

A question moves through five steps:

1
Context
iQ reads the business rules and definitions your question depends on.
2
Plan
It works out which tables and metrics to use.
3
SQL
It writes the query against your certified data.
4
Summary
It turns the result into a plain-English answer.
5
Visual
It draws the chart.

Most questions come back in about 40 to 60 seconds. The summary, SQL, and chart you can open on any answer come out of the last three steps. And because each agent owns one narrow job, there are fewer places for the answer to go wrong.

What It Answers: with a Focus on Contribution Margin

The iQ Business Analyst works across three areas of the business: contribution margin, customer cohorts and segmentation, and sales and marketing performance. Margin is where it does its best work.

Contribution margin, answered daily and down to the SKU

Contribution margin usually shows up once a month, after finance stitches it together from Shopify, the ad platforms, an ERP, and a spreadsheet. By then the decisions it should have shaped are already made. The iQ Business Analyst answers margin on demand, certified daily, weekly, or monthly, by channel across Shopify, Amazon, and retail in one answer, and down to the individual SKU. Every figure comes with the SQL behind it, so finance can trace it before it lands in a board deck.

The customer and marketing questions it handles too

Beyond margin, the iQ Business Analyst runs the customer and marketing questions teams ask every week. On the customer side it handles cohorts and RFM-based segmentation, including which customers are drifting toward churn, the kind of analysis behind customer segments that predict repeat purchase.  

On the marketing side it reports channel and campaign performance like ROAS and blended CAC, measured against your warehouse rather than the ad platform's own numbers. Recurring leadership reporting, like a weekly business review, can run on the same engine.

How It Stays Accurate

Accuracy in the iQ Business Analyst is engineered before your team ever logs in. Four things make an answer trustworthy:

  1. A context layer trained on your business: our data experts load your business logic, table and column descriptions, SQL templates, and default rules, so iQ reads every metric the way you define it.
  1. Validation against your own questions: before go-live, iQ is tested against 30 to 100 of your historical questions through automated checks, manual review, and your own sign-off, confirming its SQL matches your certified numbers.
  1. It says so when it cannot answer: if the data is not there, iQ tells you plainly.
  1. Security by design: the language model never connects to your warehouse, iQ writes SQL first and fetches with read-only access, none of your data trains the models, and Saras Analytics is GDPR and SOC 2 compliant.

Because those definitions are set once and applied to every query, the same question returns the same number for everyone who asks. The full mechanics of the context layer are covered in <u>how to make AI answers accurate for eCommerce</u>.

Where You Use It

You reach the iQ Business Analyst on three surfaces, and all three run on the same certified data and business logic underneath.

Surface How you use it Best for
iQ app Log in and ask questions on the dashboard. Self-serve deep dives and building out views.
Slack Tag @iQ in a channel and get the answer in the thread. In-the-flow questions during a live discussion.
Claude via iQ MCP Ask inside Claude and build dashboards or artifacts on top of governed answers. Working in Claude and creating custom outputs.

The Slack experience has its own walkthrough, and so does iQ MCP.

The iQ Business Analyst in Action

The clearest sign the iQ Business Analyst works is what happens once a whole team has it. Over 30 days, Ridge answered 1,069 questions across 18 people spanning the CEO, marketing, product, operations, and finance, at roughly 35 questions a day, with zero analyst requests. Every one was self-serve.

The pattern holds on the margin side too, where daily reporting replaces the monthly scramble.

The Payoff by Role

The value lands differently depending on where you sit.

Role What changes Business impact How it feels
Founder / CEO One set of numbers the whole leadership team works from. Board prep, budget calls, and inventory decisions move on shared figures, with no wait for reconciliation. Confident, forward-looking capital allocation.
CFO Contribution margin, CAC, net revenue, and LTV are defined once and enforced on every query. Finance-versus-marketing reconciliation meetings disappear, and every answer shows its SQL. A close built on numbers finance can defend.
Head of Growth / CMO A channel shift can be checked against warehouse data before a budget call. Spend stops leaking into channels that only look good on a platform dashboard. Confidence in the signal behind every spend decision.
Data Analyst / Ops Routine questions become self-serve for the people who ask them. The analyst backlog clears. Freed up for the analysis that needs a human.
Head of Data / BI A governed semantic layer sets metric definitions once and enforces them everywhere. Teams self-serve without the data team losing control of definitions. Scaling analytical capacity without scaling headcount.

Conclusion

The brands pulling ahead are the ones deciding fastest on numbers they trust, while everyone else is still reconciling last month's. Every week your team spends chasing whose figure is right is a week a competitor spends acting on theirs. Put the iQ Business Analyst in front of your own numbers and see what your team stops waiting for. Talk to our data consultants.

Frequently Asked Questions (FAQs)

What kinds of questions can the iQ Business Analyst answer?
+

It answers business questions across contribution margin, customer cohorts and segmentation, and sales and marketing performance, all grounded in your connected data and your defined business logic. Ask it something like margin by channel last week or CAC by cohort, and it returns the answer, the chart, and the SQL. If a question falls outside your data or configured logic, it says so.

Does the iQ Business Analyst show how it got the number?
+

Yes. Every answer opens into three views: the plain-English summary, the exact SQL query that produced it, and the chart. A finance team can trace a figure back to its query before it goes into a board deck, and a non-technical leader can read the summary while an analyst checks the logic, from the same answer.

How is it different from asking ChatGPT or Claude directly?
+

A general AI tool interprets your question against its training and guesses at what your metrics mean, so it can return a different number each time. The iQ Business Analyst runs on your governed business logic and certified data, answers consistently, and tells you when it lacks the data. The full comparison is in Saras iQ versus Claude plus BigQuery.

How fast are answers, and can the whole team use it?
+

Most answers come back in about 40 to 60 seconds. The whole team can use it, in the iQ app, in Slack, and in Claude, and an admin invites teammates and manages access so everyone works from the same answer.

Does the iQ Business Analyst replace our analyst or finance team?
+

No. It makes them faster. Routine questions that used to sit in a queue become self-serve in seconds, which clears the analyst backlog and frees the team for the analysis and judgment that needs a person. Your CFO still owns the close; they just stop spending days reconciling the numbers by hand.

+

What to do next?

Test your Data Readiness
Take the Quiz
Take a quick 5-min quiz and find out how future-proof your stack really is.
See Saras in Action
If you're ready to stop pulling reports manually and centralize your eCommerce data, see exactly how Saras does it in a 25-minute demo. No prep required.
Book a Demo
Check out Saras Analytics × 9 Operators Podcast
Listen to how top eCommerce operators think about data, growth, and analytics
Listen Now
Table of Contents
Heading one of the blog
Heading one of the blog
Heading one of the blog
Heading one of the blog
Heading one of the blog
Heading one of the blog

Must read resources

Ready to Stop Guessing and Start Growing?

Ready to see how Saras Pulse can transform your e-commerce marketing strategy ?