Next.js Sales Dashboard with SQL
Budget: $30 – $250 USD
I want a clean, responsive dashboard built in Next.js that pulls live sales data directly from my existing SQL database (MySQL or PostgreSQL—you can choose whichever you prefer for local development). The focus is purely on sales-related metrics: totals, revenue by product and region, daily trends, plus a couple of quick-glance KPIs such as average order value and conversion rate.
The database schema is already in place; what I’m missing is a front-end that fetches, aggregates, and presents that information in an intuitive way. Think simple routing with Next.js pages or app router, server-side fetching where it makes sense, and lightweight visualisations with Chart.js or a similar React-friendly library. Styling can be Tailwind, Chakra, or plain CSS modules—whatever lets you keep the bundle lean.
Please keep code modular (separate components for charts, tables, and filters), and add concise README notes so I can tweak connection strings and env variables myself.
Deliverables
• Next.js project folder ready to run with npm install & npm run dev
• Secure database connection layer (using environment variables, no credentials hard-coded)
• Reusable chart and KPI components displaying the sales metrics outlined above
• Basic date-range filter that re-queries and re-renders figures on change
• README covering setup, env vars, and build commands
Acceptance criteria
• Dashboard loads in <2 s on local machine and updates data without a full page refresh
• All SQL queries parameterised to prevent injection
• No TypeScript or linting errors on yarn build
That’s everything—I’ll test locally against my database and release final approval once the metrics match what I already calculate in Excel.
The database schema is already in place; what I’m missing is a front-end that fetches, aggregates, and presents that information in an intuitive way. Think simple routing with Next.js pages or app router, server-side fetching where it makes sense, and lightweight visualisations with Chart.js or a similar React-friendly library. Styling can be Tailwind, Chakra, or plain CSS modules—whatever lets you keep the bundle lean.
Please keep code modular (separate components for charts, tables, and filters), and add concise README notes so I can tweak connection strings and env variables myself.
Deliverables
• Next.js project folder ready to run with npm install & npm run dev
• Secure database connection layer (using environment variables, no credentials hard-coded)
• Reusable chart and KPI components displaying the sales metrics outlined above
• Basic date-range filter that re-queries and re-renders figures on change
• README covering setup, env vars, and build commands
Acceptance criteria
• Dashboard loads in <2 s on local machine and updates data without a full page refresh
• All SQL queries parameterised to prevent injection
• No TypeScript or linting errors on yarn build
That’s everything—I’ll test locally against my database and release final approval once the metrics match what I already calculate in Excel.