Skip to content

This GitHub repository showcases my completed project during the PwC Power BI Virtual Internship by Forage.Real-world data analysis & visualization with Power BI. Gained valuable insights in business intelligence.

License

Notifications You must be signed in to change notification settings

vkquests/PwC_Power_BI

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

10 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PwC_Power_BI

The PwC digital accelerator helps in advancing technical knowledge and applying these to client cases turning unrelated sources of data into coherent, truly immersive, and interactive insights using Power BI.

Introduction

PhoneNow, a telecom company, has sought PwC's expertise to create insightful dashboards for understanding their customers better. Tasks include visualizing call center manager trends, performing data analysis for customer retention, and preparing a dashboard to optimize HR processes, ensuring diverse and inclusive talent management.

Task 1: Call Centre Trends

Visualizing customer and agent behavior. Created a dashboard in Power BI for Claire (Call Centre Manager) that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset. KPIs include

  • Overall customer satisfaction
  • Overall calls answered/abandoned
  • Calls by time
  • Average speed of answer
  • Agent’s performance quadrant -> average handle time (talk duration) vs calls answered

image

Task 2: Customer Retention

Customer demographics and insights.

Created a dashboard in Power BI for Janet (Retention Manager) that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset. KPIs include

  • Customers who left within the last month
  • Services each customer has signed up for: phone, multiple lines, internet, online security, online backup, device protection, tech support, and streaming TV and movies
  • Customer account information: how long as a customer, contract, payment method, paperless billing, monthly charges, total charges and number of tickets opened in the categories administrative and technical
  • Demographic info about customers – gender, age range, and if they have partners and dependents

image image

Task 3: Diversity & Inclusion

Gender balance in the executive suite. Created a dashboard in Power BI for the HR Manager to support diversity and inclusion KPIs include

  • # of men
  • # of women
  • # of leavers
  • % employees promoted (FY21)
  • % of women promoted
  • % of hires men
  • % of hires women
  • % turnover
  • Average performance rating: men
  • Average Performance rating: women

image image

About

This GitHub repository showcases my completed project during the PwC Power BI Virtual Internship by Forage.Real-world data analysis & visualization with Power BI. Gained valuable insights in business intelligence.

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published