Beginners Course on Power BI with Azure DevOps (ADO)

Name: Beginners Course on Power BI with Azure DevOps (ADO)
Rating: 3.9 (327 reviews)

Basic Course which shows you step by step approach to connect your Azure DevOps data from Power BI

Created bySantosh Pothnak

Last updated 1/2024

English

What you'll learn

The Students will learn the basics on how to fetch the data from Azure Devops using Power BI Desktop Tool.
Power BI with Azure DevOps
Sample Timeline View Report using Gantt Chart

Course content

9 sections • 25 lectures • 1h 55m total length

1.1 Welcome1:29
This is a welcome message for the course structure and information on the next steps of the course (With no Music)
1.2 What you need for this Course2:39
This video talks about the prerequisites required for this course.
1.3 Exercise Files1:10
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.

2.1 Why Power BI when there are dashboards in Azure Devops2:10
This video explains you about the benefits of Power BI over Azure DevOps for reporting purposes
2.2 Downloading & Installing Power BI on Windows3:24
This video shows you how to download and Install the Power BI Desktop tool for Windows
2.3 Sign Up for Azure DevOps Template Import4:51
This video shows you the process of importing Azure DevOps Project templates on to ADO.
2.4 Getting Data from Azure DevOps1:53
This video shows you the different approaches for connecting the Azure DevOps data from Power BI

3.1 Azure DevOps Connector(Boards)3:13
This video shows you the steps to connect to Azure Data using the default connector available in Power BI
3.2 Azure DevOps Connector - Using Standard Azure DevOps Views3:22
This Video shows you how to use the default views available within ADO onto Power BI report
3.3 Adding Analytic Views on ADO and using in Power BI5:28
This video shows you how to create Analytic Views on Azure DevOps portal and further use that view onto Power BI report.

5.1 Using Odata Queries5:01
This video shows you how to use the OData Queries using the blank queries option to fetch the Azure DevOps data.
5.2 How to Use Standard OData Queries Available4:50
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.
5.3 Recommended Method ( Table )2:02
This video shows you a table which gives you the information about which approach can be used depending on your requirement.

7.1 Fetching Dynamic Organization and Project ( Parameters)6:46
This video shows you on how to create a dynamic template Power BI report which accepts Organization and Project as inputs .
7.2 Power BI Extensions in ADO2:26
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.
7.3 Color Code Logic used in the Report1:44
This video shows you about the Color Code logic DAX that has been used in the Power BI report

Requirements

Basics of Azure Devops
Basics of Power BI

Description

Unlock the potential of Power BI for Azure DevOps reporting with our specialized course. Designed primarily for Project Managers and Scrum Masters with limited Power BI experience, this course guides you through the essential steps of connecting to Azure DevOps data and creating insightful reports.

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

We delve into advanced data connectivity options, including the use of OData Feed Connector and the application of OData Queries, simplifying complex data integration processes. Additionally, you'll discover the convenience of using standard queries, a valuable skill for efficient report generation.

The course also covers the installation of essential extensions on Azure DevOps and the process of downloading PBIT files, ensuring a comprehensive understanding of the tools at your disposal.

Note: This course is tailored for beginners in Power BI, focusing on foundational concepts of Azure DevOps data reporting. If you're already proficient in Power BI and familiar with data connectivity options, this course might cover familiar territory.

By the end of this course, you will have a strong foundation in leveraging Power BI for Azure DevOps, empowering you to make data-driven decisions in your projects.

Who this course is for:

Employees or Project Managers who work on Azure Devops to Manage there projects.
IT Professionals , IT Managers , Analysts , Software Professionals , Software Managers, Project Managers, Scrum Masters , Agile Method Users

Beginners Course on Power BI with Azure DevOps (ADO)

What you'll learn

Explore related topics

Course content

Introduction3 lectures • 5min

Getting Started4 lectures • 12min

Using Azure DevOps Connector3 lectures • 12min

Using OData Feed Connector2 lectures • 7min

Using OData Queries (Blank Query Option)3 lectures • 12min

Using Azure DevOps Extension (Downloading .pbit file)2 lectures • 6min

Bonus Videos3 lectures • 11min

Sample Timeline Report for Epics & Features3 lectures • 49min

Thank You2 lectures • 2min

Requirements

Description

Who this course is for: