Power BI: Creating a Key Performance Indicator (KPI) using SQL Server Database in BI Report Server
DescriptionThis 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.
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