Overview - Adding KPIs
Now that we've created a series of visuals and pivot tables, we need to collate this information to provide the best insights possible to address any key concerns around churn.
In this exercise, we'll start by preparing our dashboard sheet to display key information such as total customers, number of churned customers and churn rate.
If you've lost progress, open up 3_1_adding_kpis.xlsx from the Workbooks folder.
This exercise is part of the course
Case Study: Analyzing Customer Churn in Excel
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise