Power BI: Complete Realtime Dashboard Demo using SQL Server Database from start to end

No video

Power BI: Complete Realtime Dashboard Demo using SQL Server Database from start to end

Рет қаралды 4,510

Күн бұрын

This is a video tutorial about creating a real-time SQL Server dashboard in Power BI. Here's a summary of the video:
We'll build a demo project from scratch by creating a SQL Server database and table.
We'll insert data repeatedly into the table.
We'll create a dashboard in Power BI to display that information in real-time.
We'll connect to the SQL Server database from Power BI.
We'll create a table in the database to store sales data.
We'll write a SQL query to insert random data rows into the table.
We'll configure Power BI to connect to the database and display the data.
We'll design a real-time dashboard with charts and gauges to visualize the sales data.
#PowersBI #SQLServer #RealTimeDashboard #DataVisualization #Tutorial #SQL #Database #SalesData #DashboardDesign #DataAnalysis #Insights

Пікірлер: 16

@quiz1112 4 ай бұрын

Thank you a lot. Your video is handy for me. I am making the same system

@virtual_school 4 ай бұрын

Thanks for your kind words. Glad you liked it.

@virtual_school 5 ай бұрын

The waitfor delay in sql query, is '00:00:01' (it is not 00:00:00 as shown in some parts of video).

@sourabhrajora7225 Ай бұрын

Correct

@sourabhrajora7225 Ай бұрын

Using direct query is obvious method. Looking for push datasets video.

@virtual_school Ай бұрын

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.

@srikanthkatla308 5 ай бұрын

Where can we use this sql server dashboards? and how

@virtual_school 5 ай бұрын

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.

@shreyoseesen9395 2 ай бұрын

How can i insert data provided in excel sheet into the SQL server table?

@virtual_school 2 ай бұрын

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.

@virtual_school 2 ай бұрын

How many rows and columns are we talking about?

@SupundiWijekoon-f6c Ай бұрын

actualy this is not real time dasboard refresh 1second refresh rate

@virtual_school Ай бұрын

You are right, but if you go to cost benefit and efforts involved, it is the best solution.

@jivithaattuluri6738 2 ай бұрын

It is taking too long time for visual representation From:12:15

@virtual_school 2 ай бұрын

Could you elaborate plz. What is taking long and what is "from:12:15" ?

@jivithaattuluri6738 2 ай бұрын

@@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