🎬Power BI: Creating a Key Performance Indicator (KPI) using SQL Server Database in BI Report Server

This video is a tutorial on how to create a KPI (Key Performance Indicator) using SQL Server Database. The video starts with an introduction to KPI and its importance in evaluating progress towards measurable goals. Then the video demonstrates the steps to allow SQL server to use TCP port and IP address, which enables access to the server over a network. Next, the video shows how to create a database, assign network authentication using a username and password, and connect to the SQL server using the network authentication. The video also demonstrates how to create a table, add appropriate permissions using Windows Authentication, and assign roles to save the table. Finally, the video shows how to add data to the table using SQL queries. As a trainer, you can use this video to teach your learners how to create a KPI in SQL Server Database, how to allow SQL server to use TCP port and IP address, how to create a database, how to assign network authentication, how to create a table and how to add data to the table using SQL queries. https://virtual-school.org/tutorial?v=soXmHxGPa1Y Chapters: 00:39 - Enable TCP, IP Access for SQL Server 01:26 - Creating SQL Server Authentication 02:49 - Connecting to the SQL Server using IP Address 03:52 - Creating a New Table using Network Authentication 06:42 - Creating a Data Source to Connect to the SQL Server 08:21 - Creating a Data Set using the SQL Server Data Source 10:05 - Creating a KPI from Data Set in Report Server #SQLServer #KPI #NetworkAuthentication #DatabaseManagement #ReportServer #TCP/IP #IPaddress #SQLQuery #DataManagement