Business Analytics Dashboard

Full-stack MERN business analytics dashboard that lets you upload CSV files, store parsed records in MongoDB, explore interactive KPI and chart views, and export the current dashboard summary as a PDF report.

Tech Stack

• Frontend: React, Vite, Tailwind CSS, Chart.js
• Backend: Node.js, Express, Mongoose
• Database: MongoDB
• Extras: Multer, Papa Parse, PDFKit

Project Structure

client/
server/
  controllers/
  models/
  routes/

Setup

1. Copy .env.example to server/.env or create it manually with your MongoDB URI.
2. Install dependencies:

npm run install:all

3. Start MongoDB locally, or update MONGODB_URI for your target database.
4. Run the app in development:

npm run dev

5. Open http://localhost:5173.

Environment Variables

Create server/.env with:

PORT=5000
MONGODB_URI=mongodb://127.0.0.1:27017/business_analytics
CLIENT_URL=http://localhost:5173

API Overview

• POST /api/upload uploads a CSV, parses it, infers schema, and stores records.
• GET /api/datasets lists uploaded datasets.
• GET /api/datasets/:id/analytics returns dashboard KPIs, filters, and chart data.
• GET /api/datasets/:id/report streams a PDF report for the active filter state.

Notes

• The app is designed to work with arbitrary CSVs. It infers likely numeric, date, category, and region columns to generate useful analytics automatically.
• If a CSV does not include a date, category, or region column, the dashboard gracefully falls back to available dimensions.