PwC Switzerland Customer Churn data Analysis

PwC Power-BI in Data Analytics Project: The virtual PowerBI Case experience is an excellent starting point for a Data Analyst looking to build a career with Power BI. This experience consists of three case studies on three different datasets. The real-world datasets help you understand the business scenarios and steps to solve the business problems.

Case Study 1: Call Centre Trends

  • Analyzing the number of incoming calls, call agent's performance, speed of answer, call duration, trends on a daily and hourly basis, and customer satisfaction ratings.
  • The dashboard defines key KPIs that impact customer satisfaction and call agent performance.
  • The goal is to identify opportunities where performance can be monitored and enhanced.

Case Study 2: Customer Retention Dashboard

  • The organization seeks to identify customers likely to churn.
  • The dashboard creates KPIs around demographics, company service, and customer profiling to identify which customers are at high risk of churning.
  • The analysis provides key insights to help board members take steps to reduce churn and increase customer loyalty.

Case Study 3: HR Analytics - Diversity and Inclusivity

  • Creating a dashboard to track employee participation in the organization.
  • Defining KPIs such as New Hires, Promotions, Employee Exits, and Employee Gender Ratio to understand the situation of diversity and inclusivity in the workforce.
  • Enabling diversity and eliminating gender-based stereotyping is key to a balanced workforce and company success.