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.
The waitfor delay in sql query, is ‘00:00:01‘ (it is not 00:00:00 as shown in some parts of video).
#PowersBI #SQLServer #RealTimeDashboard #DataVisualization #Tutorial #SQL #Database #SalesData #DashboardDesign #DataAnalysis #Insights