Power BI Dashboard Template for Time in Status App Data

Open

Let's take a look at how to use it.

1. First, select the task scope in the Time in Status app, save the preset, and generate the JSON Data Feed Link. Learn more.

2. Download the dashboard template and open it in Power BI.

3. Add your Data Feed using the Get Data option in the upper right corner.

Open

4. Click Apply and wait for the Data Feed to connect as a data source to the template.

5. Remove the default data source that was originally attached to the dashboard to avoid confusion between data.

6. The gadgets will disappear, but their settings will remain. Next, look at each chart and how to reconfigure them for your data.

Issue Count by Assignee

The Issue Count by Assignee chart visually represents the percentage of tasks assigned to each team member over the last 30 days. This chart is valuable for understanding workload distribution and identifying potential imbalances within your team.

Average Time In Progress and Count of Issues by Issue Type

The chart provides a comprehensive view of how long issues are spent in the "In Progress" status and the number of issues for each type. This dual-metric approach offers valuable insights into your workflow's efficiency and the distribution of different issue types.

Workflow Funnel

A visual representation shows the time distribution across all the statuses in which tasks were performed. This funnel provides a clear overview of how tasks progress through your workflow, helping you identify bottlenecks and optimize your processes.

Allocation of Story Points between Assignees

The chart visually represents how story points are distributed among team members. This chart is valuable for understanding workload distribution, identifying potential imbalances, and ensuring tasks are allocated fairly and efficiently.

General Table of Time in Status

The General Table of Time in Status provides a comprehensive overview of how much time tasks spend in each status within your workflow. This table is an essential tool for understanding the efficiency of your processes, identifying bottlenecks, and making data-driven decisions to optimize your workflow.

Cumulative Flow Diagram

The Cumulative Flow Diagram (CFD) is a powerful visual tool that shows the progress of work items through different stages of your workflow over time. It helps you understand the flow of tasks, identify bottlenecks, and monitor the overall health of your project.

Sum of Story Points and Average Time In Progress by Assignee and Issue Type

The chart provides a comprehensive view of both the workload distribution and the efficiency of task completion. This dual-metric approach helps you understand how story points are allocated among team members and how long tasks are spent in the "In Progress" status for different issue types.