Project · Analytics Dashboard Backend

Build a MongoDB-backed API that returns aggregated stats across two collections using $group, $match, $project, and $lookup. The API must have at least three endpoints: one returning revenue by status over a date range, one returning a faceted product search result, and one joining orders with user details.

• A runnable server with at least 3 aggregation endpoints.
• At least one $lookup joining two collections.
• At least one $facet returning two simultaneous sub-aggregations.
• A README with setup instructions and sample curl commands.

• All aggregation stages run server-side — no post-processing in application code.
• $match stages appear before $group stages where applicable.
• The faceted endpoint returns consistent snapshot results (not multiple queries merged).
• Response time under 100ms for a collection of 10,000 documents.