AutomationFlowsAI & RAG › Data Analytics Department with AI Team: Cdo & Specialists Using Openai O3

Data Analytics Department with AI Team: Cdo & Specialists Using Openai O3

ByYaron Been @yaron-nofluff on n8n.io

Complete AI-powered data analytics department with a Chief Data Officer (CDO) agent orchestrating specialized data team members for comprehensive data science, business intelligence, and analytics operations.

Chat trigger trigger★★★★☆ complexityAI-powered18 nodesChat TriggerAgentTool ThinkAgent ToolOpenAI Chat
AI & RAG Trigger: Chat trigger Nodes: 18 Complexity: ★★★★☆ AI nodes: yes Added:

This workflow corresponds to n8n.io template #6912 — we link there as the canonical source.

This workflow follows the Agent → Agenttool recipe pattern — see all workflows that pair these two integrations.

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

Download .json
{
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "CDO Agent with Data Analytics Team",
  "nodes": [
    {
      "id": "analytics-chat-trigger",
      "name": "When chat message received",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -2864,
        -576
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 1.1
    },
    {
      "id": "cdo-agent",
      "name": "CDO Agent",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -2640,
        -816
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 2.1
    },
    {
      "id": "analytics-think",
      "name": "Think",
      "type": "@n8n/n8n-nodes-langchain.toolThink",
      "position": [
        -2512,
        -496
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "data-scientist-agent",
      "name": "Data Scientist Agent",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -2240,
        -96
      ],
      "parameters": {
        "text": "={{ $fromAI('Prompt__User_Message_', ``, 'string') }}",
        "options": {},
        "toolDescription": "call this AI Agent that specializes in statistical analysis, predictive modeling, machine learning algorithms, and data insights extraction"
      },
      "typeVersion": 2.2
    },
    {
      "id": "bi-analyst-agent",
      "name": "Business Intelligence Analyst Agent",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -1280,
        -704
      ],
      "parameters": {
        "text": "={{ $fromAI('Prompt__User_Message_', ``, 'string') }}",
        "options": {},
        "toolDescription": "call this AI Agent that specializes in business metrics analysis, KPI tracking, performance dashboards, and strategic insights"
      },
      "typeVersion": 2.2
    },
    {
      "id": "data-engineer-agent",
      "name": "Data Engineer Agent",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -1840,
        -304
      ],
      "parameters": {
        "text": "={{ $fromAI('Prompt__User_Message_', ``, 'string') }}",
        "options": {},
        "toolDescription": "call this AI Agent that specializes in data pipelines, ETL processes, data warehousing, and data infrastructure management"
      },
      "typeVersion": 2.2
    },
    {
      "id": "ml-engineer-agent",
      "name": "Machine Learning Engineer Agent",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -1328,
        -80
      ],
      "parameters": {
        "text": "={{ $fromAI('Prompt__User_Message_', ``, 'string') }}",
        "options": {},
        "toolDescription": "call this AI Agent that specializes in ML model deployment, MLOps, model monitoring, and production machine learning systems"
      },
      "typeVersion": 2.2
    },
    {
      "id": "data-viz-agent",
      "name": "Data Visualization Specialist Agent",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -1744,
        -1024
      ],
      "parameters": {
        "text": "={{ $fromAI('Prompt__User_Message_', ``, 'string') }}",
        "options": {},
        "toolDescription": "call this AI Agent that specializes in interactive dashboards, data storytelling, visual analytics, and business intelligence reporting"
      },
      "typeVersion": 2.2
    },
    {
      "id": "data-governance-agent",
      "name": "Data Governance Specialist Agent",
      "type": "@n8n/n8n-nodes-langchain.agentTool",
      "position": [
        -1344,
        -1264
      ],
      "parameters": {
        "text": "={{ $fromAI('Prompt__User_Message_', ``, 'string') }}",
        "options": {},
        "toolDescription": "call this AI Agent that specializes in data quality assurance, compliance frameworks, data privacy, and governance policies"
      },
      "typeVersion": 2.2
    },
    {
      "id": "cdo-model",
      "name": "OpenAI Chat Model CDO",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -2672,
        -496
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "o3",
          "cachedResultName": "o3"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "data-scientist-model",
      "name": "OpenAI Chat Model1",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -2208,
        368
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "bi-analyst-model",
      "name": "OpenAI Chat Model2",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1312,
        -496
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "data-engineer-model",
      "name": "OpenAI Chat Model3",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1824,
        -144
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ml-engineer-model",
      "name": "OpenAI Chat Model4",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1328,
        96
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "data-viz-model",
      "name": "OpenAI Chat Model5",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1776,
        -768
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "data-governance-model",
      "name": "OpenAI Chat Model6",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -1312,
        -944
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4.1-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "name": "<your credential>"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "header-sticky",
      "name": "Sticky Note Header",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3808,
        -880
      ],
      "parameters": {
        "color": 5,
        "width": 580,
        "height": 320,
        "content": "=======================================\n       CDO AGENT WITH DATA ANALYTICS TEAM\n=======================================\nFor any questions or support, please contact:\n    Yaron@nofluff.online\n\nExplore more tips and tutorials here:\n   - YouTube: https://www.youtube.com/@YaronBeen/videos\n   - LinkedIn: https://www.linkedin.com/in/yaronbeen/\n======================================="
      },
      "typeVersion": 1
    },
    {
      "id": "main-sticky",
      "name": "Sticky Note Main",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -3808,
        -544
      ],
      "parameters": {
        "color": 5,
        "width": 740,
        "height": 2500,
        "content": "## \ud83e\udde0 **CDO AGENT WITH DATA ANALYTICS TEAM - AI WORKFLOW**\n\n**\ud83d\udd25 Powered by OpenAI O3 & GPT-4.1-mini Multi-Agent System**\n\n#DataAnalytics #DataScience #BusinessIntelligence #n8nWorkflows #OpenAI #DataDriven\n\n---\n\n### \ud83d\udcdd **Overview**\n\nThis multi-agent n8n automation simulates a complete data analytics department. A strategic CDO (Chief Data Officer) agent receives your data requests, analyzes analytics needs, and delegates to specialized agents for data science, business intelligence, data engineering, machine learning, visualization, and governance\u2014delivering comprehensive data insights instantly.\n\n---\n\n### \u2699\ufe0f **How It Works**\n\n1. **Chat trigger** receives analytics requests (e.g., \"Analyze customer churn patterns and predict retention\")\n2. **CDO Agent** (O3) analyzes request and determines required data functions\n3. Delegates to specialist agents:\n   - Data Scientist Agent\n   - Business Intelligence Analyst Agent\n   - Data Engineer Agent\n   - Machine Learning Engineer Agent\n   - Data Visualization Specialist Agent\n   - Data Governance Specialist Agent\n4. Each agent uses **GPT-4.1-mini** for fast, focused execution\n5. Results compiled and returned via chat or integrated with analytics platforms\n\n---\n\n### \ud83d\udc65 **Meet Your AI Data Analytics Team**\n\n| Agent | Purpose | Model | Output |\n|-------|---------|-------|--------|\n| \ud83e\udde0 **CDO Agent** | Data strategy & team delegation | O3 | Central command |\n| \ud83d\udcca **Data Scientist** | Statistical analysis, ML algorithms, insights | GPT-4.1-mini | Predictive models |\n| \ud83d\udcc8 **BI Analyst** | Business metrics, KPIs, dashboards | GPT-4.1-mini | Strategic insights |\n| \ud83d\udd27 **Data Engineer** | ETL pipelines, data infrastructure | GPT-4.1-mini | Data architecture |\n| \ud83e\udd16 **ML Engineer** | Model deployment, MLOps, monitoring | GPT-4.1-mini | Production ML |\n| \ud83c\udfa8 **Data Viz Specialist** | Interactive dashboards, storytelling | GPT-4.1-mini | Visual analytics |\n| \ud83d\udee1\ufe0f **Data Governance** | Quality, compliance, privacy policies | GPT-4.1-mini | Governance frameworks |\n\n---\n\n### \ud83d\udca1 **Use Cases**\n\n- **Predictive Analytics**: Customer behavior, sales forecasting, risk assessment\n- **Business Intelligence**: KPI tracking, performance analysis, strategic insights\n- **Data Engineering**: Pipeline automation, data warehousing, real-time processing\n- **Machine Learning**: Model development, deployment, and monitoring\n- **Data Visualization**: Interactive dashboards, executive reporting, data storytelling\n- **Data Governance**: Quality assurance, compliance frameworks, privacy protection\n\n---\n\n### \ud83d\udcb8 **Cost Optimization**\n\n- **O3 for CDO**: Strategic data decisions only\n- **GPT-4.1-mini for specialists**: 90% cost reduction\n- **Parallel processing**: All agents work simultaneously\n- **Template libraries**: Reusable analytics frameworks\n\n---\n\n### \ud83c\udff7\ufe0f **Tags**\n\n#DataAnalytics #DataScience #BusinessIntelligence #MachineLearning #DataEngineering\n#DataVisualization #DataGovernance #PredictiveAnalytics #BigData #DataDriven\n#OpenAI #MultiAgentSystem #AnalyticsAutomation #DataStrategy #n8n"
      },
      "typeVersion": 1
    }
  ],
  "connections": {
    "Think": {
      "ai_tool": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model1": {
      "ai_languageModel": [
        [
          {
            "node": "Data Scientist Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model2": {
      "ai_languageModel": [
        [
          {
            "node": "Business Intelligence Analyst Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model3": {
      "ai_languageModel": [
        [
          {
            "node": "Data Engineer Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model4": {
      "ai_languageModel": [
        [
          {
            "node": "Machine Learning Engineer Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model5": {
      "ai_languageModel": [
        [
          {
            "node": "Data Visualization Specialist Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model6": {
      "ai_languageModel": [
        [
          {
            "node": "Data Governance Specialist Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Data Engineer Agent": {
      "ai_tool": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Data Scientist Agent": {
      "ai_tool": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "OpenAI Chat Model CDO": {
      "ai_languageModel": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "CDO Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Machine Learning Engineer Agent": {
      "ai_tool": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Data Governance Specialist Agent": {
      "ai_tool": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Business Intelligence Analyst Agent": {
      "ai_tool": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Data Visualization Specialist Agent": {
      "ai_tool": [
        [
          {
            "node": "CDO Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Complete AI-powered data analytics department with a Chief Data Officer (CDO) agent orchestrating specialized data team members for comprehensive data science, business intelligence, and analytics operations.

Source: https://n8n.io/workflows/6912/ — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

AI & RAG

This workflow deploys a fully autonomous "AI SEO Agency" inside your n8n instance.

Chat Trigger, OpenAI Chat, Agent Tool +5
AI & RAG

This workflow builds a virtual finance department inside n8n. At the center is a CFO Agent (O3 model) who acts like a strategic leader. When a financial request comes in, the CFO interprets it, decide

Chat Trigger, Agent, Tool Think +2
AI & RAG

This n8n workflow simulates a full-service creative agency powered by AI. At the center is a Creative Director Agent (O3 model) who takes client requests, plans the creative direction, and delegates w

Chat Trigger, Agent, Tool Think +2
AI & RAG

This multi-agent n8n automation simulates a high-functioning marketing team. A strategic CMO agent receives your chat-based input, decides which specialist is best for the task, and delegates accordin

Chat Trigger, Agent, Tool Think +2
AI & RAG

Complete AI-powered sales department with a Chief Sales Officer (CSO) agent orchestrating specialized sales team members for comprehensive revenue operations and sales automation.

Chat Trigger, Agent, Tool Think +2