Excel Analytics Platform

Full-stack Excel analytics app with 2D/3D chart generation, JWT auth, and AI insights.

Stack

• Frontend: React 19, Redux Toolkit, Tailwind CSS, Chart.js, Three.js, Framer Motion
• Backend: Node.js, Express, MongoDB, Multer, XLSX, OpenAI
• Deploy: Netlify (frontend) · Render (backend)

Quick Start

Backend

cd backend
cp .env.example .env        # fill in MONGO_URI, JWT_SECRET, OPENAI_API_KEY
npm install
npm run dev                 # runs on http://localhost:5000

Frontend

cd frontend
cp .env.example .env        # set VITE_API_URL
npm install
npm run dev                 # runs on http://localhost:5173

Features

• Upload .xlsx / .xls / .csv files (up to 10MB)
• Dynamic column mapping for X/Y axes
• Animated 2D charts: Bar, Line, Pie, Scatter
• Interactive 3D charts: 3D Bar, 3D Scatter (drag to rotate)
• Download charts as PNG or PDF
• AI-powered data summaries via OpenAI GPT
• JWT auth with user & admin roles
• Admin panel: user management & platform stats
• Full upload & chart history on dashboard

Deployment

Render (Backend)

• Set env vars in Render dashboard
• Build command: npm install
• Start command: node src/index.js

Netlify (Frontend)

• Build command: npm run build
• Publish directory: dist
• Set VITE_API_URL to your Render backend URL