← Teardowns

Backend Developer · Furniture Clinic · 2024

Furniture Clinic data pipelines

Automated ingestion of 30,000+ Amazon orders per month, pulled from Seller Central and the Advertising API into a unified MongoDB store that feeds live Power BI reporting.

Node.js · MongoDB · Power BI · Amazon SP-API · Advertising API

0+orders / monthdaily ETL
0–60%less reporting overheadPower BI
FIG.01Furniture Clinic: system at a glance
30,000+ orders / monthAMAZONSeller CentralAdvertising APIDAILY ETLNode.jsMongoDBraw + materialized viewsPower BIreporting

A Node.js ingestion service pulls orders and advertising data from the Amazon SP-API and Advertising API and writes them into a unified MongoDB store, on the order of 30,000 orders a month. Power BI reads from that store for live reporting.