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.
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.
In the bottom left we have a small grid table shows the number of shipments per month for each department, as well as, a table showing the average number of late shipment days per month for each department. This table interactions nicely with the pie chart whereby you can click on a slice to filter the tables and the rest of the dashboard for only that department.
The final component is a simple gauge that gives a quick view of the companies current overall customer late shipments percentage. The 92% line shows our benchmark goal and makes it easy to see how close we are to being on target.
Getting started with Power BI is hard. To make it easy, we put together a library of resources with Report Templates, Design Ideas, DAX, and much more.