iOps - AI-Powered Data Analysis Platform

A comprehensive SaaS platform for data analysis, visualization, and collaboration with AI-powered insights, real-time collaboration, and a template marketplace.

🚀 Features

Core Analytics

• Data Upload & Processing: Support for CSV, Excel, and Parquet files
• AI-Powered Insights: Automated analysis with natural language explanations using Groq LLM
• Interactive Visualizations: Charts, graphs, and dashboards with Plotly
• Analysis Execution: Complete workflow from data upload to insights

Sharing & Collaboration

• Public Reports: Share analyses via unique short URLs with optional password protection
• Embeddable Charts: Iframe-ready charts for websites and blogs
• Real-time Collaboration: Live editing, comments, and presence indicators
• Activity Tracking: Complete audit trail of all user actions

Template Marketplace

• Template Creation: Save analysis workflows as reusable templates
• Marketplace: Buy and sell templates with revenue sharing (80/20 split)
• Auto-mapping: Intelligent column matching for template application
• Rating System: Community-driven template quality assessment

Freemium Business Model

• Usage Tracking: Monitor datasets, AI messages, and reports per tier
• Subscription Management: Paystack-powered billing with prorated upgrades
• Tier Enforcement: Automatic limit enforcement with upgrade prompts
• Analytics Dashboard: Comprehensive business metrics and KPIs

Data Connectivity

• Google Sheets: OAuth-based integration with automatic refresh
• Database Connectors: PostgreSQL and MySQL with encrypted credentials
• CSV URLs: Direct connection to online CSV files
• Airtable: API-based integration with table selection

🏗️ Architecture

Tech Stack

Layer	Technology
Frontend	Next.js 14, TypeScript, Tailwind CSS
Backend	Python 3.11+, FastAPI, SQLAlchemy
Database	PostgreSQL (prod) / SQLite (dev)
AI	Groq LLM API
Payments	Paystack
Email	Resend
Real-time	WebSockets

Project Structure

iOps/
├── backend/                 # FastAPI backend
│   ├── routers/            # API route handlers
│   ├── utils/              # Business logic utilities
│   ├── middleware/         # Custom middleware
│   ├── migrations/         # Database migrations
│   └── tests/              # Test suite
├── frontend/               # Next.js frontend
│   └── src/
│       ├── app/            # App router pages
│       ├── components/     # React components
│       └── lib/            # Utilities
├── docs/                   # Documentation
└── frontend-examples/      # OAuth integration examples

🔧 Quick Start

Prerequisites

• Python 3.11+
• Node.js 18+
• Git

Installation

1. Clone the repository

git clone https://github.com/Emart29/iOpsAI.git
cd iOpsAI

2. Backend Setup

cd backend
python -m venv venv
venv\Scripts\activate        # Windows
# source venv/bin/activate   # Linux/Mac
pip install -r requirements.txt
cp .env.example .env         # Configure your environment variables
python migrate.py upgrade
python run.py

3. Frontend Setup (new terminal)

cd frontend
npm install
cp .env.example .env.local   # Configure your environment variables
npm run dev

4. Access the application

• Frontend: http://localhost:3000
• Backend API: http://localhost:8000
• API Docs: http://localhost:8000/docs

📖 For detailed setup instructions, see SETUP_GUIDE.md

🔐 Security Features

• JWT authentication with bcrypt password hashing
• AES-256 encryption for sensitive credentials
• Role-based access control
• Rate limiting and tier-based usage enforcement
• SQL injection prevention via parameterized queries
• XSS and CSRF protection

💰 Subscription Tiers

Tier	Datasets	AI Messages	Reports	Price
Free	5/month	50/month	3/month	$0
Pro	Unlimited	Unlimited	Unlimited	$29/month
Team	Unlimited	Unlimited	Unlimited	$99/month
Enterprise	Custom	Custom	Custom	Contact us

🧪 Testing

cd backend
python -m pytest tests/ -v

Test coverage includes:

• Unit tests for all major components
• Property-based tests with Hypothesis
• Integration tests for API endpoints
• Security and authorization tests

📚 Documentation

• Setup Guide - Complete installation instructions
• API Documentation - API reference
• Deployment Guide - Production deployment
• Contributing - Contribution guidelines

🚀 Deployment

Recommended Platforms

• Frontend: Vercel
• Backend: Render, Railway, or AWS
• Database: PostgreSQL (managed)

See docs/DEPLOYMENT.md for detailed deployment instructions.

📄 License

This project is proprietary software. See LICENSE for details.

Permitted Uses:

• Personal evaluation (30 days)
• Educational use (non-commercial)
• Contributing under CLA

Commercial Use: Requires a separate license. Contact nwangumaemmanuel29@gmail.com

👤 Author

Emmanuel Nwanguma

• Email: nwangumaemmanuel29@gmail.com
• LinkedIn: Emmanuel Nwanguma
• GitHub: Emart29

---

Built with ❤️ for data analysts and business intelligence professionals.