Power BI: Realtime Call Center Performance Simulation using Python, SQL and Power BI

The video is a tutorial on how to simulate real-time performance monitoring of a call center using Python, Microsoft SQL Server, and Power BI. The video starts by explaining that the simulation will generate random calls from customers and store the call center information in a Microsoft SQL server database for performance monitoring. The speaker then explains that they will fill the static information in the database using the insert command and connect Python to the SQL server for automatic data entry.

The video then shows how to generate random calls and create a never-ending loop to generate random information, such as location ID, client ID, issue ID, CSR ID, response time, call time, complaint status ID, and call rating. The speaker then prints these variables in the console window to test the code and confirms that the loop is generating random calls every second.

The next step is to create a database for the call center's real-time data. The speaker explains that they will create a table to record the random generated calls data, a table to store locations, a table for client companies with their address and phone numbers, a table for customer service representatives, and a table to store the status of the complaint. The static tables are filled using the insert command, and the speaker shows how to use simple formulas in Microsoft Excel to construct insert commands from spreadsheet cells.

To connect Power BI to the SQL server, the video explains that the pyODBC library is imported, a pyODBC connection is created, SQL Server is chosen as the pyODBC driver, the name of the SQL server is provided, and the database name is chosen. The video shows how to create a cursor based on the ODBC connection, and how to fix some errors in the Python code related to the connection string.

Chapters:
01:51 - Random Customers Calls Generation is Python
05:38 - Creating Performance Indicators Database in SQL Server
07:09 - Filling Database with Static Information
08:21 - Connecting Python to SQL Server
13:01 - Changing the Odds
14:40 - Connecting Power BI to SQL Server
15:50 - Creating a Relational Data Model in Power BI
16:55 - Creating a Power BI Dashboard
24:15 - Testing the Simulation and Power BI Dashboard

#Python, #SQLServer, #PowerBI, #RealTimeMonitoring, #CallCenter, #PerformanceMonitoring, #DataVisualization, #realtimedashboard , #realtimedata, #realtime, #livedata

[romzen]

I love how comprehensive these are. Good stuff! Thank you so much!

[harshalmahajan]

Nice Tutorial ...Keep the good work going

[fernandoaguilar]

Thank you very much, both videos that you have published in real time are spectacular.

How do you share this?

It seems to me that it cannot be shared in a public link, with the real time effect.

It seems to me that you can't in an Iframe either

The only way to share it is with the source file?

How can I present it that is on a screen in a room?

Could you share reading mode?

Sorry for so many questions, what I need is to share that real time with people who can't edit the dashboard or the data

Thank you so much

[othellovancalbert]

I Just subscribed!!! How or where to download the call center live monitoring simulation.xlsx? I would love to follow...!!!

[ykogizu]

I am not able to connect mysql in directy query mode, kindly help