Power BI: Displaying Live System Performance using Power BI, SQL and Python
DescriptionThe video explains a step-by-step guide on how to display system performance information in real-time using Python, Microsoft SQL Server, and Power BI Desktop. The narrator explains that this exercise will help learners understand Python, SQL, and Power BI Desktop and how to connect the three major data science applications.
The video begins by explaining that Python will be used to read system performance information, which will then be inserted into Microsoft SQL Server Database. Afterward, Microsoft Power BI Desktop will be used to display the information on a dashboard in real-time, just like in Windows Task Manager.
The video then shows how to create a new database in Microsoft SQL Server and name it "system information." The narrator explains that they will create a new table in this database named "performance" and shows how to add various columns to store CPU usage information, memory usage information, CPU interrupts, CPU calls, memory used, memory free, bytes sent over the Internet, bytes received from the Internet, and disk usage information.
After creating the table, the video shows that it is currently blank, and no data has been entered yet. The next chapter will explain how to insert data into the table using Python.
The video then goes on to explain how to import Python system and process utilities, the time library, and the ODBC library for Python. After importing the libraries, the narrator shows how to create a connection to the SQL Server database using the ODBC Python library. They also explain how to find out the server name from the SQL Server Management Studio and enter it in the Python script.
Next, the video shows how to create a SQL cursor using the connection defined above. The narrator then creates an infinite loop using Python's system utility and explains how to gather system performance information using the Python script. They also explain how to insert the gathered information into the Microsoft SQL Server database using the SQL cursor.
Overall, the video provides a detailed explanation of how to display system performance information in real-time using Python, Microsoft SQL Server, and Power BI Desktop. It covers all the necessary steps from creating a new database to inserting data into the database using Python.
00:55 - Designing SQL Database
04:22 - Using Python to Get System Performance
14:33 - Testing the Application
15:14 - Connecting Power BI to SQL Server
25:49 - Creating Measures for Latest Values
18:20 - Creating Power BI Live Dashboard
24:12 - Testing the Final Results
#Python #SQLServer #PowerBI #RealTimeDashboard #SystemPerformance #DataScience #ODBC #DatabaseManagement #DataVisualization #Microsoft #WindowsTaskManager #PerformanceMonitoring
Microsoft SQL Server,
power B I desktop,
windows task manager,
SQL server management Studio,
never ending loop