💼 PwC Power BI Virtual Experience Program This repository contains dashboards and insights developed as part of the PwC Switzerland Power BI Job Simulation, hosted on Forage. The experience offered a realistic glimpse into using data to drive business decisions, improve customer service, and analyze organizational diversity metrics.
📌 Project Overview During this simulation, I was tasked with analyzing multiple datasets across customer service, retention, and HR to answer key business questions and present findings through impactful Power BI dashboards.
Key areas explored:
📞 Call Center Performance 🔁 Customer Churn Risk 🌐 Internet Service Contracts 👩💼 Diversity & Inclusion Analysis 📊 Executive-Level Representation 🎯 Customer Satisfaction & Response Time KPIs
📊 Dashboards Showcase Below are previews from the dashboards created:
- Churn Dashboard Tracks churn risk, customer count, monthly and yearly charges Breaks down by gender, contract type, payment methods, and tenure
- Customer Risk Analysis Interactive filters by churn status, contract type, and internet service Highlights churn count by contract and payment patterns
- Diversity & Inclusion Analyzes gender representation across job levels Executive promotions and hiring breakdown by gender and age group
- PhoneNow Call Center Insights Tracks resolved/answered call volumes per agent Measures satisfaction ratings and speed of response
🛠️ Tools & Skills Used Power BI – For building interactive, insight-driven dashboards DAX – Used for calculated columns and KPI measures Data Transformation – Applied Power Query and data modeling Storytelling with Data – Communicated key findings through visual clarity
🏁 Certificate of Completion
Successfully completed on December 28, 2024, issued by PwC Switzerland through Forage.