ctxdexSynthetic model data for learning
Data & Analytics

Data Analysis / BI Analyst Agent

Interprets analysis questions, generates data queries, reasons over results and produces analytical outputs.

Represents an analytical workflow combining question interpretation, query generation, database execution, deterministic calculation, model reasoning, validation and output generation.

AnalyticsBIDataReasoning
Explore Scenario Economics →

Design variants

The same solution, implemented 2 ways. Choosing one changes the workflow and dependencies described below; it does not calculate anything.

How it works

6 operations and 8 activities, in the order they run. Expand an operation to see its activities.

  1. Interpret the business question and state the analysis objectives.

  2. Identify the data sources and produce a query plan.

  3. Generate the queries and run them against the warehouse. The execution is external and unpriced: rows scanned are not tokens.

  4. Prepare the result deterministically and check the findings against it.

  5. Reason analytically over the prepared dataset.

  6. Write the business-facing report and its chart specifications.

What this solution uses

For Quick Analysis. An activity that calls a model and a service appears in both groups.

AI / model work6

  • Model Question InterpretationInterpret Analysis RequestDefault: Ctxdex Intelligence 4 Fast
  • Model Query PlanningPlan Data AnalysisDefault: Ctxdex Intelligence 4 Fast
  • Model Query GenerationGenerate Data QueryDefault: Ctxdex Code 2
  • Model Finding ValidationValidate Analysis Findings
  • Model Analytical ReasoningAnalyze Business ResultsDefault: Ctxdex Intelligence 4 Fast
  • Model Report ProductionProduce BI Analysis OutputDefault: Ctxdex Intelligence 4 Fast

Services0

None in this design

    Application / workflow work2

    • External Query ExecutionExecute Data Query
    • Deterministic PreparationNormalize Analysis Results

    Design details

    Business unit
    Analysis Request
    Design variants
    2
    Operations
    6
    Activities
    8
    Model-backed activities
    6
    Priced service dependencies
    0
    Application / workflow activities
    2

    Explore Scenario Economics

    Scenario Economics calculates this solution. There you can choose a compatible model or offering for each activity, set workload assumptions and volume, and change the other inputs Quick Analysis supports.

    Open Scenario Economics →