Real time dashboards are widely used in stocks, call centers, currency exchange companies, airline companies, national retail chains etc. "How" is exactly what is shown in this tutorial.
There are many ways. You have import and export wizards in SSMS. You can use select * from OPENROWSET command if you prefer query. You can save excel file as text and use Bulk Insert command as well. However you must have advanced SQL or database knowledge, to use any of these methods. Databases are highly strict. In a column where Null is not allowed, any blank cell will result in error. Any space or hidden special character may result in error as well. In some cases application using the database can malfunction as well.
You need power bi service for push dataset, which not everyone has. And there are many other issues as well. Power BI users are mostly basic users, and push data does not have a proper interface. You have to use command line tools and other stuff to make it work. And at the end you get similar results.
@@virtual_school once the whole project is done when we have to open it again it is not showing the first visual representation It showing error message
Thank you a lot. Your video is handy for me. I am making the same system
Thanks for your kind words. Glad you liked it.
The waitfor delay in sql query, is '00:00:01' (it is not 00:00:00 as shown in some parts of video).
Correct
Where can we use this sql server dashboards? and how
Real time dashboards are widely used in stocks, call centers, currency exchange companies, airline companies, national retail chains etc. "How" is exactly what is shown in this tutorial.
How can i insert data provided in excel sheet into the SQL server table?
There are many ways. You have import and export wizards in SSMS. You can use select * from OPENROWSET command if you prefer query. You can save excel file as text and use Bulk Insert command as well.
However you must have advanced SQL or database knowledge, to use any of these methods. Databases are highly strict. In a column where Null is not allowed, any blank cell will result in error. Any space or hidden special character may result in error as well. In some cases application using the database can malfunction as well.
How many rows and columns are we talking about?
Using direct query is obvious method. Looking for push datasets video.
You need power bi service for push dataset, which not everyone has. And there are many other issues as well. Power BI users are mostly basic users, and push data does not have a proper interface. You have to use command line tools and other stuff to make it work. And at the end you get similar results.
It is taking too long time for visual representation
From:12:15
Could you elaborate plz. What is taking long and what is "from:12:15" ?
@@virtual_school once the whole project is done when we have to open it again it is not showing the first visual representation
It showing error message
actualy this is not real time dasboard refresh 1second refresh rate
You are right, but if you go to cost benefit and efforts involved, it is the best solution.