Complete Power BI Dashboard for Call Center Performance Project - Step by Step Tutorial - Part 1

Опубликовано: 28 Сентябрь 2024
на канале: Excel Bonanza
1,454
59

In this video, we build a Power BI call center performance dashboard step by step. In this first part of the video, we construct the global view for the Power BI call call center performance dashboard where we see a global view of the call center's performance, and then on Part 2, we create a view for agent performance.

Watch Part 2 - Creating the Agent View:
   • Complete Power BI Dashboard for Call ...  

Download Project Files:
https://tinyurl.com/4pftv67t

Download Microsoft Power Toys:
https://apps.microsoft.com/detail/xp8...

Contact us for training or consultation: https://Excelbonanza.com/Contact

Watch my previous video for dashboard for Car Insurance company:    • Complete Power BI Dashboard for Car I...  

⭐Check out my Courses:
ExcelBonanza.com/Courses
🎁Use discount code YOUTUBE15 at checkout (Limited time offer!)

Time Stamps:
00:00:00 Introduction
00:02:07 Power BI Call Center Performance Dashboard - Project overview and objectives
00:07:44 Starting Power BI Call Center Performance Dashboard from scratch
00:08:12 Importing the data to Power BI for Power BI Call Center Performance Dashboard
00:24:42 Creating data model relationships for Power BI Call Center Performance Dashboard
00:36:25 Creating measures for the Power BI Call Center Performance Dashboard
00:46:21 Creating New KPI Card visual for Power BI Call Center Performance Dashboard
01:16:52 Applying Conditional formatting to Power BI Call Center Performance Dashboard
01:36:15 Creating and formatting Slicers for Month and Year using New Slicer visual in Power BI
01:43:55 Creating Donut chart for calls answered breakdown for Power BI Call Center Performance Dashboard
01:47:28 Creating AHT (Average Handling Time) vs Abandoned calls Percentage visual for Power BI Call Center Performance Dashboard - Global View
01:53:20 Creating AHT (Average Handling Time) vs Actual/Forecast Percentage visual for Power BI Call Center Performance Dashboard - Global View
01:56:22 Creating Caption visual using card visual in Power BI - Global view
02:14:51 Creating drill through capability to drillthrough a day and see the interval performance for our Power BI Call Center Performance Dashboard
02:16:04 Creating a time (intervals) table using Power query to support our time (interval) analysis in Power BI
02:25:45 Building the drillthrough page that helps us see the interval performance for a particular day/date on our Power BI Call Center Performance Dashboard
02:48:18 Creating the custom backgrounds and navigation buttons and finalizing Power BI Call Center Performance Dashboard
03:28:32 Conclusion and review of the work done


Follow us on Social Media:
Facebook:   / excelbonanza  
Twitter:   / excelbonanza  
Follow me on Linkedin:   / abdelrahman-abdou-60240150  
Instagram:   / excelbonanza1  
TikTok:   / excelbonanza  
Telegram: https://t.me/ExcelBonanza
Website: https://www.ExcelBonanza.com