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

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 (and maybe part 3), we will create a view for agent performance.

Download Example Files:

Download Microsoft Power Toys:

⭐Check out my 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:

[kholoudhammad]

Great job as usual AbdelRahman … very comprehensive 👍🏻👍🏻

[EmanRagab-oxlb]

Really helpful abdelrahman thanks for sharing