Skip to content
Ahmad Humayun
← All case studies

Ecommerce & Marketplace Analytics

Amazon Vendor/Seller Analytics Dashboard

Custom marketplace analytics dashboard built around recurring vendor/seller reports, email ingestion, MySQL storage, and a Next.js reporting UI.

Marketplace Seller · Solo · Selected work

My role & contribution

Engineering work for this individual freelance engagement.

The problem

Built a marketplace reporting system for recurring vendor/seller reports that were otherwise handled through manual files and email workflows. Python ingestion scripts collected and loaded reports into MySQL, while a Next.js dashboard exposed authenticated reporting views, filters, tables, charts, and export workflows.

Amazon Vendor/Seller Analytics Dashboard
Illustrative project visual. Any figures shown are examples, not a statement of client results.

System flow

  1. 01

    Report capture

    Recurring marketplace reports and email-delivered files are collected through Python/Gmail workflows.

  2. 02

    Storage layer

    Parsed report rows land in a MySQL reporting schema designed around dashboard queries.

  3. 03

    Reporting app

    A Next.js dashboard reads the reporting tables for authenticated filters, grids, charts, and exports.

  4. 04

    Validation

    Report periods, source totals, and dashboard totals are checked before stakeholders use the views.

Difficult problems

  • Marketplace reports arrived through recurring files and email workflows rather than one clean API
  • Report formats and periods could drift from the dashboard schema
  • Dashboard totals needed to be validated against source report totals
  • The client needed a custom interface beyond spreadsheets or generic BI

Work contributed

  • Built report ingestion into a MySQL reporting layer
  • Created authenticated dashboard views with filters, grids, charts, and exports
  • Separated ingestion, database validation, and UI reporting concerns
  • Documented the reporting workflow so the system could be maintained after handoff

Supported outcome

  • Built report ingestion into a MySQL reporting layer
  • Created authenticated dashboard views with filters, grids, charts, and exports
  • Separated ingestion, database validation, and UI reporting concerns
  • Documented the reporting workflow so the system could be maintained after handoff

Technologies in context

Next.js · Python · MySQL · Gmail API · pandas · AG Grid · Recharts · NextAuth · CSV Export

Related services & work

Technical reading

Working through a similar problem?

Share the workflow and the output your team needs. We can identify a focused starting point.

Discuss your workflow