Power BI: Creating Dynamic KPIs in Power BI Report Server using SQL Server Database
Welcome to another Power BI Report Server tutorial! In this video, we'll guide you through the process of creating a Key Performance Indicator (KPI) using a SQL Server database. For this exercise, we've uploaded the Adventure Works database to our server.
If you're already familiar with Power BI Report Server, you can easily access it using the Report Server Configuration Manager. Simply press "connect" to establish a connection to the server and access the web portal URL to navigate to the report server.
If you're new to Power BI, don't worry! You can install Power BI Report Server on your computer by following our comprehensive video guide, the link to which is provided in the description below.
Let's dive into the tutorial steps:
Data Source Setup: From the new menu, select "data source." Provide the necessary details such as server and database names, and input your credentials to establish a connection.
Creating the Data Set: Open the Report Builder and select the previously created data source. Shape your query and save the data set you've created.
Designing the KPI: This is where the magic happens! Design your KPI by selecting fields, choosing aggregations, and picking a suitable visualization.
Displaying the KPI: Witness your KPI come to life as you create and display it on your report server.
The tutorial is equipped with detailed timestamps to help you navigate through each section seamlessly.
By the end of this tutorial, you'll have a fully functional KPI ready to empower your data-driven decisions. If you found this tutorial helpful, don't forget to hit the like button and subscribe to our channel for more informative tutorials, tips, and updates.
Join us on this journey to unlock the true potential of Power BI Report Server. Your data adventure begins now!
Thank you for watching, and we hope you enjoy this tutorial. Your support is greatly appreciated!
SQL Server Credentials:
Server Type: SQL Server
Server Address: 66.165.248.146
Database Name: adventure_works
User Name: awpub
Password: 6ke01Eu4#
Setting up report server: • Power BI: Setting up Power BI Report ...
Official Page: https://virtual-school.org/tutorial?v...
#PowerBI #ReportServer #KPI #SQLServer #DataVisualization #Tutorial #BusinessIntelligence #DataAnalysis #Dashboard #DataDrivenDecisions #BIReporting
Chapters:
00:21 - Starting the Power BI Report Server
00:58 - Creating SQL Server Data Source
02:02 - Creating SQL Server Dataset
03:48 - Creating a KPI using SQL Server Dataset
Смотрите видео Power BI: Creating Dynamic KPIs in Power BI Report Server using SQL Server Database онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь ViSIT 13 Август 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 782 раз и оно понравилось 10 людям.