Beginners Course on Power BI with Azure DevOps (ADO)
- Description
- Curriculum
- FAQ
- Reviews
Course covers different steps to connect to your Azure DevOps Data from Power BI and create reports on top of it. Also you will see couple of extensions that will be helpful for your reporting. This course is targeted to Project Managers and Scrum masters who have very little knowledge on Power BI and want to report on Azure DevOps.
** This is not recommended for you , if you are already good at Power BI and understand the data connectivity options , as this course covers very basic information and it is mainly targeted to the audience stated above **
Key Topics Covered in the Course :
- Getting Data from Azure DevOps using Azure DevOps Connector(Boards)
- Adding Analytics Views on ADO and using that in PBI
- Using Odata Feed Connector
- Using Odata Queries
- How to Use Standard Queries Available.
- Installing the extension on ADO and downloading PBIT file
-
11.1 WelcomeVideo lesson
This is a welcome message for the course structure and information on the next steps of the course (With no Music)
-
21.2 What you need for this CourseVideo lesson
This video talks about the prerequisites required for this course.
-
31.3 Exercise FilesVideo lesson
This video shows you all the exercise files that has been used in this course. Please download the exercise files in the resource's section for this entire course.
-
42.1 Why Power BI when there are dashboards in Azure DevopsVideo lesson
This video explains you about the benefits of Power BI over Azure DevOps for reporting purposes
-
52.2 Downloading & Installing Power BI on WindowsVideo lesson
This video shows you how to download and Install the Power BI Desktop tool for Windows
-
62.3 Sign Up for Azure DevOps Template ImportVideo lesson
This video shows you the process of importing Azure DevOps Project templates on to ADO.
-
72.4 Getting Data from Azure DevOpsVideo lesson
This video shows you the different approaches for connecting the Azure DevOps data from Power BI
-
83.1 Azure DevOps Connector(Boards)Video lesson
This video shows you the steps to connect to Azure Data using the default connector available in Power BI
-
93.2 Azure DevOps Connector - Using Standard Azure DevOps ViewsVideo lesson
This Video shows you how to use the default views available within ADO onto Power BI report
-
103.3 Adding Analytic Views on ADO and using in Power BIVideo lesson
This video shows you how to create Analytic Views on Azure DevOps portal and further use that view onto Power BI report.
-
114.1 Using Odata Feed ConnectorVideo lesson
This video shows you to use the OData feed connector option for connecting Azure DevOps data onto Power BI report
-
124.2 Creating a Power BI Report with Odata Feed TablesVideo lesson
This video shows you how to make a Power BI report by using the tables that we imported using the OData feed connector.
-
135.1 Using Odata QueriesVideo lesson
This video shows you how to use the OData Queries using the blank queries option to fetch the Azure DevOps data.
-
145.2 How to Use Standard OData Queries AvailableVideo lesson
This video shows you to use the standard OData queries that are available from Microsoft and create a Power BI Report on top of that.
-
155.3 Recommended Method ( Table )Video lesson
This video shows you a table which gives you the information about which approach can be used depending on your requirement.
-
166.1 Installing the extension on ADO and downloading PBIT fileVideo lesson
This video shows you how to install the extension from marketplace on Azure DevOps and futher download the .pbit file .
-
176.2 Showing how the Query Works and Showing a Sample QueryVideo lesson
This video shows you about the details of the query part of the .pbit file that has been downloaded from Azure DevOps
-
187.1 Fetching Dynamic Organization and Project ( Parameters)Video lesson
This video shows you on how to create a dynamic template Power BI report which accepts Organization and Project as inputs .
-
197.2 Power BI Extensions in ADOVideo lesson
This video shows you to install the Power BI extension available in ADO and further create a dashboard to add a widget onto ADO for bringing the Power BI Report.
-
207.3 Color Code Logic used in the ReportVideo lesson
This video shows you about the Color Code logic DAX that has been used in the Power BI report
-
21Timeline Report for epics & features Part 1Video lesson
We shall create a sample Timeline Report for epics & features Part 1 ( Pbix file is attached in the downloadable section)
-
22Timeline Report for epics & features Part 2Video lesson
Timeline Report for epics & features Part 2
-
23Timeline Report for epics & features Part 3Video lesson

External Links May Contain Affiliate Links read more