Blog

  • 6 Data Analytics Tools to Consider in 2026

    6 Data Analytics Tools to Consider in 2026

    Choose the right workflow for the question you need to answer

    TL;DR: Choose an analytics tool based on the question, the data and who needs to check the result. Excel suits workbook calculations; SQL helps inspect database records; Python with pandas supports repeatable data preparation; Power BI and Tableau support shared reporting and visual analysis; and QuaerisAI supports questions across governed business data. These tools can work together. Test one real business question, then compare correctness, permissions, source traceability and repeatability before choosing a workflow.

    Your dashboard shows more leads. Sales says the leads are weaker. Finance wants to know whether the extra spend paid off.

    At that point, the question is not just which analytics tool to open. The better starting point is understanding the question, the available data, and who needs to check the result.

    Excel, Power BI, Tableau, SQL, Python, and QuaerisAI can all support analytics work, but they serve different purposes.

    Excel is useful for workbook-based investigations. Power BI and Tableau support shared reporting and visual analysis. SQL and Python help analysts prepare, test, and transform data. QuaerisAI supports questions across governed business data.

    These workflows can complement one another in the same analytics process.

    This guide is an editorial shortlist, not a performance benchmark. QuaerisAI is included because it is our offering, but the numbering does not indicate rank.

    Compare the job before comparing the product

    Analytics work usually moves through preparation, calculation, reporting, and investigation.

    Different tools are stronger at different stages. Before comparing products, compare the job the team needs to do.

    The point is simple: start with the work, then choose the tool.

    A team inspecting workbook formulas has a different need from a team governing metric definitions across departments. A data analyst checking joins has a different job from a business user asking why a campaign changed.

    The wrong tool may still produce an output. The better tool gives the team a result they can understand, check, and repeat.

    A language and a platform are different decisions

    Python and SQL should not be evaluated in the same way as BI platforms.

    Python is a programming language. pandas is an open-source Python library for working with data. SQL is a language used to query databases. They are powerful, but they still require an execution environment, maintenance, access controls, and people who can review the work.

    AI assistance can make coding and querying faster, but it does not automatically turn Python or SQL into governed analytics products.

    For buyers, the practical question is whether the team can maintain the workflow, control access, check the logic, and repeat the result later.

    Start with the question your current setup cannot answer

    Most organizations already have analytics tools. The real buying question is usually about the gap.

    What question is your current setup struggling to answer?

    For some teams, the issue is exploration. Users can see a dashboard, then struggle to ask the next question.

    For others, the issue is repeatability. A useful analysis exists, but it depends on one analyst, one script, or one workbook.

    For regulated or enterprise teams, the issue may be traceability. The result exists, but the team cannot clearly show which definition, source, permission, or calculation produced it.

    A good evaluation should start with a specific workflow, not a generic feature checklist.

    Ask:

    Who asks the question?

    Who owns the metric?

    Who fixes the data?

    Who checks the result?

    Can the workflow be repeated?

    The answers will show where the bottleneck sits.

    Where each tool earns its place

    1. QuaerisAI for governed business questions

    Evaluate QuaerisAI when business users need to ask questions across governed enterprise data.

    A useful test is to start with an ambiguous term such as active customer. Ask the system to define the metric, show the source, and repeat the question with a restricted user.

    The goal is to see whether the workflow respects definitions, permissions, and traceability.

    This is especially relevant when teams need results that can be checked later, rather than one-off outputs that are difficult to reconstruct. [2, 3]

    2. Power BI for shared reporting and follow-up analysis

    Consider Power BI when reports and semantic models already support your Microsoft workflow.

    Power BI is useful for shared dashboards, recurring reporting, and business reviews where the organization has already invested in semantic models and permissions.

    Copilot can assist with reporting, summaries, and data questions, but the experience still depends on the underlying model, capacity eligibility, and enablement.

    A practical test is to use a trusted measure and check whether users can understand the result, share it appropriately, and continue the analysis without creating confusion. [4]

    3. Tableau for visual investigation

    Tableau supports visual investigation and chart authoring.

    It is useful when users need to compare regions, change measures, and inspect how a visual changes when the view changes.

    Tableau Agent can assist with charts, calculations, and filters, but teams should confirm supported operations, deployment eligibility, and access in their own environment.

    A useful test is to request a regional comparison, change the measure, and inspect what stayed constant. [5]

    4. Python with pandas for repeatable data preparation

    Use Python with pandas for recurring cleaning, joins, grouping, reshaping, and tabular analysis.

    It is flexible, but it still needs maintenance. Someone must review the code, manage changes, check AI-generated edits, and test edge cases such as missing values or duplicates.

    The main risk is treating a script as reliable just because it runs.

    A good workflow checks the data before trusting the totals. [6]

    5. SQL for examining the data behind the result

    SQL helps analysts filter, join, and aggregate structured database tables.

    It is useful for checking the data behind reports, dashboards, and AI-generated outputs. It can also help confirm whether the right records are included in a result.

    The common risk is join logic. A query can multiply transactions, exclude records, or produce a misleading total if the relationships are wrong.

    SQL gives control, but it does not guarantee correct analysis by itself. [7]

    6. Excel for collaborative workbook analysis

    Excel supports formula inspection, scenario analysis, and workbook-based collaboration.

    It is familiar and flexible, especially for finance and planning workflows where teams need to see the calculation directly.

    Copilot can assist in Excel depending on license, app, and configuration. Teams should still keep a known reference calculation and review changes before sharing.

    Recurring workbooks need ownership, version control, and review discipline. [8]

    What 2026 research changes about the buying decision

    Enterprise AI adoption is moving from isolated experiments toward broader deployment.

    McKinsey’s August 2026 survey reported enterprise AI scaling rising from 38 percent to 44 percent of respondents. This describes broader adoption, not any analytics product’s market share or effectiveness. [10]

    The practical takeaway for buyers is that AI capability alone is not enough. Teams need to understand whether AI can work inside their definitions, permissions, workflows, and review standards.

    Context is becoming a buying criterion

    A major analytics challenge is getting AI systems to understand business context.

    Alteryx’s August 2026 study reports that 53 percent of surveyed organizations struggle to translate business context into AI workflows. The vendor-sponsored research was based on a Coleman Parkes survey of 1,400 technology leaders. [11]

    For analytics buyers, the practical implication is clear: demos should test more than the interface.

    They should test:

    metric definitions

    exceptions

    access rules

    source visibility

    permission handling

    what happens when the system does not have enough information

    A clean demo is useful. A workflow test is better.

    Research is moving beyond isolated queries

    Analytics evaluation is also moving beyond simple question-and-answer tests.

    The September 2026 BI-Agent and BI-Bench preprint evaluates tasks such as finding tables, transformations, and joins. The authors report below-50 percent accuracy for the frontier LLMs tested, improving with their specialized approach. The benchmark does not compare the six tools in this guide; it supports testing complete workflows. [12]

    That matters because a tool may answer a clean prompt in a demo.

    The real test is whether it can handle the path from question to source, transformation, calculation, validation, and review.

    Product changes can make tutorials outdated

    Analytics products are changing quickly.

    Microsoft retired Excel’s preview COPILOT function on September 14, 2026, while the Copilot pane remains. Power BI and Tableau also offer conversational assistance within established BI environments. [4, 5, 13]

    The lesson is simple: check current product availability before relying on a tutorial, demo, or old implementation note.

    Product packaging, eligibility, licensing, and supported features can change. The evaluation should be based on the current environment your team will actually use.

    Compare workflows with one real business question

    The best way to evaluate analytics tools is to test one real business question across workflows.

    Some follow-up questions need new modeling or specialist work. Others can be answered with already-approved data and definitions. Both paths are valid, but they should be measured against the same standards.

    Figure 3. Two illustrative follow-up paths. Both can exist in the same platform; this is not a timing benchmark.

    Now try a simple test.

    These fictional campaigns use the same period:

    Ask your chosen tool:

    “Calculate customer conversion rate and cost per customer by campaign. Show the formulas. Then calculate the combined conversion rate. Explain whether these numbers alone justify a budget change.”

    Before calculating, predict which campaign has the highest lead-to-customer conversion rate.

    Then test the follow-up:

    “What if customer counts include duplicates across campaigns?”

    A useful response should request the relevant identifiers or explain the limitation. It should not silently treat those customer counts as unique people if that has not been established.

    Record:

    correctness

    time to a checked result

    analyst help required

    repeatability

    whether the tool explains limitations

    whether it can be tested with fresh data

    whether it respects a restricted user’s permissions

    Check the result, then check the workflow

    The combined conversion rate is 75 customers divided by 1,100 leads, or 6.82 percent, assuming consistent counting rules. Averaging the three campaign percentages gives the wrong combined rate.

    This small example shows why analytics evaluation should go beyond whether the tool returns a number.

    Partner has the highest conversion rate. Social has the lowest cost per customer. Neither finding establishes profitability or proves that the budget should change. A real decision would need more evidence, including customer value, attribution, and duplicate handling.

    What to measure in the evaluation

    When testing any analytics workflow, separate the measures.

    Look at:

    whether the result was correct

    how long it took to reach a checked result

    how much analyst help was needed

    whether the result could be repeated

    whether definitions were clear

    whether permissions were respected

    whether the source could be inspected

    whether the tool explained limitations instead of guessing

    Then repeat the test with fresh data and a restricted user.

    That final step matters. A workflow that works for an admin user may fail when access rules, incomplete data, or ambiguous terms are introduced.

    Choose the workflow your team can trust and repeat

    The best analytics tool is not always the most advanced one.

    It is the one that fits the question, the user, the data, and the review standard.

    Use Excel when the work belongs in a workbook and the logic needs to be inspected. Use SQL when you need to examine structured data behind the result. Use Python with pandas when the work requires repeatable preparation and custom analysis. Use Power BI or Tableau when the team needs shared reporting and visual analysis.

    Evaluate QuaerisAI when business users need governed questions across enterprise data with definitions, permissions, and source traceability in the workflow.

    To evaluate QuaerisAI, bring a real question, the definition behind it, and a reference result. Ask for a checked result, then change the question and permissions. Judge the workflow by what it improves. [2]

    That is the clearest way to compare analytics tools in 2026: start with the work, test the workflow, and choose the tool your team can trust enough to repeat.

  • The Language Between LLMs and Charts

    The Language Between LLMs and Charts

    TL;DR

    • A convincing chart can still answer the wrong question. Terms such as “performance,” “average,” and “underperformer” require clear business definitions before AI generates a visualization.
    • Preserve intent from question to chart. Metric selection, calculations, filters, comparisons, and visual emphasis must remain aligned. Low revenue, for example, does not necessarily mean a region missed its target.
    • Structured specifications make charts easier to inspect and revise. ThoughtSpot’s ChartSpec separates AI interpretation from software-driven chart construction and validation. It is a vendor implementation, not a universal industry standard.
    • Follow-up questions should maintain analytical continuity. Changing a highlight or reporting period should preserve other relevant choices unless the user requests otherwise.
    • Chart specifications alone cannot establish trust. Enterprise analytics also needs consistent business definitions, appropriate access controls, reliable calculations, and traceability.
    • Conversational analytics is evolving. The blog discusses Google Cloud, Tableau, and Microsoft approaches that connect natural-language interaction with semantic models, agents, or approved visual answers.
    • Evaluate beyond the first chart. Ask a business question, request a target comparison, change the reporting period, ask why something is highlighted, and inspect whether the interpretation remains consistent. Ambiguity should trigger clarification.
    • Quaeris.AI’s focus is governed agentic analytics. Its positioning connects business context, trusted AI agents, and controlled decision support. Specific capabilities should be assessed through demonstrated product workflows.

    The central takeaway: Trustworthy AI analytics must help users understand why an answer deserves confidence—not simply produce charts quickly.

    Building Trustworthy AI Analytics for Enterprise Decisions

    The Language Between LLMs and Charts: Why Enterprise AI Needs More Than an Answer

    Some of the most dangerous words in enterprise analytics are the shortest ones. Average. Performance. Underperformer. Each sounds precise. Each hides a decision that changes what a chart actually says.

     Marketing sees a campaign performing exceptionally well. Finance questions the revenue calculation. Sales asks why existing customers were included in a new-business comparison.

    Everyone is looking at the same visualization. Yet everyone may be interpreting a different answer.

    This is one of the challenges of conversational analytics: An AI system can generate a chart that looks convincing without necessarily capturing the business question correctly.

    Large language models (LLMs) make it easier than ever to ask questions in natural language. You can type, “Show me sales by region, highlight the underperformers, and add an average line.” But turning that request into a reliable business answer requires more than generating a chart.

    Which sales metric should be used? What defines an underperformer? Should the average be calculated across regions or weighted by sales volume? Which data should the user be allowed to access?

    These decisions determine what the visualization communicates.

    The missing piece is a structured connection between human intent, business meaning, analytical calculations, and visual representation.

    And as enterprise organizations move toward agentic analytics, that connection becomes increasingly important.

    The Real Problem: An LLM Can Understand a Question. Can It Preserve Its Meaning?

    A natural-language request often appears simple.

    “Show campaign performance by region, highlight the underperformers, and add an average.”

    But what does performance mean?

    • Revenue generated?

    • Qualified leads?

    • Conversion rate?

    • Return on advertising spend?

    And what does underperformer mean?

    • A region below its target?

    • A region performing below the company average?

    • A region declining compared with the previous period?

    Even the word average requires context. An average across regional revenue may answer a different question from an average transaction value.

    Before a visualization is created, the system needs to resolve these ambiguities.

    This matters because a chart can be technically well-rendered and still answer the wrong question.

    Consider a sales manager who wants to identify regions missing their targets.

    A chart that simply highlights the shortest revenue bars could mislead the manager. A smaller region may have lower revenue but still exceed its target, while the region with the highest revenue may be underperforming against its own goal.

    Revenue determines the bar length. Performance against target determines the emphasis.

    The distinction is not cosmetic. It changes the business interpretation.

    From Business Question to Reliable Visualization

    A dependable AI analytics experience needs a way to preserve the meaning of a user’s request throughout the analytical process.

    Each stage addresses a different potential failure.

    A metric can be defined incorrectly. A calculation can use the wrong population. A chart can emphasize a comparison that does not match the question. A visual can be technically correct but difficult to interpret.

    The objective is not merely to generate an attractive chart. It is to create a visual representation that users can examine, question, and refine.

    What ChartSpec Teaches Us About AI-Generated Charts

    ThoughtSpot’s ChartSpec provides an example of how a structured language can connect analytical intent with visualization.

    According to ThoughtSpot’s explanation, ChartSpec describes visual elements and relationships, allowing software to construct and validate chart structures. It separates the model’s interpretation from the code that generates the visualization.

    This approach illustrates an important principle: AI should not have to communicate its entire analytical intent through an unconstrained visual output.

    A structured representation can make parts of that intent explicit, including:

    • Which fields are being used.

    • How data is grouped or compared.

    • Which calculations are applied.

    • What visual emphasis is required.

    • How follow-up changes should be handled.

    For example, a user might say: “Keep the same comparison, but highlight regions below target.”

    The intended change is narrow. The measure, reporting period, and population should remain consistent unless the user requests otherwise.

    A structured representation provides a way for software to distinguish the requested edit from an unintended change to the analysis.

    ChartSpec is ThoughtSpot’s implementation, not an established universal industry standard. Its broader lesson is that the meaning behind a chart needs a representation that systems can inspect and revise.

    Why Business Context Matters More Than Ever

    The language between LLMs and charts is only one part of the larger enterprise analytics challenge.

    A chart specification can describe how a metric should be displayed. It does not, by itself, determine whether the underlying metric has the correct business definition or whether the user should have access to the data.

    These responsibilities must work together.

    1. Business definitions

    Two departments may use the same term but mean different things. For example, revenue could refer to recognized revenue, billed revenue, or a particular reporting period. AI analytics needs access to the relevant business definitions to avoid confusing similar concepts.

    2. Governed access

    Enterprise data is not universally accessible to every user. Role-based permissions and appropriate access controls are important when analytics systems interact with sensitive business information.

    3. Calculation consistency

    A chart should use the appropriate calculation for the question. An average, growth rate, or comparison can produce different interpretations depending on the underlying data and formula.

    4. Traceability

    When a business user questions an insight, they should have a way to understand the basis of the answer where the system supports it.

    Together, these considerations point toward a broader principle:

    Trustworthy AI analytics requires more than conversational interaction. It requires governed meaning, reliable calculations, and transparent analytical behavior.

    What the Industry Is Moving Toward?

    Developments across the analytics industry demonstrate that conversational analytics is expanding beyond simple question-and-answer experiences.

    Google Cloud has described conversational analytics capabilities in BigQuery and Looker, including workflows involving data exploration and agents. Tableau has discussed conversational experiences grounded in semantic models and connections to external agents. Microsoft Power BI includes verified answers for recurring questions through approved visual responses.

    These approaches operate at different layers of the analytics experience. They do not establish a shared industry-wide chart specification standard.

    However, they illustrate an important direction: enterprises need ways to combine natural-language interaction with business definitions, data access, and consistent analytical outputs.

    For organizations evaluating AI analytics platforms, the important question is not simply: “Can the system generate a chart?”

    It is: “Can the system preserve the meaning of my business question and help me trust the answer?”

    From AI-Generated Insights to Governed Agentic Analytics

    This is where the conversation extends beyond chart generation.

    Enterprise teams increasingly want AI to do more than retrieve information. They want systems that can help investigate trends, identify exceptions, explain performance changes, and support business decisions.

    But increased autonomy also raises important questions:

    • Which data can an agent access?

    • Which business definitions should it use?

    • How are calculations validated?

    • Can users understand the basis of its conclusions?

    • What happens when the question is ambiguous?

    At Quaeris.ai, our positioning around Governed Agentic Analytics is built around the importance of trusted analytics, business context, and controlled AI-driven decision support.

    Our perspective is that enterprise AI should not be defined only by how naturally it can respond. It should also be evaluated by how reliably it operates within the business’s definitions, permissions, and governance requirements.

    That means the conversation should move beyond “Ask your data anything” toward a more meaningful question:

    Can your AI help your teams make decisions using analytics they can trust?

    Quaeris.ai’s specific capabilities, integrations, and validation mechanisms should be evaluated against this principle and demonstrated through real product workflows.

    A Practical Way to Evaluate AI Analytics

    The next time you evaluate an AI-powered analytics experience, don’t stop after the first chart.

    Try a short sequence of follow-up questions.

    Step 1: Ask a business question

    “Show campaign performance by region.”

    Step 2: Request a comparison

    “Highlight regions performing below their targets.”

    Step 3: Change the reporting period

    “Now show the same analysis for the previous quarter.”

    Step 4: Ask for an explanation

    “Why is this region highlighted?”

    Step 5: Inspect the answer

    Check whether the definitions, calculations, filters, and visual emphasis still match the original intent.

    This sequence can help reveal whether the system handles analytical continuity and transparency effectively.

    A reliable experience should also be willing to ask for clarification when the question is ambiguous.

    For example: “When you say ‘best campaign,’ do you mean revenue, profitability, or conversion rate?”

    Sometimes the most useful response an AI system can provide is not a chart. It is a clarifying question.

    The Future of AI Analytics Is More Than Faster Charts

    The evolution of conversational analytics is not simply about making chart generation faster.

    It is about making the relationship between questions, data, calculations, and visual explanations more dependable.

    As AI analytics becomes part of enterprise workflows, users will increasingly expect to:

    • Understand what a metric represents.

    • Inspect the basis of an analytical answer.

    • Refine a visualization without accidentally changing the underlying question.

    • Work with data within appropriate governance controls.

    • Move from insights toward informed business decisions.

    A structured language between LLMs and charts is one possible component of that future. It helps make visual intent more explicit and provides a basis for examination and revision.

    But reliable enterprise analytics requires the larger system to work together: business meaning, governed data, analytical reasoning, and visualization.

    The real test of AI analytics begins after the first chart.

    When someone points to a visualization and asks, “Why should I believe this?”—the system should have a meaningful way to help them understand the answer.

    How Quaeris.ai Approaches Trusted Analytics

    Enterprise decisions deserve more than fast answers. They need context, consistent metrics, and governance.

    Quaeris.ai’s Governed Agentic Analytics positioning focuses on connecting enterprise analytics with trusted AI agents and decision intelligence.

    Explore how Quaeris.ai can support your organization’s approach to governed analytics and AI-driven decision-making.

    Ready to Explore Governed Agentic Analytics? Discover how Quaeris.ai approaches trusted analytics and enterprise decision intelligence.
  • Self-Service Analytics for Retail

    Self-Service Analytics for Retail

    TL;DR

    Retail self-service analytics should be measured by whether users reach usable answers with less rework, not by dashboard volume alone. PAYBACK’s example shows why shared definitions, access controls, source evidence, and a clear escalation path matter when campaign teams need to move from report to decision.

    From Coupon Counts to Answers That Drive Decisions

    A loyalty manager can already see total coupon redemptions, but the real question is why certain stores underperformed. Was it a stock issue? A timing issue? A customer eligibility issue? Or did the campaign simply fail to drive the expected behavior? 

    Answering that follow-up usually means another report request. 

    By the time the answer arrives, the next promotion may already be underway. 

    That is the practical problem self-service analytics is supposed to solve. The value is not just giving users another dashboard. It is helping business teams investigate approved data, ask the next question, and move toward a decision without waiting for every variation to become a specialist request. 

    PAYBACK’s experience offers a useful example for retail marketing, loyalty, and analytics leaders thinking about what effective self-service should look like. 

    What PAYBACK Changed 

    According to ThoughtSpot’s PAYBACK customer story, PAYBACK’s earlier reporting environment required technical intervention even for small adjustments. Reporting backlogs delayed answers, and users relied on email and spreadsheets to get the views they needed. 

    With ThoughtSpot, employees could explore coupon performance at individual stores on specific days in near real time. The story also describes independent performance monitoring across retail partners and more time for analysts to focus on strategic work. 

    PAYBACK’s reported self-service footprint included: 

    • 70+ major retail partners 
    • 300+ user-created Liveboards 
    • 150 standard reports 

    These figures are useful as adoption indicators, but they should not be read as active-user rates, answer accuracy measures, or financial return. They show scale and content creation, not the full quality of decision-making. 

    That distinction matters. 

    Self-service analytics should not be evaluated only by the number of dashboards or reports created. A better question is whether users can reach usable answers with less rework, while still relying on shared definitions, appropriate access, and evidence they can inspect. 

    The Real Test Is the Follow-Up Question 

    Retail teams rarely stop at the first answer. 

    A campaign dashboard may show that one store group had lower coupon redemptions. But the next questions come quickly: 

    Which locations underperformed? 

    Were campaign dates aligned? 

    Were the products available? 

    Were customers eligible? 

    Did the same pattern appear across partners? 

    Was the comparison based on the same reporting window? 

    Before interpreting the result, the team also needs to agree on the measure itself. “Redemption rate” can mean different things depending on the denominator. It could be issued coupons, activated offers, or eligible customers. 

    If those definitions are unclear, self-service can spread confusion faster than traditional reporting ever did. 

    This is where retail analytics needs more than access. It needs a workflow that helps users understand what they are asking, what data is being used, and whether the answer is reliable enough to support action. 

    Why Self-Service Still Needs Guardrails 

    Self-service analytics does not remove the need for analysts, definitions, or governance. It changes where those controls need to show up. 

    A business user should be able to explore approved data without opening a ticket for every follow-up. But that exploration still needs boundaries. 

    The system should help users confirm: 

    • which metric definition is being used 
    • which dates and stores are included 
    • which source data supports the answer 
    • whether the user has access to the right scope 
    • when the question needs analyst review 

    For example, a stock shortage may call for an operational fix. A question about whether a promotion drove incremental sales may require a comparison group and deeper analyst support. Higher redemptions alone do not prove incremental revenue. 

    A useful self-service workflow should make that distinction clear. 

    A Better Way to Pilot Self-Service Analytics 

    For retail teams evaluating self-service analytics, the best pilot does not start with a broad rollout. It starts with one recurring campaign question that already creates reporting friction. 

    For example: 

    Which stores underperformed during our latest coupon campaign? 

    From there, the team can test the workflow end to end. 

    Figure 2  A pilot that follows the question through to review. 

    Start by defining the metric. Confirm what “underperformance” means and how the calculation is handled. 

    Next, check the scope. Confirm campaign dates, eligible customers, participating stores, and user permissions. 

    Then inspect the answer. Review the source, metric definition, reporting date, and any missing information. 

    Finally, test a follow-up that changes the decision. For example: 

    Does the difference remain when we compare the same campaign days? 

    This kind of pilot is more useful than a polished demo because it shows whether the system can support a real business investigation. 

    Measure Useful Independence 

    A strong self-service pilot should not only ask whether users can create more views. It should measure whether users reach better answers with less rework. 

    Before the pilot begins, teams should agree on success criteria. 

    Useful measures include: 

    • time from question to reviewed answer 
    • routine questions resolved without a specialist ticket 
    • answers accepted without correction 
    • users returning for later analysis 
    • answers linked to a documented business decision 

    This creates a more practical basis for expansion than dashboard count alone. 

    It also keeps teams honest. A shorter reporting queue is only useful if the work has not simply moved elsewhere, into more preparation, more corrections, or more hidden support from analysts. 

    Where QuaerisAI Fits 

    QuaerisAI helps teams connect business questions to definitions, source traceability, and access controls. 

    For retail and CPG teams, that can support use cases across merchandising, inventory, demand, and trade-promotion analysis. The useful test is not whether the platform can answer a polished demo question. The useful test is whether it can support the way campaign teams actually investigate performance across the systems they already use. 

    A QuaerisAI demo should make the answer inspectable. 

    For a question like “Which stores underperformed during our latest coupon campaign?”, the review should show: 

    • how underperformance is defined 
    • which source data supports the answer 
    • which dates and stores are included 
    • what scope the user is allowed to see 
    • whether the evidence is strong enough to act on 
    • when a follow-up requires analyst review 

    That is the difference between self-service as dashboard access and self-service as a decision workflow. 

    Give the Next Question a Clear Path 

    Retail analytics does not fail because teams lack dashboards. It often fails because the next question has nowhere clean to go. 

    Self-service works when users can continue a useful investigation, understand the answer, and recognize when specialist help is needed. 

    Start with one campaign question that repeatedly returns to the reporting queue. Define what a trustworthy answer requires. Then test the workflow against it. 

    Bring one recurring campaign question to a QuaerisAI demo. Review the metric definition, source data, access scope, and follow-up workflow behind the answer. 

  • Analytics Without Data Movement: Why Level-Zero Data Should Stay in Source

    Analytics Without Data Movement: Why Level-Zero Data Should Stay in Source

    TL;DR 

    “Analytics without data movement” is an architectural approach where your business intelligence (BI) layer queries data where it already lives in your warehouse, lakehouse, or operational database instead of copying raw, granular records into a separate analytics platform or the vendor’s cloud. The most sensitive layer of your data, often called level-zero data (the raw, row-level source of truth), never leaves the source system. 

    Why it matters. Every copy of raw data you create is a new place it can leak, a new system to govern, and a new jurisdiction it might cross. The traditional “extract everything into the analytics tier first” model quietly expands your attack surface and complicates data residency compliance. The average data breach now costs $4.88 million globally, and cumulative GDPR fines have passed €7.1 billion — so an extra unguarded copy of your customer data is not a small liability. 

    Key takeaways. 

    Copying level-zero data into a BI platform creates a second, often less-governed, attack surface. 

    Query-in-place (zero-copy) analytics sends the query to the data instead of moving the data to the query. 

    Keeping data in source preserves existing permissions, encryption, and residency boundaries if a user can’t see a row in the source, they can’t see it in analytics. 

    This is a defensible, technical-buyer message: fewer copies, less leakage surface, simpler compliance. 

    Who should read this. Security and compliance leaders, data platform owners, and architects who need analytics to be useful and safe — and who are tired of choosing between the two. 

    Ready to see how it works? 

    Table of Contents 

    What “Analytics Without Data Movement” Actually Means 

    The Hidden Cost of the Traditional BI Copy Model 

    What Is Level-Zero Data — and Why It’s the Real Risk 

    How Query-in-Place Analytics Works 

    Data Residency: The Compliance Case for Keeping Data in Source 

    Security Benefits: Shrinking the Attack Surface 

    Architecture Patterns and How to Choose 

    Implementation: A Practical Migration Path 

    Real-World Scenarios 

    Common Mistakes to Avoid 

    Advanced Insights and Future-Proofing 

    Frequently Asked Questions 

    Conclusion 

    Introduction 

    Here’s a question most analytics buyers never ask their BI vendor: Where does my raw data physically go the moment I connect you? 

    For most traditional business intelligence tools, the answer is uncomfortable. To make dashboards fast, the platform ingests your data — it copies granular, row-level records out of your warehouse and into its own analytics engine, its own cache, and frequently its own cloud. You connected a reporting tool. What you actually did was create a second full copy of your most sensitive data in a system your security team may not fully control. 

    For years this was treated as the unavoidable cost of doing analytics. Fast dashboards required local copies; local copies required data movement; data movement was just how BI worked. But that assumption is now expensive in three different currencies: security risk, compliance exposure, and operational drag. 

    The regulatory environment has made the stakes concrete. Global enterprises now navigate 120+ data protection regulations across 190+ countries, GDPR penalties can reach €20 million or 4% of global turnover, and the average breach costs nearly $5 million. In that world, every redundant copy of raw customer data is a standing liability — not a convenience. 

    This article makes the case for a different default: analytics without data movement. We’ll define what level-zero data is and why it’s the part that actually matters, walk through how query-in-place analytics works, and lay out the security, residency, and architectural reasons to keep raw data in its source. By the end you’ll have a clear framework for evaluating any analytics tool through a single lens — does this make another copy of my data, or not? 

    What “Analytics Without Data Movement” Actually Means 

    Analytics without data movement is exactly what the name implies: you analyze data without first relocating it. Instead of the data traveling to the analytics engine, the query travels to the data. The raw records stay in their system of record; only the computed result — an aggregate, a chart, a number comes back. 

    It helps to contrast two mental models. 

    The traditional model: move data to the query. You build pipelines (ETL/ELT) that extract raw data from source systems, transform it, and load it into a separate analytics store. Your BI tool then queries that copy. The data has physically moved, often multiple times, and now exists in more than one place. 

    The query-in-place model: move the query to the data. Your analytics layer connects above the data, issues a query directly against the source (or a governed semantic layer over it), and retrieves only the result set. Raw data is read where it lives and is never persisted into a separate analytics platform. 

    The core idea in one sentence: Don’t bring the data to the question — bring the question to the data. 

    You’ll encounter several overlapping terms for this approach, and it’s worth knowing how they relate: 

    Term 
    What it emphasizes 
    Zero-copy analytics 
    No duplicate physical copy of the raw data is created 
    Query-in-place / query data in place 
    Computation happens against data in its original location 
    No data movement BIThe BI tool reads but does not relocate source data 
    Query federationA single query interface spans multiple distributed sources without consolidating themData residency analyticsAnalytics that respects where data is legally required to stay 

    These aren’t identical, but they share one governing principle: the authoritative, granular data stays put. That principle is the entire point and the source of every benefit that follows. 

    The Hidden Cost of the Traditional BI Copy Model 

    The conventional analytics stack looks reasonable on an architecture diagram. Source systems on the left, pipelines in the middle, a warehouse and BI tool on the right. Clean arrows, left to right. The problem is what those arrows actually represent: every arrow is a copy of your data crossing a boundary. 

    Consider what a single dashboard often requires under the traditional model: 

    Raw data extracted from an operational database into a staging area. 

    Transformed and loaded into a central warehouse. 

    Extracted again into the BI tool’s own engine or in-memory cache for speed. 

    Sometimes replicated into the BI vendor’s managed cloud for processing. 

    That’s potentially four locations holding row-level data, each with its own access model, encryption posture, logging, and — critically — its own breach blast radius. As industry analysts of federated architectures put it, centralizing everything “creates a larger consolidated attack surface through data duplication and movement.” 

    The costs compound across four dimensions: 

    Security. Each copy is an independent thing to secure, patch, monitor, and eventually decommission. The BI vendor’s cloud becomes, in effect, an extension of your own data perimeter — but one you don’t operate. As one zero-copy proponent bluntly notes, copying data to the analytics tier “creates yet another point of security failure.” 

    Compliance. A copy in a different region can silently breach data residency rules. And under regulations like GDPR, your deletion obligations don’t stop at the source — deletion must propagate to “backups, logs, analytics systems, and ML training data.” Every copy you made is now a copy you must prove you erased. 

    Cost. You pay to store the same data multiple times, pay to run the pipelines that move it, and pay engineers to maintain those pipelines when schemas change. 

    Freshness. Data that has to be copied is, by definition, stale between syncs. By the time it lands in the warehouse and then the BI cache, “the data is stale by the time it reaches the warehouse.” Decisions get made on yesterday’s numbers. 

    The uncomfortable summary: the traditional model treats making more copies of sensitive data as the foundation of analytics. Everything downstream the governance burden, the residency headaches, the breach exposure flows from that one starting decision. 

    What Is Level-Zero Data and Why It’s the Real Risk 

    Not all data carries equal risk. To understand why “no data movement” matters so much, you have to distinguish between the layers of an analytics stack. 

    Level-zero data is the raw, granular, row-level source of truth — individual transactions, customer records, line items, event logs. It’s the most detailed and therefore the most sensitive form your data takes. A single level-zero row might contain a named customer, their purchase, their location, and a timestamp. It is precisely the data that regulators care about and attackers want. 

    Above level zero sit the things analytics actually delivers: 

    Aggregates -“total revenue by region this quarter.” 

    Metrics and KPIs – derived numbers, often stripped of personal identifiers. 

    Visualizations – charts and dashboards that present those aggregates. 

    Here’s the crucial insight: business users almost never need level-zero data itself. They need answers derived from it. A regional sales leader asking “how did we do last quarter?” needs a number, not a download of every customer transaction. 

    Yet the traditional BI model copies all of level zero into the analytics tier just so it can compute those aggregates locally. You move the riskiest possible data every raw row  in order to produce results that contain almost none of that risk. 

    The asymmetry that defines the problem: the data that’s dangerous to move (raw level-zero rows) is rarely the data anyone actually wants to see. The data people want (aggregates and answers) is comparatively safe. Analytics without data movement exploits this asymmetry: keep the dangerous layer in source, and let only the safe layer travel. 

    This is why “keeping level-zero data in source” is not a minor technical preference. It’s a direct reduction of the single largest category of data risk in your analytics pipeline. 

    How Query-in-Place Analytics Works 

    If the data isn’t moving, how do you actually get an answer? The mechanics are more straightforward than they sound. 

    A query-in-place analytics platform sits above the data layer rather than ingesting from it. When a user asks a question, the platform: 

    Interprets the request and resolves it against a semantic understanding of where the relevant data lives which tables, which sources, which joins. 

    Generates the correct query (typically SQL) for the underlying source system. 

    Pushes that query down to the source, where the source’s own engine executes it against level-zero data in place. 

    Returns only the result set the aggregate, the rows that match, the computed metric to be rendered for the user. 

    The raw data is read and processed inside the source’s security perimeter. As one federation architecture describes it, queries are “retrieved dynamically and processed in memory without being stored locally,” and “the data never crosses the perimeter.” 

    Here’s the flow as a diagram: 

    TRADITIONAL BI (data moves) 

    ┌──────────┐   copy raw    ┌──────────┐   copy raw   ┌──────────┐ 

    │  Source  │ ─────────────▶│Warehouse │ ────────────▶│ BI Engine│ 

    │(level-0) │   rows out    │ (level-0)│   rows out   │ (level-0)│ 

    └──────────┘               └──────────┘              └────┬─────┘ 

       3+ copies of raw data, 3 attack surfaces             │ charts 

                                                              ▼ 

                                                           👤 User 

    QUERY-IN-PLACE (query moves) 

    ┌──────────┐                              ┌─────────────────────┐ 

    │  Source  │◀──── query pushed down ──────│  Analytics Layer    │ 

    │(level-0) │                              │  (sits above data)  │ 

    │  stays   │───── only results back ─────▶│                     │ 

    └──────────┘    (aggregates, not rows)    └─────────┬───────────┘ 

       1 copy of raw data, 1 attack surface             │ charts 

                                                          ▼ 

                                                       👤 User 

    A modern natural-language analytics layer adds one more capability on top: it lets users ask questions in plain English, then translates those into the correct query for the source. As Quaeris describes its own approach, an “agentic layer turns natural language into the correct query,” learning the structure of the SQL housing your data so that “if you can think of a question to ask,” the system can answer it directly against your source without that source data ever being copied to the analytics platform or its cloud. 

    The result is the best of both worlds in principle: the accessibility of self-service BI, without the data-duplication tax that normally comes with it. 

    Data Residency: The Compliance Case for Keeping Data in Source 

    Data residency is where “no data movement” stops being an architectural nicety and becomes a compliance necessity. 

    Data residency refers to the physical or geographic location where data is stored and processed. Data localization is the stricter cousin — a legal requirement that certain data must remain within a specific territory and cannot be transferred outside it at all. Both are enforced with growing seriousness: in 2025, regulators began penalizing organizations “not just for breaches but for improper data transfers or lack of proper localization strategies.” 

    Now overlay the traditional BI model on this. The moment your analytics tool copies EU customer data into a US-region processing cluster or into the vendor’s globally distributed cloud you may have created a cross-border transfer you never intended. You didn’t change your storage policy; you just connected a dashboard. But the data moved, and movement is exactly what residency law governs. 

    Query-in-place analytics sidesteps this category of problem structurally. Because raw data never leaves its source: 

    Data stays in its required jurisdiction. If your EU data is in an EU-region warehouse, queries run there and only aggregated results travel. The level-zero records never cross the border. Running live queries “maintains data residency, sovereignty, and compliance, especially across complex, distributed IT landscapes.” 

    Deletion obligations shrink. GDPR’s “right to erasure” requires deletion to propagate to every system holding the data, including analytics. If analytics never held a copy, there’s nothing extra to find, delete, and prove deleted. 

    Audit scope narrows. Fewer copies means fewer systems an auditor has to inspect to confirm where regulated data resides. 

    The financial stakes make this worth designing for. GDPR penalties reach €20 million or 4% of global turnover, enterprises report $500K+ annual costs just for handling data-subject requests, and a single complex request can consume 40–80 hours of manual work. An architecture that simply doesn’t replicate regulated data into new locations removes whole branches of that workload before it starts. 

    Compliance reframed: The cheapest data to keep compliant is the copy you never made. 

    Security Benefits: Shrinking the Attack Surface 

    Security teams have a useful instinct: the safest data is data that doesn’t exist where it doesn’t need to. Analytics without data movement is a direct application of that instinct. 

    1. A smaller attack surface. Every copy of level-zero data is a target. Eliminate the analytics-tier copy and you eliminate an entire class of breach scenario the one where attackers exfiltrate raw records from a BI cache, an export, or the vendor’s cloud rather than from your hardened source. Federated, no-movement designs “reduce the attack surface by minimizing data copying.” 

    2. Existing controls are preserved, not re-implemented. When data stays in source, your existing encryption, network controls, and access policies continue to apply unchanged. You don’t have to rebuild — and keep in sync a parallel security model inside the BI platform. As zero-copy advocates note, the approach keeps data “in its original source… while preserving existing security controls and encryption.” 

    3. Permission inheritance closes the “shadow access” gap. One of the quiet dangers of copied data is permission drift: a user who can’t see certain rows in the source system can see them in the BI tool because the copy was loaded with broader access. A true query-in-place model inherits source permissions. In Quaeris’s framing: “If a user cannot see the data in the source system, they cannot see it in Quaeris.” That single property keeps security and compliance teams confident that analytics can’t become a backdoor around source-system access controls. 

    4. Fewer credentials and pipelines to secure. Each ETL pipeline is itself an attack path it holds credentials to your source systems and writes data somewhere new. Removing the need to move data removes those pipelines and the standing credentials they require. 

    The honest counterpoint, worth stating plainly: federated and query-in-place models introduce their own complexity. Pushing queries across multiple sources means managing “multi-cloud IAM policies” and reconciling “inconsistent security policies across different sources.” No-movement isn’t free of governance work — it relocates that work to the query layer. But it relocates it to a layer you control, against data that never multiplied, which is a far better problem to own than a sprawl of unguarded copies. 

    Architecture Patterns and How to Choose 

    “No data movement” is a principle, not a single product. It shows up in several architectural patterns, and choosing well means matching the pattern to your constraints. 

    PatternHow it worksBest whenWatch out forQuery-in-place / push-downBI layer pushes queries to a single source (warehouse, lakehouse); only results returnYou’ve consolidated into one strong warehouse and want safe BI on topSource must handle analytical query loadQuery federationA virtual layer spans multiple distributed sources in one query, no consolidationData is genuinely siloed across systems/regions and can’t be mergedCross-source joins can be slow; needs governance at query layerZero-copy data sharingSource grants governed read access to a consumer without copying (e.g., warehouse-native sharing)Both sides use compatible platformsTighter platform couplingSemantic / metrics layer over sourceA governed model defines metrics; queries resolve to source at runtimeYou want consistent KPIs without a physical martModeling effort up front 

    A few decision principles cut through the options: 

    Start from your residency map. If regulated data must stay in specific regions, any pattern that copies it out is disqualified before you evaluate features. Let compliance constraints filter the field first. 

    Match the pattern to your data’s distribution. One consolidated warehouse points toward query-in-place push-down. Genuinely scattered sources point toward federation. 

    Govern at the query layer. Whatever pattern you choose, the place to enforce access, masking, and audit is the layer issuing queries — because that’s the only place all requests pass through when data itself doesn’t move. 

    Prefer permission inheritance over permission re-creation. A tool that reuses source permissions is structurally safer than one asking you to redefine who-sees-what inside the analytics platform. 

    Implementation: A Practical Migration Path 

    Moving from a copy-everything model to analytics without data movement doesn’t have to be a big-bang rewrite. A staged approach lets you prove value and de-risk as you go. 

    Step 1 – Inventory your copies. Map every place level-zero data currently lands: staging areas, the warehouse, BI caches, vendor clouds, exports, spreadsheets. You can’t reduce copies you can’t see. This inventory alone is often eye-opening for security teams. 

    Step 2 – Classify data by residency and sensitivity. Tag which datasets are regulated, which are residency-bound, and which are genuinely low-risk. This tells you where no-movement is mandatory versus merely beneficial. 

    Step 3 – Pick a high-value, high-sensitivity pilot. Choose one dashboard or use case built on sensitive data — ideally one where a stray copy would be a real compliance problem. Re-implement it query-in-place against the source. 

    Step 4 – Validate permission inheritance. Before trusting the new layer, test the critical property directly: confirm that a user restricted in the source system is equally restricted in analytics. This is the linchpin of the security argument; verify it, don’t assume it. 

    Step 5 – Measure freshness and performance. Compare query latency and data freshness against the old copied model. Push-down queries hit live data, so freshness usually improves; latency depends on source capacity, so size accordingly. 

    Step 6 – Decommission the redundant copies. Once the no-movement path is proven, retire the pipelines and caches feeding the old copy — and document the deletion for your auditors. This is where the cost and compliance savings actually land. 

    Step 7 – Expand and standardize. Roll the pattern out to additional use cases, and make “does this require moving level-zero data?” a standing question in every new analytics request. 

    Best practice: Treat each retired copy as a security win worth recording. “We eliminated three redundant copies of customer PII” is exactly the kind of sentence that resonates in a board-level risk review. 

    Real-World Scenarios 

    Multinational retailer residency by design. A retailer operates in the EU, US, and APAC, each with its own regional data store and its own localization rules. Under a traditional BI model, building a global revenue dashboard meant copying regional sales data into one central cloud a cross-border transfer nightmare. With query-in-place analytics, each regional query runs locally against in-region data; only aggregated revenue figures (which contain no personal data) are combined for the global view. Residency is preserved structurally, not policed after the fact. 

    Healthcare provider minimizing PHI exposure. Healthcare breaches are the most expensive of any sector, averaging $10.93 million. A provider wants clinical analytics without spreading protected health information into yet another system. By querying patient data in place and surfacing only de-identified aggregates to analysts, the raw PHI never enters the analytics tier shrinking both breach exposure and HIPAA audit scope. 

    Financial services permission inheritance as a control. A bank’s source systems enforce strict row-level access: a relationship manager sees only their own clients. With copied-data BI, those controls had to be painstakingly re-created in the reporting tool, and drift was a constant audit finding. With permission-inheriting query-in-place analytics, the source rules apply automatically an analyst literally cannot query rows they’re not entitled to see in the source. 

    SaaS startup analytics without a data-engineering team. An early-stage company wants self-service analytics but has no one to build and babysit ETL pipelines. A natural-language layer that queries the production warehouse in place lets non-technical staff ask questions directly, with no pipelines to maintain and no second copy of customer data to secure a meaningful reduction in both engineering load and risk surface for a small team. 

    Enterprise data mesh federation across domains. A large enterprise with a data-mesh strategy has dozens of domain-owned data products across clouds. Rather than re-centralizing them (defeating the mesh), a federated query layer spans them in place, enforcing governance at the query layer while each domain retains ownership and residency of its own level-zero data. 

    Common Mistakes to Avoid 

    Even teams sold on the concept stumble in predictable ways. Watch for these: 

    1. “Zero-copy” that quietly caches. Some tools claim no data movement but maintain a hidden extract or aggressive cache of raw rows for performance. If level-zero data is persisted anywhere outside the source, you haven’t actually eliminated the copy — you’ve just hidden it. Ask vendors precisely what is stored, where, and for how long. 

    2. Re-creating permissions instead of inheriting them. Rebuilding access rules inside the analytics tool reintroduces drift and the shadow-access risk. If the tool can’t inherit source permissions, you’ve kept one of the worst problems of the copy model. 

    3. Ignoring source query load. Push-down analytics means your source now serves analytical queries on top of its day job. Without read replicas or adequate capacity, you can degrade the very system of record you were protecting. Plan for the load. 

    4. Treating federation as free. Cross-source federated joins can be slow and can expose inconsistent security policies between systems. No-movement reduces copy risk but demands real governance discipline at the query layer. Don’t mistake “no copies” for “no work.” 

    5. Forgetting result-set sensitivity. Aggregates are usually safe but not always. A filtered result that returns a single row can be as identifying as raw data. Apply masking and minimum-aggregation thresholds at the query layer, not just at the storage layer. 

    6. Skipping the deletion-of-old-copies step. Teams adopt query-in-place for new dashboards but never decommission the legacy pipelines and caches. You only realize the security and compliance benefit when the redundant copies are actually gone. 

    Advanced Insights and Future-Proofing 

    Analytics is converging with AI and AI raises the stakes on copies. As organizations feed data into LLMs and AI agents, the “where did the raw data go?” question gets sharper, because AI systems are notorious copy-multipliers (training sets, embeddings, vector stores, logs). The same principle applies and matters more: let the AI query layer reason against governed source data in place rather than vacuuming level-zero records into yet another store. Natural-language analytics that generates queries against the source rather than ingesting the source is a preview of how AI and data residency can coexist. 

    Make “no new copy” an architectural default, not an exception. The most future-proof posture is to invert the old assumption. Instead of “copy data into analytics unless there’s a reason not to,” adopt “never copy level-zero data unless there’s a compelling, documented reason to.” This single default change cascades into simpler compliance, smaller attack surface, and lower cost across every future project. 

    Govern the query layer like you’d govern a database. When data stops moving, the query layer becomes the chokepoint where all access, masking, and audit must live. Invest there: centralized policy, full query logging, and consistent enforcement across every source. The payoff is that you get one place to govern instead of N copies to chase. 

    Watch the regulatory trajectory. Data localization rules are tightening, not loosening the count of regional regulations keeps climbing. Architectures that assume free cross-border data movement are accumulating technical and legal debt. No-movement analytics is a hedge against a regulatory future that is clearly heading toward more restriction on where data can go. 

    Strategic takeaway: The organizations that will move fastest under tightening regulation are the ones that designed their analytics to not move data in the first place. Constraint becomes an advantage when you’ve built for it. 

    Frequently Asked Questions 

    What is analytics without data movement? 

    It’s an analytics architecture where the BI or AI layer queries data in its original source system instead of copying raw records into a separate analytics platform. The query travels to the data; only the computed result (an aggregate or answer) comes back. Raw, level-zero data never leaves the source. 

    What does “level-zero data” mean? 

    Level-zero data is the raw, granular, row-level source of truth individual transactions, customer records, event logs. It’s the most detailed and most sensitive form of your data. Most analytics consumers need aggregates derived from it, not the level-zero rows themselves, which is why keeping that layer in source dramatically reduces risk without limiting insight. 

    How is this different from a traditional data warehouse setup? 

    A traditional setup copies raw data through pipelines into a warehouse, and often again into a BI tool’s own engine or cloud — creating multiple copies and multiple attack surfaces. Query-in-place analytics reads data where it lives and returns only results, so no additional copy of level-zero data is created. 

    Is “zero-copy analytics” the same as “no data movement BI”? 

    They’re closely related and often used interchangeably. Both describe analyzing data without creating a duplicate physical copy of the raw data. “Query federation” is a specific flavor that spans multiple distributed sources in a single query without consolidating them. 

    Does keeping data in source make analytics slower? 

    Not necessarily. Push-down queries run on live data, so freshness usually improves over copied models. Latency depends on the source’s capacity to serve analytical queries — which you can address with read replicas or appropriate sizing. The key trade-off is provisioning source compute, not accepting stale data. 

    How does query-in-place analytics help with data residency and GDPR? 

    Because raw data never leaves its source region, you avoid unintended cross-border transfers, and regulated data stays in its required jurisdiction. It also shrinks GDPR deletion obligations — there’s no extra analytics copy to find and erase — and narrows audit scope to the systems that actually hold the data. 

    What is permission inheritance and why does it matter? 

    Permission inheritance means analytics honors the source system’s access rules: if a user can’t see certain rows in the source, they can’t see them in analytics either. It prevents the “shadow access” problem where a copied dataset exposes data the user was never authorized to see, and it removes the need to rebuild and sync a parallel permission model. 

    Does no data movement reduce my security risk? 

    Yes, structurally. Eliminating the analytics-tier copy removes an entire class of breach scenario and preserves your existing encryption and access controls instead of forcing you to re-implement them. It does shift governance work to the query layer, so you must secure that layer well but you’re governing one controlled chokepoint instead of multiple uncontrolled copies. 

    Can I query data across multiple systems without moving it? 

    Yes that’s query federation. A federated query layer issues a single query across multiple distributed sources (different databases, clouds, or regions) and combines results without consolidating the underlying data. It’s ideal when data is genuinely siloed and can’t or shouldn’t be merged. 

    What are the downsides of analytics without data movement? 

    The main trade-offs are managing query load on source systems, handling cross-source query performance in federated setups, and reconciling security policies across different sources at the query layer. These are real but manageable and generally preferable to maintaining and securing many redundant copies of sensitive data. 

    How do I evaluate a BI or analytics vendor for this? 

    Ask one anchoring question: Does connecting you create a copy of my raw data, and if so, where does it live? Then probe specifics does it cache or extract level-zero data, does it inherit source permissions, can it keep data in-region, and what exactly is stored in the vendor’s cloud. The answers reveal whether “no data movement” is real or marketing. 

    Is this approach suitable for AI and natural-language analytics? 

    Yes, and it’s arguably more important there. Natural-language and agentic analytics can translate plain-English questions into queries that run against governed source data in place delivering self-service insight without vacuuming raw records into new stores, embeddings, or logs that multiply your exposure. 

    Conclusion 

    For most of BI’s history, “move the data first” was an unquestioned default. Fast analytics seemed to require local copies, and local copies required movement. But that default was quietly expensive — it multiplied attack surfaces, complicated residency compliance, inflated storage and pipeline costs, and served users stale numbers. 

    Analytics without data movement inverts the default. By sending the query to the data instead of the data to the query, you keep level-zero data — the raw, sensitive source of truth — exactly where it already lives, governed by controls you already trust. Users still get their dashboards and answers; what they don’t get is a redundant copy of your most sensitive data sitting in a system you don’t fully control. 

    The benefits stack cleanly: 

    Security: a smaller attack surface, preserved encryption and access controls, and permission inheritance that closes the shadow-access gap. 

    Compliance: structural data residency, smaller deletion obligations, and narrower audit scope. 

    Cost and freshness: fewer copies to store, fewer pipelines to maintain, and live data instead of stale extracts. 

    Recommended next steps: inventory where your level-zero data is being copied today, classify it by residency and sensitivity, and re-implement one high-sensitivity dashboard query-in-place as a pilot validating, above all, that source permissions carry through. Then make “does this require moving level-zero data?” a standing question for every new analytics request. 

    The outlook: as data localization rules tighten and AI multiplies the temptation to copy data everywhere, architectures that simply don’t move sensitive data will hold up best. The cheapest data to secure, and to keep compliant, is the copy you never made. Build your analytics so you never have to make it. 

  • The 5 AI agent platforms to look out for in 2026

    The 5 AI agent platforms to look out for in 2026

    Enterprise agentic AI moved from pilot budgets to production commitments faster than most other categories of enterprise software. That speed created a side effect worth naming upfront: one industry guide to this exact topic calls out “agent washing,” vendors relabeling existing chatbots, RPA scripts, or linear workflow tools as agents without the underlying system actually doing autonomous, multi-step reasoning. The same guide argues genuine agentic AI requires autonomous decision-making, multi-step reasoning, and dynamic error handling, and that most products marketed this way do not clear that bar.

    With that caveat in mind, five platforms show up consistently across independent comparison sources (not just their own marketing) as the ones enterprise teams are actually deploying in production. This list is organized by the enterprise system each one is built around, since that is the factor most buyer’s guides agree should drive the decision.

    1. Salesforce Agentforce

    Agentforce is Salesforce’s agent platform, built to operate directly on Salesforce’s own data model so agents work against current CRM records without a separate synchronization layer. Governance runs through Salesforce’s Einstein Trust Layer and existing audit logs, and MuleSoft extends its reach into other systems. As of independent 2026 coverage, Salesforce has closed roughly 29,000 Agentforce deals since launch, generating around $800 million in annual recurring revenue, figures reported externally rather than only claimed by Salesforce itself.

    Best for: organizations already running Salesforce as their primary CRM who want agents acting on live customer data without a new integration layer.

    2. Microsoft Copilot Studio

    Copilot Studio is Microsoft’s low-code agent builder, with independent 2026 reporting citing roughly 160,000 organizations running more than 400,000 custom agents on the platform. Its core strength is depth of integration across the Microsoft ecosystem, Microsoft 365, Dynamics, and Azure, making it the practical default for organizations already standardized on Microsoft’s stack. Comparison guides consistently note it alongside Agentforce as one of the two platforms with the fastest time to production for pre-built use cases, typically four to six weeks.

    Best for: Microsoft-centric organizations that want agent building accessible to business users, not only engineering teams.

    3. ServiceNow AI Agents

    ServiceNow’s agent capabilities sit inside its existing IT service management, HR, and customer service management workflows, under the Now Assist feature set. In April 2026, ServiceNow restructured its commercial model to embed an AI Control Tower and Workflow Data Fabric across every pricing tier by default rather than as an add-on, a move independent coverage described as a signal that governance-first architecture is becoming a baseline market expectation, not a premium feature. ServiceNow also acquired Moveworks in late 2025, which now operates under the ServiceNow umbrella and extends its employee-facing agent capabilities across Slack and Microsoft Teams with more than 100 pre-built integrations.

    Best for: large enterprises already running ServiceNow for IT service management that want to extend agent-driven support into HR and broader employee operations.

    4. SAP Joule Studio

    SAP’s agent platform evolved substantially through 2026. Joule Studio, a full agent builder on SAP’s Business Technology Platform, reached general availability in Q1 2026, and Joule Studio 2.0 followed at SAP Sapphire in May 2026 with a fully managed, zero-infrastructure version aimed at citizen developers rather than only professional coders, backed by a 100 million euro partner fund. SAP describes agents built this way as natively grounded in a business’s existing SAP data, processes, and semantics rather than connected to them afterward. Reported agent and skill counts vary by source and by which specific SAP AI product is being described, ranging from roughly 40 specialized agents and 2,400 skills in one 2026 analysis to 200 domain-specific agents announced with Joule Studio 2.0, so treat any single number as a snapshot rather than a fixed figure, and confirm current scope directly with SAP.

    Best for: enterprises running SAP as their core ERP that want agents grounded in existing SAP business processes without a separate integration project.

    5. IBM watsonx Orchestrate

    watsonx Orchestrate positions itself as a governance-first control plane rather than a single-vendor agent builder, with a stated skills catalog of more than 150 pre-built automations and integrations spanning SAP, Salesforce, and ServiceNow. Independent buyer’s guides consistently rate its governance and auditability as the strongest in this category, describing it as built for large, regulated enterprises where explainability is not optional, with the tradeoff that deployment cycles tend to run longer than SaaS-native competitors due to procurement rigor. IBM also released an Agent Management Platform in March 2026, a vendor-agnostic governance layer that can manage agents across other frameworks and vendors, including LangGraph, CrewAI, Google’s Agent Development Kit, AWS AgentCore, Microsoft Foundry, and Salesforce Agentforce, from a single control plane.

    Best for: regulated enterprises running multiple AI agent vendors or frameworks that need one governance layer over all of them, not just IBM’s own agents.

    The pattern worth noticing

    Every platform on this list leads with governance and grounding in existing business systems, not raw agent capability alone. That is not a coincidence. Gartner’s own 2026 Analytics and BI Magic Quadrant made a related point for the adjacent BI category: success increasingly depends on more than a large language model, it requires governed business context and the ability to operationalize decisions inside existing workflows. The same logic applies here. An agent that reasons well but cannot prove what it touched, why, and under whose permission is a harder sell in an enterprise than a system that is somewhat less flashy but fully auditable.

  • QuaerisAI Now Connects to ClickHouse

    QuaerisAI Now Connects to ClickHouse

    Real-time data is becoming central to how modern teams operate. Marketing teams need to understand campaign movement. Finance teams need to review usage and metering data. Risk and operations teams need to investigate unusual activity. Product teams want to bring analytics closer to customers. 

    ClickHouse gives teams a high-performance foundation for querying large volumes of fast-moving data. 

    QuaerisAI adds the governed question layer on top. 

    With the ClickHouse integration, business users can ask questions in plain English and receive answers that stay connected to certified definitions, source data, and governance controls. The goal is to make real-time data easier to access, explain, and trust across the business. 

    For many organizations, the challenge is not that the data does not exist. The challenge is that access to that data often depends on SQL, dashboards, or data team support. 

    A marketer may want to know which campaigns underperformed this week. A finance user may need to review usage data behind billing. A risk team may want to investigate unusual patterns. An executive may need a current answer for a board discussion. 

    These questions should not always require a new dashboard or a manual reporting request. 

    QuaerisAI helps close that gap by translating plain-English questions into governed queries that run against ClickHouse. Answers are mapped through QuaerisAI’s semantic layer, so teams can work from consistent definitions instead of recreating metric logic for every request. 

    That governance layer matters. 

    Natural-language analytics can make data easier to access, but enterprise teams also need control over how answers are produced. Metrics need to be defined consistently. Answers need to remain traceable to source. Business users need confidence that the number they are using has the right context behind it. 

    The QuaerisAI and ClickHouse integration is designed for teams that need both speed and trust. 

    ClickHouse supports the real-time analytics layer for high-volume data. QuaerisAI helps business users ask questions, understand answers, and trace results back to certified definitions and source data. 

    This combination can support use cases across real-time marketing analytics, usage-based pricing and metering, anomaly investigation, embedded customer-facing analytics, and executive reporting. 

    For ClickHouse customers, QuaerisAI expands the way real-time data can be used across the business. More teams can ask questions directly. Data teams can reduce repetitive reporting requests. Business users can move from raw event data to governed answers with less friction. 

    Real-time analytics becomes more useful when it is accessible to the teams making decisions every day. 

    With QuaerisAI on top of ClickHouse, fast-moving data can become trusted business answers. 

  • Five reasons “AI BI” without governance fails in regulated industries

    Five reasons “AI BI” without governance fails in regulated industries

    Regulated enterprises do not get to fail quietly. When a bank, an insurer, or a health system deploys analytics software that produces an indefensible number, the consequence is not an internal retrospective. It is an audit finding, a regulatory inquiry, or a remediation programme with a budget line. This is why the wave of “AI BI” tools, chat interfaces bolted onto warehouses with a capable model underneath, keeps stalling at exactly the same stage in regulated industries: the pilot impresses, the procurement review begins, and the deployment dies. The failure is not the model. It is the absence of governance, and it fails in five specific ways.

    Reason one: answers that cannot be evidenced are answers that cannot be used

    Regulated industries run on evidence. A number that reaches a regulator, an external auditor, or a filing must be supportable with documentation of its origin. An ungoverned AI BI tool produces answers in a chat window and retains, at best, a conversation history. There is no linked record of who asked, what SQL ran, which tables were read, or which definitions were applied. The tool’s answers may be perfectly correct, but correctness without evidence has no standing in a regulated process. The output is unusable for exactly the decisions that matter most, which confines the tool to trivia and guarantees it never justifies its cost.

    Reason two: uncontrolled definitions produce contradictory numbers in official places

    A model reading a raw schema must guess what the business means by its own vocabulary. Which of several revenue columns is the certified one? Are written premiums gross or net of reinsurance here? Does this health system count readmissions within 30 days or 90? An ungoverned tool answers these questions differently depending on phrasing, context, and chance. In an unregulated setting, that produces confusion. In a regulated one, it produces two different figures for the same metric in two official documents, and reconciling contradictory reported numbers is a process no compliance team enjoys. Without a certified semantic layer, this outcome is not a risk. It is a schedule.

    Reason three: access control that lives outside the query path is access control in name only

    Regulated data carries entitlement rules with legal force: patient records under health privacy law, material non-public information inside financial institutions, policyholder data under insurance regulation. Many AI BI tools connect to the warehouse through a single service account with broad read access, then rely on the application layer to decide what users should see. The moment the model generates an unanticipated query, that arrangement leaks. Governance means the agent inherits the asker’s permissions and enforces them at query time, so the question a user is not entitled to ask returns nothing, structurally, rather than being filtered by hope. Regulators examine the structural version. They penalise the other one.

    Reason four: hallucinated analysis is fluent, and fluency defeats casual review

    The dangerous failure mode of an ungoverned tool is not the visibly wrong answer. It is the plausible one: a well-formed figure, confidently presented, resting on a silently invented join or a misread column. Human review catches this only when the reviewer independently reproduces the work, which eliminates the time savings that justified the tool. Governed platforms attack this differently: grounding generation in certified definitions so there is less room to invent, and attaching the generated SQL and sources to every answer so verification takes minutes instead of hours. In a regulated industry, where an incorrect figure can constitute a reporting breach rather than an embarrassment, this difference is the whole game.

    Reason five: the veto holders were never going to approve it

    Enterprise AI deployments in regulated industries pass through three offices that each hold a veto: the CISO, the head of compliance, and increasingly the CFO. Each asks a governance question. The CISO asks how access is enforced and where data travels, including whether it leaves for a model vendor the organisation has not approved. Compliance asks how the system’s decisions will be documented for examiners. The CFO asks how a number can be traced when challenged. An ungoverned tool has no answer for any of the three, which means the deployment fails in procurement no matter how well the pilot went. The pattern repeats so reliably that it should be treated as a law of the category: in regulated industries, governance is not a feature of the deployment. It is the precondition for there being a deployment at all.

    The conclusion regulated buyers are reaching

    None of these five failures is cured by a better model, because none of them is a capability problem. They are control problems, and controls have to be architectural: a certified semantic layer, permissions enforced at query time, a complete prompt-level audit trail, and model choice the enterprise can direct. Platforms built this way clear the vetoes that kill their ungoverned rivals, and the results follow deployment rather than remaining in pilots. Based on QuaerisAI customer deployments and published materials, governed deployments have achieved BI adoption rates of 30 to 60 percent and reductions in BI cost of 70 percent, outcomes that are only available to tools that regulated enterprises are actually permitted to use.

    Frequently asked questions

    What counts as “AI BI without governance”?

    Any deployment where a language model generates analysis against enterprise data without three controls in place: certified metric definitions the model must use, user-level access permissions enforced when the query executes, and a complete linked record of each interaction from prompt to SQL to result. A tool can be highly capable and still be ungoverned. The two properties are independent.

    Are regulated industries simply late adopters of AI analytics?

    No. They are early adopters of governed AI analytics and non-adopters of ungoverned AI analytics. The demand for faster answers is at least as strong in banking, insurance, and healthcare as anywhere else. What differs is that these industries cannot absorb the failure modes of ungoverned tools, so they wait for platforms where the controls are structural.

    Can governance be added to an existing AI BI deployment later?

    Partially, and expensively. Access enforcement and audit trails must live inside the query pipeline to be complete, which usually means the platform has to be built for them. Retrofitting typically produces fragmented logs and application-layer filtering, which are exactly the versions that fail examination. The practical answer is to evaluate for governance at selection, not remediation.

  • How to choose new age AI BI (and what to actually evaluate)

    How to choose new age AI BI (and what to actually evaluate)

    Every AI BI vendor’s homepage says roughly the same four things. Ask questions in plain English. Get instant answers. No more waiting on analysts. Works with any data source. Read ten of these homepages back to back and they start to blur into one page with a different logo at the top.

    None of that tells you which one will actually hold up once real business users start asking it real questions. The differences that matter are almost never visible in a demo. They show up three months in, when someone asks a question the demo never covered, or when two people ask the same question and get two different answers, or when someone in compliance asks how a specific number was produced and nobody can say for certain.

    Here is what actually separates these tools, past the homepage.

    Old BI evaluation criteria don’t fully apply anymore

    Traditional BI evaluations focused on things like dashboard build speed, visualization variety, and how many connectors a tool shipped with. Those questions still matter, but they’re no longer sufficient. A tool that answers questions conversationally introduces a new category of risk that dashboard-based BI never had: the tool can now generate a wrong answer that looks exactly as confident as a right one.

    A static dashboard can be misread, but it can’t lie to you in a full sentence. A conversational AI layer can. That changes what “evaluation” needs to cover.

    Does it answer from certified definitions, or improvise them?

    This is the single most important question, and it’s the one most demos are built to avoid. Ask the vendor directly: when someone asks about a metric that has no formal definition yet, what happens? A tool built around a governed semantic layer will say it can’t answer until that metric is defined, or it will show you exactly which definition it used and let you inspect it. A tool built primarily on a language model’s general reasoning will often generate something plausible anyway, calculated on the fly from whatever it can infer, without telling you that’s what happened.

    The second version demos beautifully. It also means two people can ask the identical question a week apart and get two different numbers, because the model quietly re-derived the logic each time.

    Can you see the query behind the answer?

    Ask for the actual SQL, or whatever query the system generated to produce the answer. Not a summary of the logic, the literal query. If a vendor can’t show you that, or treats it as a power-user feature buried three menus deep, that’s worth noting. The ability to inspect the underlying query is what turns “trust the AI” into “verify the AI,” and only one of those scales past the first few months of skepticism from an audit or finance team.

    Does data have to move to get an answer?

    Some AI BI tools require pulling your data into their own environment before they can answer anything, a separate copy, a separate pipeline, a new place for that data to live and go stale. Others query your existing warehouse directly, in place, read-only. The difference matters more than it sounds like in a demo, because every extra copy of your data is a new thing to secure, govern, and eventually reconcile against the original.

    Ask specifically whether the tool executes against your warehouse or requires ingestion into its own store first. The answer changes your total security surface, not just your architecture diagram.

    What happens when it doesn’t know?

    Every AI BI tool will eventually be asked something it can’t answer well, a metric that doesn’t exist, a question outside its scope, ambiguous phrasing. What it does at that moment tells you more than almost anything else in the evaluation. Some tools guess anyway and present the guess with full confidence. Others say plainly that the definition doesn’t exist yet, or that the question needs to be narrowed. Push on this specifically during any trial. Ask something you know the tool cannot answer correctly and watch what it does instead of admitting the gap.

    Who can ask what?

    Self-service only works if access is actually scoped. Ask how permissions are enforced: is access checked at the moment a query runs, or is it enforced by filtering results after the fact, or worse, left to the model to respect on its own. Query-time enforcement means a user literally cannot retrieve data outside their permission, regardless of how the question is phrased. Post-hoc filtering or model-level trust means the boundary is softer than it looks, and softer boundaries tend to fail exactly when someone gets creative with a prompt.

    Can you choose your own model, or are you locked to one?

    The underlying language model powering these tools changes fast, and today’s best option won’t stay the best option indefinitely. A tool tightly coupled to one specific model ties your governance and your model choice together permanently. A tool that separates the semantic layer from the model itself lets you change models as the market moves without rebuilding your certified definitions from scratch.

    The red flags that sound good in a demo

    A few things worth specific suspicion, because they tend to demo well and hold up poorly: a tool that never says “I don’t know,” a tool where every answer looks equally confident regardless of how well-supported it actually is, a tool that can’t show you its own reasoning path when asked directly, and a tool where the sales team can’t clearly explain what happens to a question outside its trained scope.

    None of these are dealbreakers on their own. All of them together usually mean the tool was built to impress in a thirty-minute demo, not to survive daily use by people who will eventually ask it something it wasn’t ready for.

    What actually matters

    The vendors selling AI BI are not lying when they say it’s faster than a dashboard. It usually is. The real evaluation question isn’t speed, every tool in this category is fast now. It’s whether the speed is coming from a governed, certified answer or from a model’s best guess dressed up to look certain. One of those scales safely as more people start relying on it. The other one accumulates risk quietly, one plausible-sounding answer at a time, until someone finally asks where a number came from and nobody can say.

  • BYOM analytics: what it is and why your compliance team will demand it

    BYOM analytics: what it is and why your compliance team will demand it

    BYOM stands for bring your own model, and it names a simple architectural property with far-reaching consequences: the enterprise, not the analytics vendor, decides which large language model powers the platform. In a BYOM architecture, the analytics layer, the semantic layer, the governance controls, and the audit trail are constant, while the model underneath is a choice, selectable among providers such as Anthropic, OpenAI, Google, and Meta, and changeable as circumstances change. Most of the market is built the opposite way: the model is welded in, chosen by the vendor, and the customer inherits that choice along with everything downstream of it. The difference looks like a technical detail. It is actually a control question, which is why the people who end up caring most about it are not the data scientists. They are the compliance team.

    What BYOM is, precisely

    Three properties define genuine BYOM, and all three matter. First, the model is substitutable: the platform’s grounding, permissions, and logging do not depend on any one provider’s model, so replacing the model does not mean replacing the system or retraining the users. Second, the choice operates at the level the enterprise needs, which increasingly means per-deployment or even per-workload: one model for general analysis, a different one where a jurisdiction or a client contract requires it. Third, the selection is documented and auditable, because a choice that cannot be evidenced is not a control. Marketing language blurs this constantly, so it is worth naming what BYOM is not: a platform that lets the vendor swap models on their own schedule is not BYOM, and neither is one where switching requires a migration project. The defining question is who holds the decision and how cheaply it can be exercised.

    Why compliance teams arrive at this demand

    Compliance functions think in terms of dependencies they can control and dependencies they cannot, and a welded-in model is a large uncontrolled dependency sitting in the middle of a consequential system. Consider what the model choice actually determines. It determines where prompts containing business context are processed, which is a data-residency and confidentiality question. It determines whose terms govern that processing, which is a contractual question the enterprise negotiated with its analytics vendor but not with the model provider behind them. It determines model provenance, which regulatory frameworks for AI increasingly expect organisations to document: what system made this decision, built by whom, under what assessment. And it determines exposure to change, because model providers retire versions, alter behaviour, and update terms on their own schedules, and every such change flows straight into a locked platform whether the enterprise’s risk assessment approves it or not.

    Against that backdrop, BYOM converts a cluster of uncontrollable dependencies into governed decisions. Residency requirements become model-selection criteria rather than vendor negotiations. A client contract or regulator that constrains which AI providers may touch certain data becomes a configuration, applied per tenant or per workload, rather than a dealbreaker. A model provider’s terms changing adversely becomes an exit executed in weeks rather than a re-platforming programme. Compliance teams demand BYOM for the same reason they demand data-residency options and exit clauses everywhere else: not because they expect to exercise the option constantly, but because the absence of the option is itself the risk.

    The procurement and continuity dividends

    The compliance case usually gets BYOM onto the requirements list, but two adjacent benefits keep it there. The first is negotiating position. An enterprise that can substitute models holds real bargaining power with every provider in the rotation; an enterprise that cannot switch has told its model vendor exactly how much pricing power it has surrendered, and vendors price accordingly. The second is continuity. Model performance is not static across providers: capabilities shift with each release cycle, and the best model for SQL generation this year is not guaranteed to be the best next year. A BYOM platform lets the enterprise follow that frontier, adopting improvements as configuration changes, while a locked platform’s customers watch the frontier move from a fixed seat. There is also a resilience angle that business-continuity planners appreciate: dependence on a single AI provider is a single point of failure, and BYOM makes failover between providers an operational pattern rather than a crisis.

    What to verify before accepting a BYOM claim

    Because the term is fashionable, verification matters more than the label. Three tests separate real BYOM from a checkbox. Ask which specific providers and models are supported today, not on the roadmap, and whether the list includes at least one option satisfying your strictest jurisdiction or client requirement. Ask what a model switch actually involves: a genuine BYOM platform re-grounds the new model in the same semantic layer and governance controls, so accuracy and permissions carry over and analysts are not retrained; if the vendor describes migration effort, definitional work redone, or an accuracy reset, the model was more welded-in than advertised. And ask how the audit trail records model identity: every logged interaction should name the model and version that produced it, because when a regulator or auditor asks which AI generated a given analysis, “we would have to check with the vendor” is not an answer. QuaerisAI’s architecture treats all three as native properties, with model choice spanning Anthropic, OpenAI, Google, and Meta, grounding and governance held constant across that choice, and model identity captured in the prompt-level audit trail on every query, based on QuaerisAI published materials.

    The direction of travel

    Model choice is following the path that data-residency options and SOC 2 reports followed before it: from differentiator, to requirement in regulated industries, to table stakes everywhere. The mechanism is procurement. Once compliance teams in banking, insurance, and healthcare put model substitutability into their RFP templates, and they are doing so now, vendors without it stop clearing the bar, and the requirement propagates outward from the regulated core to the whole market. Enterprises selecting analytics platforms today can either anticipate that requirement or retrofit for it, and retrofitting an architecture is the expensive version of the same decision.

    Frequently asked questions

    Does BYOM mean hosting and operating the models ourselves?

    No. BYOM concerns who holds the choice of model, not who runs the infrastructure. In a platform like QuaerisAI, the enterprise selects the provider and model, and the platform manages the integration. Self-hosted and private-deployment models can be part of the eligible set where requirements demand it, but they are one option within BYOM, not its definition.

    Does switching models degrade accuracy?

    Far less in a governed architecture than the fear suggests, because most enterprise-specific accuracy lives in the semantic layer rather than in the model. Certified definitions, blessed tables, and learned corrections carry over unchanged when the model is swapped; what varies is the general capability of the model executing them. The disciplined practice is to rerun your gold-standard evaluation set after any model change, which a platform with a full audit trail makes straightforward.

    Is BYOM relevant for organisations outside regulated industries?

    Yes, though the leading motive shifts from compliance to economics and continuity: bargaining power across providers, freedom to follow model improvements, and no single-provider point of failure. The compliance motive also has a way of arriving later, through client contracts and expanding AI regulation, and organisations with BYOM in place absorb those arrivals as configuration rather than as projects.

  • The shadow AI tax: what ungoverned AI use is quietly costing your data team

    The shadow AI tax: what ungoverned AI use is quietly costing your data team

    A data analyst at a mid-size logistics company spent forty minutes on a Tuesday afternoon reconstructing a churn number from scratch. Not because the number didn’t exist anywhere. Because someone in sales had already pulled a number from a public chatbot, brought it into a leadership meeting that morning, and now the analyst had to prove it right or wrong before anyone would trust either version.

    The number turned out to be close, but built on a customer segment definition that didn’t match what finance used. Nobody in that meeting knew that. They just knew there were now two churn numbers in the building, and someone had to lose the argument about which one was real.

    This is the actual cost of shadow AI, and it rarely shows up in the way risk conversations describe it.

    The tax isn’t where most people are looking

    Most discussion of ungoverned AI use frames it as a security problem: sensitive data pasted into a public chatbot, sitting somewhere outside the company’s control. That risk is real. It is also not where the recurring cost lives.

    The recurring cost lives downstream, on the data team, every time an ungoverned answer reenters the business as if it were a governed one. Someone asked a chatbot a question, got a plausible number, and used it. The data team didn’t produce that number and usually doesn’t find out it exists until it conflicts with something they did produce. At that point, the work isn’t optional. Someone has to figure out where the number came from, what it means, and why it doesn’t match, before the disagreement can even be resolved, let alone closed.

    That work is a tax. It gets paid every time it happens, and almost nobody is tracking the total.

    What the tax actually looks like

    The verification tax. Every ungoverned number that reaches a meeting eventually needs someone to check it. That checking work rarely gets scheduled. It gets absorbed, usually by whoever is already stretched thin, at the exact moment a decision is waiting on the answer.

    The reconciliation tax. Two numbers in a room means someone has to explain the gap. That explanation almost never has a quick answer, because the gap is usually a definitional mismatch: a different date range, a different customer segment, a different join that nobody wrote down. Resolving it means reverse engineering a query nobody kept a record of.

    The credibility tax. Once a wrong number has been in a meeting, the data team’s numbers get a second look too, even the correct ones. Trust doesn’t erode evenly. One bad number from an ungoverned source can quietly increase scrutiny on everything the data team produces afterward, whether that scrutiny is warranted or not.

    The opportunity tax. All of that verification and reconciliation time comes from somewhere. It comes from the roadmap, the actual analysis work the data team was supposed to be doing instead of playing defense against an answer they didn’t produce.

    None of these show up on a dashboard. They show up as a data team that seems perpetually behind, without anyone being able to point to exactly why.

    Banning the tool doesn’t remove the tax

    The instinctive response to this is to block public AI tools at the network level and call the problem solved. It rarely works, and when it does work, it usually just moves the cost somewhere less visible. The underlying need, a fast answer to a specific business question, does not go away because the tool got blocked. It moves to a personal device, a different account, a colleague who still has access. The tax stays the same. The visibility into it gets worse.

    Blocking access without offering a governed alternative treats the symptom and leaves the actual cause in place: business users have a real question and no fast, trustworthy way to ask it.

    What actually removes the tax

    The only way to remove the verification and reconciliation tax is to remove the reason it exists: a governed answer has to be at least as fast as an ungoverned one, or the ungoverned path stays attractive no matter what the policy says.

    That means conversational access to data that resolves through certified definitions instead of a model’s best guess. When gross margin means the same thing everywhere it’s asked, and the answer comes with a citation back to the source table and the definition version behind it, there is nothing left to reconcile. The number that shows up in the meeting is the number the data team would have produced anyway, because it came from the same governed pipeline.

    It also means every question leaves a prompt-level record: who asked, what was resolved, what ran, what came back. When a number is challenged, the answer to “where did this come from” is a lookup, not an investigation.

    This is not a security control bolted onto an existing BI stack. It is what removes the actual incentive for the shadow path to exist in the first place, because the sanctioned path stops being slower.

    The real question to ask

    The shadow AI tax rarely gets calculated directly, because it is spread across dozens of small interruptions rather than one visible incident. A more useful exercise than trying to measure it after the fact is asking the data team a simpler question: how many hours this month went toward verifying, reconciling, or explaining a number that didn’t originate with them?

    Whatever that number turns out to be, it is not a cost the business decided to pay. It is a cost that accumulated because the sanctioned path was slower than the alternative. Fixing that gap is what actually stops the tax from being collected again next month.