Improving Data Insights with Time Intelligence Integrating a date table in Power BI is essential for generating reports that offer a thorough analysis of work items, pipelines, and testing in Azure DevOps (ADO). A date dimension is a table featuring… Read More »Integrating a Date Table for Time Intelligence for Azure DevOps Reporting
Setup Reporting Filtering by Tag Creating a report in Power BI using work items from Azure DevOps (ADO) offers a powerful way to visualize and analyze project data. One particularly effective feature is the ability to filter work items by… Read More »Filter Work Items by Tags
Why a Star Schema Data Model Using a star schema data model in your Power BI report to link iterations and area paths to the work items fact table offers several benefits. This schema enhances data integrity by ensuring consistency… Read More »Optimize your ADO Reports with a Star Schema Data Model in Power BI
Your ADO organization probably generates a high number of work items and Power BI is an excellent reporting tool to help visual and track the work your team is assigned for an iteration. When creating Power BI reports using work… Read More »Search by Work Item ID in the Power BI Report
Tags are useful for categorizing and filtering work items in Azure DevOps. However, when you want to create Power BI reports based on the tags, you may encounter some challenges. For example, how can you count the number of work… Read More »Separate ADO Work Item Tags into a Table for Power BI Reporting
Adding Long Text and HTML Fields to Analytics Views and ODATA Queries in Power B To add the HTML and long text fields to an existing Analytic View or ODATA query in the Power BI report, you need to add… Read More »Add a Work Item’s Long Text Field Data to an Analytics View for the Power BI Report
Quickly View the Work Item’s Details from a Power BI Report Opening the Azure DevOps Work Item to view the details from a Power BI report is one of the most useful reporting. The users want to see the data… Read More »Add URL Link to Open the Work Item in ADO from a Power BI Report
Modifying the Analytics View’s Data to Report Visual Friendly Making the default data types from an Analytics View graph friendly means changing to a more readable format. The default data types for the fields in the analytics view are appropriate.… Read More »Transforming the Analytics View’s Data
Steps to Make the Area and Iteration Path Easier to View In some Azure DevOps projects we see long string values for Iteration Path due to nesting of iterations under common parent iteration. This long string value is not friendly… Read More »Shorten the ADO Area or Iteration Path for Easier Graph Readability
Create a Single Dataset for Multiple Team Projects ADO users commonly write work item queries to construct dashboards or export data to Excel for reporting. Converting these queries into analytic views as the primary source of reporting on work items… Read More »Create Enterprise Azure DevOps Reports with Analytics Views