CHAPTER II / II.4
II.4
Retail operations BI dashboard
The business needed a clearer way to track performance across sales, purchases, procurement, ad spend, revenue, and day-to-day operations. Data entry and reporting needed to be structured enough for owners and stakeholders to understand the business without chasing scattered files or manual summaries.
Context
The business needed a clearer way to track performance across sales, purchases, procurement, ad spend, revenue, and day-to-day operations. Data entry and reporting needed to be structured enough for owners and stakeholders to understand the business without chasing scattered files or manual summaries.
Build
Built an internal business intelligence and operational data platform for a premium retail and F&B operation. Different employee roles enter the data they own, while owners and stakeholders use dashboards to review performance and make decisions.
Outcome
The dashboard replaced 50+ Excel files with a single PostgreSQL source of truth, and eliminated spreadsheet formula errors by moving KPI math server-side, where a cell formula can't be edited. Manual consolidation that used to take hours now runs in seconds through automated rollups. Staff enter the operational data they own, and owners and stakeholders review performance from the dashboards instead of chasing scattered files and manual summaries.
Key capabilities
Role-based data entry for sales, purchases, procurement, marketing spend, revenue, and operational facts.
Dashboards for owners and stakeholders.
PostgreSQL as the structured system of record.
Admin and master-data management.
Auditability for operational entries.
Reporting views shaped around how the business actually reviews performance.