What if you could replace spreadsheets with the #1 analytics tool by this time next month?
Tracking your delivery commitments to customers is a vital function of providing good customer service and maintaining your reputation. We covered extensively how you can track late shipments and on time delivery in Business Central and construct the Power BI dashboard detailed below.
Here we will give an overview of the different components that were implemented in the report.
See how many times you shipped late to your customers
The top component features a simple bar graph that displays the count of late shipments that were identified as being late. Importantly, as it relates to Business Central, this is counting unique document numbers of shipment documents so each individual shipment will be counted, regardless of partial shipments.
By utilizing the hierarchy feature we have added the ability to step down into the weekly view of this same metric.