PwC Virtual Internship: Gain hands-on data analytics experience with Power BI. Create insightful dashboards for real-world challenges like customer retention, churn analysis, and diversity metrics.
This repository contains the solutions and details for tasks in the "PwC New World. New Skills: Power BI Virtual Case Experience."
Enroll in the PwC Virtual Internship
Objective: Create a dashboard in Power BI that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset.
Possible KPIs include:
- Overall customer satisfaction
- Overall calls answered/abandoned
- Calls by time
- Average speed of answer
- Agent’s performance quadrant (average handle time vs. calls answered)
Objective: Create a Dashboard that reflects customer churn.
Inputs considered:
- Customers who left within the last month
- Services each customer has signed up for
- 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
Objective: Define relevant KPIs in hiring, promotion, performance, and turnover and draw conclusions.
Measures created include:
- % of men
- % of women
- % of leavers
- % employees promoted (FY21)
- % of women promoted
- % of hires men
- % of hires women
- Average performance rating: men
- Average performance rating: women