Skip to content

Completed PwC Power BI Virtual Internship via Forage, building interactive dashboards on churn, customer service, and diversity using DAX, Power BI, and real-world business scenarios.

Notifications You must be signed in to change notification settings

abh1shek-s1ngh/pwc-power-bi-job-simulation

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 
 
 

Repository files navigation

pwc-power-bi-job-simulation

💼 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:

  1. Churn Dashboard Tracks churn risk, customer count, monthly and yearly charges Breaks down by gender, contract type, payment methods, and tenure
  2. Customer Risk Analysis Interactive filters by churn status, contract type, and internet service Highlights churn count by contract and payment patterns
  3. Diversity & Inclusion Analyzes gender representation across job levels Executive promotions and hiring breakdown by gender and age group
  4. 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. image

Dashbaords ------ image image image image image

About

Completed PwC Power BI Virtual Internship via Forage, building interactive dashboards on churn, customer service, and diversity using DAX, Power BI, and real-world business scenarios.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published