PWC Switzerland POWER BI VIRTUAL JOB SIMULATION





I participated in the Power BI virtual internship throughout March, where I acquired the following skills and experiences:

  • Completed the job simulation where I strengthened my Power BI skills to better understand clients and their data visualization needs.
  • Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs(Key Performance Indicators), showcasing the ability to respond to client requests with well-designed solutions.
  • Strong communication skills reflected in the concise and informative email communication with engagement partners, delivering valuable insights and actionable suggestions based on data analysis.
  • Leveraged analytical problem-solving skills to examine HR data, particularly focusing on gender-related KPIs, and identified root causes for gender balance issues at the executive management level, highlighting a commitment to data-driven decision-making.
Overall, it was an enriching experience. Throughout the internship, I had the opportunity to tackle four distinct tasks. Below, I provide a summary of each.

1. Call Center Analysis

 



Call Center Trends:
  • In this task the Call Center Manager of a telecom company had requested for an interactive dashboard that highlighted the following KPI's; Overall Customer Satisfaction, # of calls Answered and Rejected, estimated speed of answer. These metrics would help her make optimal business decisions in terms of management.

2. Customer Churn Analysis


Customer Retention:
  • In this task I was required to create a dashboard using the defined KPI's to reflect customer demographics and insights. Lastly, I had to write a concise email to the engagement partner explaining my findings  and providing necessary changes based on the dashboard created.
  • From the dashboard, I discovered that:
    1. Most customers that were at high risk of churning were subscribed to the Month-to-Month contract.
    2. Customers using the DSL internet service were also at high risk of churning.
    3. There was no correlation between the presence of a partners and rate of churning.
    4. Gender had no effect on the rate of churn by the customers.

3.Diversity & Inclusion 

   
Gender Balance in the executive suite:
  • In this task I defined KPIs related to gender balance and diversity. I was required to create visualizations to represent HR data effectively, focusing mainly on gender related KPIs. Lastly, I was to identify and discuss potential root causes for the slow progress in achieving gender balance at the executive management level.
  • From the dashboard these were my key findings:
  1. The percentage of males being hired for each role is higher than that of women.
  2. The women are most dominant in the Human Resource department.
  3. The "6-Junior Officer" job level has noticeably more # of women.
  4. The average rating of men is highest in the "Finance" department where they are high in numbers.

Comments

Popular Posts