SPIL Power BI Dashboards: Turn raw data into smarter, faster decisions

Track orders, sales and invoicing against budget, and see which customers and products drive your business.

• Order amount, total orders, sales amount and total invoiced, each compared with the last period
• Monthly budget gauge with target, revenue and today’s figures
• Orders vs sales and quote-to-order trends across the year
• Top customers and top products
• Recent orders with their status

See what is planned, completed and overdue on the factory floor — with a TV mode for the shop floor and filters by facility and station.

• Planned today, completed today and carry forward
• Scheduled, completed and overdue panels, on-time rate and machine utilisation
• Station capacity preview showing available, used and over-capacity stations
• Recut & loss intelligence: recut rate against target, cost impact, root causes and recommended actions
• Scrap analysis by glass type, panel type distribution and machine utilisation

Follow every run from scheduling to delivery, with live driver tracking and the quality figures that matter to your customers.

• Delivery performance over time and orders by delivery area
• Dispatch status by run, driver, vehicle and area
• Live driver tracking on a map, with the selected run’s status and location
• Partial deliveries tracking, order status distribution and dispatch trend
• DIFOT analysis, delivery method split, and recuts & NCR analysis

Keep glass stock under control, from stock levels and consumption to reorder alerts for each item.

• Total SKUs, stock value, low-stock items and pending orders
• Stock levels by glass type and material split
• Monthly consumption in square metres
• Alerts and reorder flags for critical and low stock
• Top inventory items with thickness, stock, reserved, available, status and bay

Stay on top of what customers owe you, what is overdue and how quickly invoices are paid.

• Total receivables, overdue amount, current period and on-time payment rate
• Top customers by receivables
• Receivables trend over one, three, six or twelve months — total, overdue and current
• Aging analysis and collection rate
• Recent invoices with due dates and status

See how the automated customer SMS messages from the SPIL SMS module are performing.

• Total, delivered, pending and failed messages
• Daily SMS volume — sent, pending and failed
• Message types, such as ready for pickup, order confirmation and delivery delay
• Recent SMS activity
• Top customers by SMS volume, with delivery rates