Web App Built for Analytics

Job ID: 40508427

Budget: ₹12,500 – ₹37,500 INR

I need a robust web application that ingests our raw sales data, processes it, and presents the results through clear, interactive charts and graphs. The same platform must also do these things:


1. Let the user login
2. Upload the data through existing template format
3. Upload the data
4. Map the data
5. Produce the report visuals/charts/table/summary etc.
6 Report should be sharable with team and individuals
7. Reports should have a special feature copy n paste stuff from anywhere out side of the web App.
8. Reports should have an option to be shared in different formats.
9. Users should be able to comment and collaborate on the reports.

I already have a POC built and alot of existing code can be reused.The existing project already uses a good, standard set of tools: Chart.js for charts, TipTap for rich text, ExcelJS and PapaParse for file parsing, jsPDF, docx and pptxgenjs for exports, and Nodemailer for email. All of these carry over to the new build. No need to reinvent any of that.

On the logic side, the reusable pieces are mostly the backend utilities, and they're clean, well-written code:

- Authentication: the JWT token handling and bcrypt password hashing move over as is.
- MongoDB connection: the connection pooling and Atlas setup carry over with a tiny tweak.
- User model: the user database operations are portable directly.
- Email service: the Nodemailer setup and HTML templates move over with no changes.
- File parsing: the actual Excel/CSV parsing functions (column type detection, value normalization, aggregation) are well done. We keep that logic and move it to run on the server.
- The existing API helper gives us a clean reference to model the new one on.



Deliverables
• Responsive dashboard that renders interactive charts/graphs of historical and current sales
• Forecasting module that projects future sales with adjustable parameters and clear error metrics
• Real-time data pipeline that updates the dashboards automatically without a page refresh
• Source code in a private Git repo, setup scripts, and concise deployment/read-me documentation

The project is complete when every deliverable above is merged into the repository, passes unit/integration tests, and is running on a cloud test environment I can access.

The current project is a single Next.js app where the UI, the database calls, file parsing, and exports all live together in one place. For a reporting tool like this, we strongly recommend splitting it into a separate backend (Express) and frontend (Vite React).

If this is something that you can deliver on time, please bid.