Case Study
Business Operations Dashboard
A comprehensive business operations management dashboard built with Next.js, Firebase Authentication, and Cloud Firestore. It enables efficient tracking of orders, expenses, and inventory while providing real-time financial reporting and automated backups.
01
Challenge
The factory needed a unified, robust system to manage orders, track product inventory, and monitor expenses securely without relying on informal or scattered communication.
02
Solution
I built a role-based dashboard with advanced order parsing, inventory tracking, customer history management, and automated daily Google Sheets backups.
03
Outcome
The dashboard streamlined factory operations by enforcing structured data, providing real-time inventory updates, and delivering clear, actionable financial reports.
Project Media
Visuals and Walkthroughs
Executive Operations Dashboard
Real-time summary of sales, daily orders, gross profit, and factory performance metrics.
Inventory & Stock Management
Real-time stock level monitoring, raw material inventory, and automated SKU tracking.
Order Intake & Processing
Streamlined order creation workflow with instant price calculation and itemized dispatching.
Customer Directory & Order History
Client account management with purchase frequency, contact records, and outstanding balances.
Factory Expense Tracker
Categorized tracking of production costs, overhead, raw material purchases, and transport.
Financial & Ledger Analytics
Automated revenue analytics, expense-to-sales ratios, and downloadable operational reports.
Order Management & Status Workflow
Full lifecycle editing interface supporting order amendments, cancellations, and status transitions.
Key Highlights