PwC Switzerland Power BI in Data Analytics Virtual Case Experience helps build foundation in data analysis and visualization with Power Bi. Power BI dashboards showcases insights on Call Centre Trends, Customer Retention, and Diversity & Inclusion to drive business impact.
♦ Details for task
Tell us, what do you hope to learn during this experience with us?
I hope to understand how a company uses power BI to help making business decision, what kind of visualization is needed and to practice using my power BI skills in a way that is helpful.
- Advanced PowerBI skills, including data modeling and visualization.
- Data integration and transformation within PowerBI.
- Client-centric problem solving and effective communication.
- Strong teamwork and collaboration skills.
- Professional growth in a dynamic environment.
♦ Details for task
Create a dashboard in Power BI that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset. Get creative!
- Create a dashboard in Power BI for visualizing relevant KPIs and metrics in the dataset provided.
- Utilize the resources provided, including podcasts and articles, to enhance your understanding of data visualization and upskilling.
- Respond to the client's request by providing a well-designed Power BI dashboard reflecting the requested KPIs.
A few weeks after presenting your dashboard to the management, the Retention Manager from the telecom reaches out to you directly. He was impressed by your work and asked if you can put together a dashboard about customer retention.
♦ Details for task
Create a dashboard in Power BI that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset. Get creative!
- Define key performance indicators (KPIs) related to customer retention.
- Create a dashboard that visualizes customer demographics and insights.
- Create a dashboard using the defined KPIs to reflect customer demographics and insights.
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.
♦ Details for task
Create a dashboard in Power BI that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset. Get creative!
-
Define relevant KPIs in hiring, promotion, performance and turnover, and create a visualisation
-
Calculating the following measures could help to define proper KPIs:
-
#of men
-
#of women
-
#of leavers
-
% employees promoted (FY21)
-
% of women promoted
-
% of hires men
-
% of hires women
-
% turnover
-
Average performance rating: men
-
Average Performance rating: women
Forage - PwC Switzerland Power BI in Data Analytics Virtual Case Experience