Skip to main content

Node Inputs

Required Fields

CSV Data:
The CSV file or data to analyze (file upload or text).
Example: Upload a CSV file or paste CSV text.
Analysis Query:
The question or analysis request.
Example: "What are the top 5 products by sales revenue? Identify any trends in the data."

Optional Fields

Analysis Type:
The type of analysis to perform.
Available options:
  • summary: General data summary
  • trends: Trend analysis
  • comparison: Comparative analysis
  • prediction: Predictive insights
  • custom: Custom query
    Default: custom
Include Visualizations:
Whether to generate data visualizations.
Example: true
Default: false
Max Rows to Analyze:
Maximum number of rows to process (for large datasets).
Example: 10000
Default: All rows
Output Format:
Format for the analysis results.
Available options:
  • text: Plain text report
  • markdown: Markdown formatted
  • json: Structured JSON
    Example: "markdown"
    Default: "text"
Language:
Language for the analysis output.
Example: "en"
Default: "en"

Node Output

Analysis Results:
Comprehensive analysis of the CSV data with insights and recommendations.
Example Output:
{
  "query": "What are the top 5 products by sales revenue? Identify any trends in the data.",
  "analysis": {
    "summary": "Analysis of 1,247 rows of sales data reveals strong performance in electronics category.",
    "top_products": [
      {
        "product": "Wireless Headphones",
        "revenue": 125000,
        "units_sold": 1250,
        "trend": "increasing"
      },
      {
        "product": "Smart Watch",
        "revenue": 98500,
        "units_sold": 985,
        "trend": "stable"
      },
      {
        "product": "Laptop Stand",
        "revenue": 67200,
        "units_sold": 2240,
        "trend": "increasing"
      }
    ],
    "trends": [
      {
        "insight": "Electronics showing 35% growth quarter-over-quarter",
        "confidence": "high"
      },
      {
        "insight": "Seasonal spike in Q4 sales, particularly in December",
        "confidence": "high"
      }
    ],
    "recommendations": [
      "Increase inventory for Wireless Headphones ahead of Q4",
      "Consider promotional campaign for Smart Watch to boost growth"
    ]
  },
  "data_stats": {
    "total_rows": 1247,
    "total_columns": 8,
    "date_range": "2024-01-01 to 2024-10-19",
    "total_revenue": 856700
  },
  "visualizations": [
    {
      "type": "bar_chart",
      "title": "Top 5 Products by Revenue",
      "url": "https://storage.example.com/charts/chart_1.png"
    }
  ]
}

Node Functionality

The CSV Analyzer node:
  • Uses AI to analyze CSV data and extract insights.
  • Answers natural language questions about your data.
  • Identifies trends, patterns, and anomalies.
  • Provides actionable recommendations.
  • Generates summaries and reports.
  • Creates visualizations for better understanding.
  • Supports large datasets with sampling options.

Use Cases

Sales Analysis:
  • Identify top-performing products
  • Analyze revenue trends
  • Forecast future sales
Marketing Analytics:
  • Campaign performance analysis
  • Customer segmentation insights
  • ROI calculations
Operations:
  • Process efficiency analysis
  • Resource utilization insights
  • Cost optimization opportunities
Research:
  • Survey data analysis
  • Pattern identification
  • Statistical insights

Example Queries

Sales:
  • “What are the top 10 customers by total purchase value?”
  • “Show me monthly revenue trends for the last year”
  • “Which products have declining sales?”
Marketing:
  • “What’s the conversion rate by traffic source?”
  • “Which campaigns have the best ROI?”
  • “Identify customer demographics with highest engagement”
Operations:
  • “What are the peak hours for customer support tickets?”
  • “Analyze delivery times by region”
  • “Identify bottlenecks in the production process”