-
Book Overview & Buying
-
Table Of Contents
DAX for Humans
By :
In this chapter, we explored numerous scenarios dealing with customers. This included identifying new, lost, and returning customers as well as calculating net promoter score, churn rate, lifetime value, and acquisition costs. In addition, we explored support metrics such as open tickets and average time to close. Next, we calculated customer funnel drop-off rates and explored how to report on different products being ordered together. Finally, we wrapped up the chapter with calculations for annual contract value (ACV) as well as sales after an event.
Throughout this chapter, almost every calculation has essentially been a version of the A DAX Pattern to Solve Most Problems from Chapter 1, Introducing DAX. Most of the formulas use the basic pattern of creating virtual tables that group and/or filter the base data and then use X aggregators across those tables. This pattern continues as we explore human resource metrics and KPIs in the next chapter.