Real time Monitoring with Power BI and SQL

This video tutorial demonstrates how to set up a real-time call center monitoring dashboard using Power BI and SQL Server.

The data for the dashboard comes from call logs stored in a SQL Server database. The call logs include information such as the date and time of the call, the origin and destination of the call, the call duration, and the call rating.

The dashboard uses a variety of visuals to display the call center data, including maps, flow maps, cards, and gauges. The maps show the location of the call destinations and the origin locations are indicated by color. The flow maps show the origin and destination locations of the calls. The cards display the average call duration and the average call rating. The gauges can also be used to display the average call duration and average call rating.

In order to keep the data in the dashboard up-to-date, a script is used on a web server to turn on real-time connectivity for a few seconds. A hyperlink in the dashboard is used to trigger the script.

Here are the key steps involved in creating the dashboard:

- Create a table in the SQL Server database to store the call center logs.
- Create a program to bring data of current calls from various regional offices into the database.
- Create a table in Power BI to store the URL that will be used to trigger the script on the web server.
- Create a map chart to monitor calls made to various locations.
- Create a flow map visual to display calls from and to various locations.
- Add cards to the dashboard to display the average call duration and the average call rating.
- Set up page refresh to update the data in the dashboard every two seconds.

#PowerBI
#SQLServer
#CallCenterMonitoring
#RealTimeDashboard
#DataVisualization
#Maps
#FlowMaps
#Cards
#Gauges
#WebServerScript