Connect HomeMarketplaceComponentsPower BI Jobs and Queues Dashboards

Power BI Jobs and Queues Dashboards

Dashboard

Dashboard

Updated: October 21st, 2020

Published: April 21st, 2019

Downloads: 679

Tags: data

Community Support

Power BI Jobs and Queues Dashboards

Dashboard

Summary: 

Interactive Power BI dashboards on the topic of jobs and queues processes, using data from the Orchestrator SQL Server database

The package includes 2 Power BI Dashboards, one for jobs and two for queues, each of which contains multiple views:

Queues:
  • Queues Overview: executive view of the transactions performed during the selected time frame, by final status, for the whole period and over time
  • Active Queues: a summary of the queue items currently in process and pending (in queue), broken down by queue name, SLA status and priority
  • Queues Analytics 1&2 identifies key metrics for the transactions executed during the chosen time frame, centered around final status, SLA status, duration processing and time spent waiting in queue
  • ROI visualizations
Jobs:
  • Jobs Overview: executive view of the jobs performed during the selected time frame, by final status, for the whole period and over time. Also provides the robot utilization in hours worked / robot / day
  • Active Jobs: a summary of the jobs currently in process and pending. Currently running jobs are listed.
  • Analytics Jobs 1&2 identifies key metrics for the jobs executed during the chosen time frame, centered around final status, duration, duration in pending and volumes (number of times) processed
  • ROI visualizations

Details

Benefits

The Queues Dashboard: Provides an overview of the queue activity in the selected time frame as well as over time. Allows the users to identify queues that need more resources, queues for which the error rates are high.
The Jobs Dashboard: Provides an overview of the job activity in the selected time frame as well as over time. Allows the users to identify processes for which the error rates are high, evaluate the robot utilization numbers and other jobs-related KPIs.

Compatibility

2017.1 and up

Dependencies

POwer BI Desktop
Orchestrator 2017.1 and up
Orchestrator SQL Server rights (read data rights, rights to create views)
Orchestrator SQL Server URL and authentication information
The Power BI environment must be able to access the SQL Server environment



Resources

- Power_BI_Dashboards_Documentation_1.pdf

Licensing

By clicking download you agree to the following license.