Solomon BI Dashboard — Rockbell branded with orange theme, SGD currency, traffic light indicators, salesperson and product views, customer retention and dormant tracking

ROCKBELL BI Dashboard
On track Monitor Action needed
Business health — traffic light summary
Monthly sales trend
Monthly trend.
Customer retention rate
Retention.
Sales by salesperson
By salesperson.
Sales by product category
By category.
Sales by debtor type
By debtor type.
Sales by area
By area.
        Actual vs target — top 10
        Actual vs target.
        Monthly trend (12 months)
        Monthly trend.
        Salesperson performance — traffic light
        SalespersonSales SGDTargetAttain%Inv countAvg inv valueYoYStatus
        Sales by salesperson
        By salesperson.
        Avg invoice value by salesperson
        Avg invoice.
        Monthly sales — per salesperson
        Salesperson trend.
          Sales by product category
          By category.
          Category performance — traffic light
          CategorySales SGDTargetAttain%UnitsAvg priceYoYStatus
          0
          New customers
          0
          Repurchasing
          0
          Dropped off
          0
          Dormant (>60d)
          Customer retention & drop-off by month
          Retained New Dormant Dropped
          Retention trend.
            Dormant customers — last purchase > 60 days
            CustomerTypeLast purchaseDays dormantLifetime value SGDStatus
            Customer monthly sales movement
            Total CN amount
            —
            accumulated
            CN count
            —
            credit notes
            CN / Sales ratio
            —
            —
                  CN trend by month
                  CN trend.
                  Overall ageing breakdown
                  Current 1–30d 31–60d 61–90d >90d
                  Ageing by debtor type
                  Ageing by type.
                    Overdue status — traffic light
                    CustomerOutstanding SGDOverdue daysStatus
                    Invoice count & avg value by debtor type
                    Invoice metrics.
                    Total purchases
                    —
                    accumulated
                    Creditor outstanding
                    —
                    payable ageing
                    Avg payment days
                    —
                    days
                    Purchases by supplier
                    By supplier.
                    Purchase ageing by supplier
                    Current 31–60d >60d
                    Purchase ageing.
                    Sales YoY
                    —
                    vs prior year
                    COGS YoY
                    —
                    vs prior year
                    Gross margin
                    —
                    current period
                    Expenses YoY
                    —
                    vs prior year
                    Sales — current vs prior year
                    Current year Prior year
                    Sales comparison.
                    COGS comparison
                    CurrentPrior
                    COGS.
                    Expenses comparison
                    CurrentPrior
                    Expenses.