🚀 Universal AI Analytics Engine

An intelligent, data-aware analytics platform that transforms any CSV or Excel file into a professional, enterprise-grade dashboard. Using Groq's Llama 3.3 and Tambo's Generative UI, this project provides instant KPIs, deep statistical insights, and a natural language interface to "chat" with your data.

🎯 Key Capabilities

• 📊 Universal Data Discovery: Upload any dataset (Bikes, Sales, Shoppers, etc.) and the engine automatically identifies categories, numeric metrics, and patterns.
• 💬 Generative AI Chat: Ask questions like "Show me the top 5 brands by average price" and see instant charts and tables rendered via Generative UI.
• 🤖 Executive AI Insights: Get strategic summaries, KPI interpretations, and business recommendations generated by Llama 3.3.
• 📈 Dynamic Dashboard: A premium, "data-aware" dashboard that adapts its layout and titles and charts based on the specific columns found in your file.
• 🔍 Transactional Log: Full structural view of source records with deep-search capabilities.
• ⚡ Blazing Fast AI: Powered by Groq's Llama 3.3 70B for near-instant analytical responses.

---

🏗️ Architecture

graph TD
    User((User)) -->|Uploads CSV/XLSX| Web[React Frontend]
    Web -->|Proxies Requests| API[Express Backend]
    API -->|Analyzes Data| Engine[Universal Analytics Engine]
    Engine -->|Calculates Stats| API
    API -->|Prompts| Groq[Groq AI / Llama 3.3]
    Groq -->|Generates Insights| API
    API -->|Metrics + Insights| Web
    Web -->|Generative UI| Chat[AI Chat Assistant]

Loading

Technical Stack

• Frontend: React 19, Vite, Tailwind CSS, Recharts, Lucide React, Tambo AI SDK.
• Backend: Node.js, Express, Multer, XLSX, csv-parser.
• AI Engine: Groq SDK (Llama 3.3 70B Versatile).

---

📁 Project Structure

InsightOS/
├── backend/                # Node.js + Express API
│   ├── server.js           # Core Analytics Engine & AI Orchestration
│   └── uploads/            # Temporary storage for data files
├── tambo-genui/            # Vite + React Frontend
│   ├── src/
│   │   ├── components/     # Professional Dashboard & UI Components
│   │   ├── lib/
│   │   │   └── tambo.ts    # AI Tool Definitions & SDK Config
│   │   └── App.tsx         # Main Application Entry
└── README.md

---

🚀 Quick Start

1. Prerequisites

• Node.js: v18 or higher.
• Groq API Key: Get one here.

2. Backend Setup

1. Navigate to /backend.
2. Install dependencies:

   npm install

3. Create a .env file and add your key:

   GROQ_API_KEY=your_groq_api_key_here

4. Start the server:

   node server.js

   The backend runs on http://localhost:5000.

3. Frontend Setup

1. Navigate to /tambo-genui.
2. Install dependencies:

   npm install

3. Start the Vite dev server:

   npm run dev

   The frontend runs on http://localhost:5173 (or similar).

---

📡 Key Features & Logic

Universal Analytics Engine

The backend performs a "Deep Discovery" on every upload:

• Heuristic Typing: Automatically distinguishes between categorical and numeric data.
• Primary Value Selection: Detects the most significant numeric column (e.g., Price, Sales) to drive the dashboard KPIs.
• Time-Series Analysis: Detects date columns and aggregates data into monthly performance trends.

Generative UI (Tambo AI)

The chat interface doesn't just return text; it returns live components:

• DataTable: Responsive, fuzzy-matched tables for raw data views.
• Graph: Auto-configured charts (Bar, Line, Pie) for visual summaries.
• KPI Cards: Real-time metric highlights.

---

🛡️ License

Distributed under the MIT License. See LICENSE for more information.

---

Built with ❤️ by the Team