POWER BI VIRTUAL INTERNSHIP IN FORAGE
Completed a job simulation where I strengthened my PowerBI skills to understand clients and their data visualization needs better. Demonstrated expertise in data visualization through the creation of Power BI dashboards that effectively conveyed KPIs, 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
I have completed four tasks, and I will be showcasing the two primary ones where I have created interactive dashboards for two critical tasks, one focusing on customer retention and the other on diversity and inclusion, demonstrating my proficiency in data visualization and analytics to address essential business challenges
1.CUSTOMER RETENTION DASHBOARD
Requirements:
1.Customers in the telecom industry are hard-earned: we don’t want to lose them
2.The retention department is here to get customers back in case of termination
3.Currently, we get in touch after they have terminated the contract, but this is reactionary: it would be better to know in advance who is at risk
4.We have done customer analysis with Excel: it has always ended in a dead-end
5.We would like to know more about our customers: visualised clearly so that it’s self-explanatory for our management
6.Define proper KPIs and Create a dashboard for the retention manager reflecting the KPIs.
2.DIVERSITY AND INCLUSION DASHBOARD
Requirements:
Human Resources at our telecom client is highly into diversity and inclusion. They’ve been working hard to improve gender balance at the executive management level, but they’re not seeing any progress. They’re reaching out to us for help.At PwC Switzerland we are often approached by clients seeking support with diversity and inclusion. Companies need a workforce of diverse talents and backgrounds to succeed in an increasingly complex and heterogeneous world. To us, diversity and inclusion are business imperatives, not just nice-to-haves. We aim for all of our teams to feel welcome and appreciated. But actually achieving this and unlocking its potential involves a whole set of practical challenges.1.Define relevant KPIs in hiring, promotion, performance and turnover, and create a visualisation
2.Write what you think some root causes of their slow progress might be
