Reporting Made Simple!
The aim of this blog is to simplify the process of generating reports. Previously, to generate any reports in DevOps you had to write queries to generate the required data for the reports and then create a report. But now there’s an easier way to generate reports without writing any queries and that is by using Microsoft Power BI.
MS Power BI allows you to import data from DevOps and add relationships to your data tables. It performs simple calculations on the data and also provides measures to write custom calculations.
Prerequisites
- Generate Analytic Views for the Data (Features, Requirements, Tasks, Bugs) in Azure DevOps
- MS Power BI Desktop
1. Open MS Power BI Desktop
2. Sign in to MS Power BI Desktop.
Upon first-time access, you’re required to sign in and have your credentials authenticated. MS Power BI Desktop saves your credentials so you only have to do this once.
Choose windows or Personal Access Token to sign in.
Sign in using your organizational account details and click connect upon verification of your credentials.
3. Get Data from the Azure DevOps
Select Get Data, followed by Web then it prompts you to Get Data in pop-up.
Select Online Services, Azure DevOps (Boards Only) or Azure DevOps Server (Boards Only) and click Connect.
4. Specify parameters to connect to your data
Give the url of your server in the Collection Url and the project name of the data you want in the Team Project.
Click OK to connect to data.
5. Load Data
Select the analytic views you want to get the data from and click on Load to load the data.
It loads the selected data and then shows the data in the Fields pane.
6. Create MS Power BI Reports
Create relationships between the tables to generate any reports. Finally generate reports according to your business needs and business data. You can select any type of chart and just add the values (i.e. columns in the data table you want to create reports for) to generate charts.
The Total Completed Work and Total Original Estimate report shows a pie chart for the time taken to complete the task as opposed to the original estimate it would take to complete work.
The Percentage of feature completed by tasks report shows a pie chart for the amount of the feature completed by the number of tasks closed in a particular feature.
The State and Features slicers in the report help to select the state and the feature and the reports (Pie Charts) below show the data according to the selection.
The Min.of EffortHours, Original Estimate and Completed Work by Title report shows a clustered column chart for time estimated to complete a feature, time estimated to complete the tasks in that particular feature and time taken to complete the tasks in that feature.
The Percentage of time exceeded or saved by no. of hours chart shows a multi-row card for time taken to complete the tasks, time estimated to complete the tasks in that particular feature and the percentage of feature completed by the time estimated to complete the tasks.
The Completed Work and Original Estimate by Task shows a stacked column chart for the time taken to complete the tasks and the time estimated to complete the tasks for tasks in all the features.
The Completed Tasks and Unfinished tasks by Feature shows a clustered column chart for the number of tasks completed and incomplete for a feature based on the state of the task.
Contact Us
At Dataworks, we have the experience and expertise to help you to use Microsoft Power BI to its full capability allowing you get the most from your data and reports. If you would like to find out more Contact Us today or call us on 051 878 555.
DATAWORKS – Driving Digital Transformation in the worlds’ Leading Life Science Companies
for over 25 Years