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

[@virtual_school]

Link to the Excel File: docs.google.com/spreadsheets/d/1tTRfVz-g99um2MUN31U-QQuUCj4dwL4v/edit?usp=share_link&ouid=110287700425339553017&rtpof=true&sd=true

[@othellovancalbert1541]

I was bored and this gave me a good workout. Thanks! Everything worked! Good Job!

[@jamesm.sumojr8486]

Your Video hub is of knowledge and it take my experience to another level.

[@virtual_school]

Thanks for your kind words 🙏

[@romzen]

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

[@virtual_school]

Thanks a lot for your kind words.

[@harshalmahajan6470]

Nice Tutorial ...Keep the good work going

[@gopichand5717]

Awesome content ❤

[@othellovancalbert1541]

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

[@virtual_school]

There is no xlsx file. The data is randomly generated in Python and stored in SQL Server Database, from where it is directly connected to the Power BI Desktop Application using Direct Query. XLSX does not support realtime connection.

[@othellovancalbert1541]

@@virtual_school Wow! Nice! Okay, thanks! I will continue and see that I can generate the same random result. Thanks again!

[@virtual_school]

You can also generate random data using SQL only, we have those videos as well. If you dont want to use python, you can only use SQL query to do the same.

[@othellovancalbert1541]

@@virtual_school Mmm...! That's good to know! I use Python more frequently but will look into SQL only via videos as well. Thanks a lot!

[@othellovancalbert1541]

@@virtual_school Hi! I was successful in generating random data. However, after loading data to PBI, the 'location' and all others had no data. I noticed from the video a 'call center live monitoring simulation.xlsx file. How was that generated?

[@fernandoaguilar6892]

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

[@virtual_school]

If your database is online, you can share the file with anyone which will be updated in real time just as shown in the example. You can share file with any number of people and everyone's file will get updated in real time (if your server allows that much traffic). Second option is power bi server, but that is not going to allow real time updation.

[@PiyushDhondiyal]

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

[@virtual_school]

mySQL is not supported. Use SQL Server instead.

[@virtual_school]

There are workarounds, but I would suggest to go for SQL server which is officially supported and easy to setup.

[@PiyushDhondiyal]

Thank you so much for the reply and for this wonderful project. I did it using SQL server only but could you please guide the same for MYSQL also, How to connect MYSQL in direct Query Mode

[@virtual_school]

Thanks. I will look into that.

[@productreviews-q7p]

Python code is not working please help me out

[@sambhatti7753]

Y kia bana diy ho

[@sambhatti7753]

Bawal chij h

[@virtual_school]

🙏