-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
This chapter explored several different operational metrics and KPIs. Operational metrics are important because they assist organizations with optimizing internal processes, which can lead to greater efficiency, effectiveness, and profitability as well as aid in customer service. We began with common metrics such as On Time in Full (OTIF) and Order Cycle Time (OCT) which are used throughout supply chains all over the globe. We then explored calculating Delivery Dates in the context of fulfilling backorders. Here we introduced the concept of DAX while loops as well as covered the use of the EARLIER function.
We used the knowledge gained to explore two different methods of calculating Mean Time Between Failure (MTBF) as well as Mean Time To Repair (MTTR) and the Overall Equipment Effectiveness (OEE). We then finished the chapter with a rather simple calculation for Days of Supply as well as an extremely complex metric for Order Fulfillment, which identified the locations from which...