Hello # Connections 🖐

#Open to work # Urgent

I'm here with the #project and excited to share my experience with you all

Project Name: Call Center Data Analysis 📞

Tools Used: Excel, ETL( extract, transform and load), Power Bi, Power view, Power Pivot

I'm thrilled to announce the completion of the project "Call Center Data Analysis"

Steps Covered 🎯

✅ Connecting dataset with excel #Power Query (CSV files)

✅ Data cleaning and transforming using #ETL process :

➡️ Analyzing column quality for missing, blank and many more

➡️ Column splitting

➡️ Extracting day/month/hour from data column

➡️ Value replacing

➡️ Creating custom and conditional column

➡️ Sorting

✅ Calculated table for calendar date

✅ Calculated measure were created using #DAX

✅ Utilized #PowerPivot for summarizing data

✅ Explored #PowerView for #Visualizing the data graphically

Report in view 👀

➡️ Total calls: 32.94K 📞

➡️ Total hours on call: 13.75K 👓

➡️ Total call minutes: 824.3K 📱

➡️ Avg call time: 25.02 sec 👀

➡️ Response time: 62.61K 📞

Upon reviewing the dashboard

Dashboard: Home:

🎯 Total call by day (column chart)- Display column chart that shows total no. of calls each day over specified time period.

🎯 Total calls by state (filled map chart)- Create filled map chart that visualizes that no. of calls, received from different state.

🎯 Total reason for calls (tree map)- Implement tree map chart to display top reason for calls. Each box in tree represent call reason.

🎯 Total calls by channel (donut chart)- Create donut chart to showcase the distribution of calls by different communication.

🎯 Total calls by sentiment (column chart)- Utilize a column chart to illustrate distribution of calls by sentiment (Ex: Positive, Negative, Neutral).

🎯 Total calls by call center (bar chart)- Create a bar chart that present total no. of calls handled by each call center or department.

Dashboard: Grid:

🎯 Table- Create a grid dashboard displaying a table of all details in Power Bi. This should allow user to export grid for various filter applied.

🎯 Card- Create card view dashboard and displayed a call with no score and created another one core that displayed the call with a score.

🎯 Slicer new card- With the help of slicer new card displayed total no. of score that how may user as got.

With initiative visuals and interactive features, our team can monitor key performance metrics, track customer interactions and enhance overall efficiency.

Dataset link 🎯:

Your feedback would help me to enhance my analytical skill do review and comment here Follow me Thank you