Тёмный

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

ViSIT
Подписаться 4,3 тыс.
Просмотров 5 тыс.
50% 1

Опубликовано:

 

29 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 26   
@virtual_school
@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
@othellovancalbert1541 Год назад
I was bored and this gave me a good workout. Thanks! Everything worked! Good Job!
@romzen
@romzen Год назад
I love how comprehensive these are. Good stuff! Thank you so much!
@virtual_school
@virtual_school Год назад
Thanks a lot for your kind words.
@harshalmahajan6470
@harshalmahajan6470 Год назад
Nice Tutorial ...Keep the good work going
@fernandoaguilar6892
@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
@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.
@fantasy-371
@fantasy-371 8 дней назад
Python code is not working please help me out
@othellovancalbert1541
@othellovancalbert1541 Год назад
I Just subscribed!!! How or where to download the call center live monitoring simulation.xlsx? I would love to follow...!!!
@virtual_school
@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
@othellovancalbert1541 Год назад
@@virtual_school Wow! Nice! Okay, thanks! I will continue and see that I can generate the same random result. Thanks again!
@virtual_school
@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
@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
@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?
@gopichand5717
@gopichand5717 Год назад
Awesome content ❤
@PiyushDhondiyal
@PiyushDhondiyal 7 месяцев назад
I am not able to connect mysql in directy query mode, kindly help
@virtual_school
@virtual_school 7 месяцев назад
mySQL is not supported. Use SQL Server instead.
@virtual_school
@virtual_school 7 месяцев назад
There are workarounds, but I would suggest to go for SQL server which is officially supported and easy to setup.
@PiyushDhondiyal
@PiyushDhondiyal 7 месяцев назад
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
@virtual_school 7 месяцев назад
Thanks. I will look into that.
@sambhatti7753
@sambhatti7753 Год назад
Y kia bana diy ho
@sambhatti7753
@sambhatti7753 Год назад
Bawal chij h
@virtual_school
@virtual_school Год назад
🙏
Далее
MAGIC TIME ​⁠@Whoispelagheya
00:28
Просмотров 22 млн
Chat GPT with Microsoft Power BI | @PavanLalwani
11:25
Creating custom visuals in Power BI with DAX
35:04
Просмотров 27 тыс.