Overview
A repository containing solutions to tasks and challenges from various Forage virtual internships, demonstrating proficiency in Power BI, data analysis, modeling, and visualization.
Forage
Forage is an online platform that offers free, open-access virtual work experience programs. These programs are designed to help students and early career professionals develop the skills and knowledge they need to succeed in today's competitive job market.
Task 1: Call Center Trends
Create a dashboard in Power BI that reflects all relevant Key Performance Indicators (KPIs) and metrics in the dataset of a Call Center
- Overall customer satisfaction
- Overall calls answered/abandoned
- Calls by time
- Average speed of answer
- Agent’s performance quadrant -> average handle time (talk duration) vs calls answered
Task 2: Telecom Churn and Retention Dashboard
- Define proper key performance indicators (KPIs) related to customer retention.
- Create a dashboard that visualizes customer demographics and insights.
- Explain the findings, and include suggestions as to what needs to be changed.
Task 3: Diversity & Inclusion
- Define key performance indicators (KPIs) related to gender balance and diversity.
- Create visualizations to represent HR data.
- Identify and discuss potential root causes for the slow progress in achieving gender balance at the executive management level.