This repository displays the process and outcomes of the tasks completed during the PwC Switzerland PowerBI Virtual Case Experience developed by Forage. The virtual internship is created to simulate work in the Digital Accelerator team at PwC Switzerland and leverages Power BI.All of these .pbix files and insights were my submissions for this program, except for the data files which were assigned by PwC Switzerland.
At PwC, we work with global organizations, upskilling our 276,000 employees. Our goal is to provide everyone with the opportunity to learn, work, and participate in the digital world. Our employees have the chance to become "Digital Accelerators" by rapidly deepening their skills in digital specialties such as data, automation, AI, and digital storytelling. They do this by learning self-service tools and coding languages and applying these skills across our business. Your manager, Giulia, will guide you through your upskilling journey in PowerBI. You'll become a data Jedi and Digital Accelerator. An important client (communication has already reached out to you for help visualizing their data.
This virtual experience program consists of 3 tasks:
- Task 1: Create Call Centre Dashboard - visualizing customer and agent behavior.
- Task 2: Create Customer Retention and predict churn customers - visualizing customer demographics and insights.
- Task 3: Create Diversity and Inclusion in HR - visualizing gender balance in the executive suite.
-
Call Center Trends: Analyzed 5,000 calls, identifying a 19% abandonment rate and a 3.4/5 customer satisfaction score. Suggested improving resolution rates, optimizing staffing, and reducing wait times.
-
Customer Retention: Found a 26.54% churn rate among 7,043 customers. Recommended customer engagement strategies, workforce diversity improvements, and enhanced feedback mechanisms to boost retention.
-
Diversity & Inclusion: Identified gender disparities in promotions, job security, and performance ratings. Recommended unbiased performance evaluations, equal promotion opportunities, and retention strategies.
-
Power BI Expertise: Designed interactive dashboards for all three projects, using DAX and data visualization to extract actionable insights.
-
Data Cleaning & EDA: Ensured data integrity through thorough cleaning and exploratory analysis, leading to meaningful business recommendations.
-
Real-World Business Impact: Gained hands-on experience in analyzing operational data and deriving insights to improve efficiency, customer experience, and workplace inclusivity.
- Microsoft Excel
- Microsoft PowerBI
- Microsoft PowerPoint (design layout)