PWC Switzerland POWER BI VIRTUAL JOB SIMULATION
- 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.
1. Call Center Analysis
- 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
- 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:
- Most customers that were at high risk of churning were subscribed to the Month-to-Month contract.
- Customers using the DSL internet service were also at high risk of churning.
- There was no correlation between the presence of a partners and rate of churning.
- 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:
- The percentage of males being hired for each role is higher than that of women.
- The women are most dominant in the Human Resource department.
- The "6-Junior Officer" job level has noticeably more # of women.
- The average rating of men is highest in the "Finance" department where they are high in numbers.

.png)

.png)
.png)
Comments
Post a Comment