We were founded in 2005 in a tiny apartment in Bucharest, Romania as DeskOver.

Fittingly, it was a customer who, in 2012, first saw the immense possibilities for us in the fledgling RPA market. Our desktop automation product launched in 2013. In 2015, we introduced our enterprise platform along with our new name.

Today, UiPath is the fastest-growing enterprise software company in history with scores of offices, thousands of employees, partnerships with the world’s best consulting and BPO firms, a 500,000-strong developer community, and 5MM+ robots at work in over 5,000 global enterprises.

Our mission is to deliver the leading Robotic Process Automation platform to our clients for an automation first mindset.

We build software robots that automate repetitive processes. Our software robots take on the tedious, mind-numbing work and free people to do the more stimulating, creative work worth doing.

But no matter how much we’ve grown, one thing hasn’t changed. We’re still building a company we love to work for

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

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

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

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

Director Process Intelligence

Visual Basic

This is fantastic. I have one question though: in the ROI spreadsheet, there are 2 columns with integer values: timeValueMin and itemCost.timeValueMin appears to be the amount of minutes (of manual effort) that was saved by the RPA, per job/queue item.itemCost - I can't find any reference in the documentation or the Power BI Dashboards for this field, and changing it to different values doesn't seem to impact any of the charts. Is this developer time (min) or process time, or something else?

Does this work when Orchestrator is sending Robot Logs not to SQL, but to another destination such as Elastic or CosmosDB? From the type of data in screenshots, seems it does because Orchestrator is likely to store this in SQL in any case, but thought I'd confirm this.

We are currently running Orchestrator using Azure SQL. I assume these dashboards can’t utilise DirectQuery and need to use Import which requires an on premise gateway? Thanks.

We are on v2018.4.3 and starting on testing this, is there a different SQL scripts to create the Views.

Thank you for sharing this solution, it is always good to have custom reports for better insights.In dependencies, it says Power Bi Desktop, does it mean I need to take license of&nbsp;power BI &amp; install it?I will appreciate your response.

Hello. In Step 1: Create View in SQL, the instructions state to make sure to use the script version corresponding to the Orchestrator version. Our Orchestrator version is 2018.4 but you only have view creation scripts up to version 2018.2. Can that still be used?

Hi, I am running Orchestrator ver. 2019.4.4Is there available scripts for this version of Orchestrator? I am a bit reserved to run the script which is made for other version of Orchestrator.

We are using orchestrator version 2018.4.5. Please help us with the sql scripts for this version ?

Hi Sorin,I am preparing ROI Mapping excel documents. Can you please let me know in column C (itemCost) do I need to mentioned itemCost in minutes ?Or is there another way to calculate itemCost ?Thanks.

Hello Sorin,Regarding to ROI Mapping template which is in Power BI Package zip, we have some questions.1- As there are 2 columns timeValueMin and ItemCost we would like to know why do they stand for? In what scale unit (ex. per run, per day, hr or month)2- Even we filled out the "itemCost" column, the values are not reflected to Job Dashboard (BI Chart) AnalyticsJobs2 sheet. Do we miss or misunderstand in that point? Or is there another way to reflect this value to these charts.ThanksRonak

Hi Sorin,An example case: We have an example automation process which runs twice a day. For that process robot runs approximately 20 min for each run and for humans to do the same job it takes 120 min. each time. So, how can we indicate this example on ROI Mapping excel table?Thanks in AdvanceRonak

Hi Sorin,I would like to know your recommendation on how we can effectively update the time value ans item cost on the ROI mapping. Also, does the Report needs a dbo schema.My jobs dashboard is working but I have and error on the Queues Dashboard , particularly on the SLA Status. Let me know how to fix this. Thanks,Carlito

Thanks for the awesome work! But I have doubt on whether it would be still fine on orchestrator version 2019.10.1? Please help. Much Thanks.

When I deploy the Dashboard in SQL Server.

I assume that it directly uses the SQL Server so it shows UK time.

Is there any option to use local time in Dashboard?

or Do I need to change the script like DATEADD(HOUR,9,[STARTTIME])?

this is great. but i still not get it about ROI sheet and how to use it. could you inform us how to use it. what is mean timeValueMin and item cost at that sheet and how can power bi interpret it. thank you

We are running the Orchestrator v.2019.10.15

Are there available scripts for this version of Orchestrator?

I would like to replace the ROI Mapping excel file source to DB table.  Can you please share expression on how you calculated "timeValueMin" and "itemCost" data items and also the respective table information?

Very interesting and complete  - Thanks a lot !


Super - Great tool. Easy to implement, very clear and useful.
Thanks!


Brilliant - Thanks very much Sorin. Saved us a lot of time and effort and provides a great foundation to customise our own dashboards from.


Thank you so much for this and for the amazing effort you have put in..

Great!!

Power BI Jobs and Queues Dashboards

Power BI Jobs and Queues Dashboards

Help

How To