I sourced a fictional telecommunications operator’s practice dataset from Kaggle. The data revealed that 27% of the operator’s customers had churned within the previous 30 days.
The analysis addresses two critical business questions:
- How can we identify customers with the highest risk of terminating their subscription?
- How can we tailor our services to prevent customer churn?
Workflow & Tools
- Importing the Kaggle dataset into Power BI as an Excel file.
- Cleaning the data, defining correct data types, and localizing the dataset into Finnish.
- Identifying key research questions and business hypotheses.
- Developing custom DAX measures and calculated columns.
- Building intuitive dashboards to highlight trends.
- Creating a PowerPoint presentation to support executive decision-making and presenting the findings.
Outcome: I identified the most critical customer segments and developed a concrete, data-driven action plan to reduce customer churn and protect recurring revenue.
Please take a look at the following video, in which I introduce the project and analysis (in Finnish, 15 min).
