WHAT IS IT?
This powerful dashboard allows you to visualise all the reconciliations on your instance, alongside information on:
- What the codes of these reconciliations' are
- What their last run number is
- The status of their latest run (i.e. succeeded, failed)
- Their average match rate*
- Outstanding exceptions**
* The number of runs over which the average match rate is calculated is configurable so if you wish to see the average rate over the last 10 runs, you can easily do so in the dashboard (please see Step 4 of the next section)
** By default, the dashboard will show exceptions that have been pending for more than one day, however if you wish to only see exceptions that have been identified more than 30 days ago, you can easily narrow down your results (please see Step 4 of the next section)
The dashboard also offers high-level controls so you can filter down your results even further. You can choose to see all your processes or individual reconciliations, you can group your recs by groups (please see Steps 2 and 3 of the next section) and you can choose to only see results belonging to parent processes or staging copies - or both!
WHAT DOES IT LOOK LIKE?
Here is what the dashboard looks like:
HOW DO I GET ONE?
- First of all, you need an additional module called Data Platform. If you are unsure whether this feature is enabled on your instance, please contact your manager or your Customer Success Manager.
- If Data Platform is enabled on your instance, you will need a BI tool such as Tableau, PowerBI, Qlik, etc. as well as an understanding of how these tools work (or a dedicated resource within the company who typically does BI reporting).
- Connect your BI tool to Data Platform by following the steps outlined here.
- Download the Tableau workbook attached at the bottom of this article.
- Follow the steps outlined in here in order to connect to the data source.
- Enjoy your new data platform dashboard in Tableau!
HOW WAS THE DASHBOARD CREATED?
Below we have listed the steps we have taken to build the dashboard. You could use these instructions to build the dashboard from scratch, if required. Please note these instructions have been modeled on Tableau, although other BI tools may follow a similar setup.
Building your own dashboard
Step 1 - Table Joins
- Runs connected to Processes on process_id field
- Processes connected to Users on user_id
Step 2 - Process Group
When looking at the dashboard you might have noticed a ‘Process Group’ filter on top. Process group is something that doesn’t exist in Duco however you can easily combine multiple processes into unique groups in Tableau to navigate throughout your processes more efficiently, e.g. trade reconciliations vs positions reconciliations. To set up a group, you will need to:
- Use the data_label field from the processes table (which is the data label applied during the creation of the processes, e.g. trades, positions, etc.)
- Create groups manually in Tableau using underlying data, e.g. the process_id field
Step 3 - Main fields (dimensions) used in the dashboard:
- Code – renamed, from field process_id (table: processes)
- Process name – renamed, from field name (table: processes)
- Last run – number of last run, calculated field in Tableau, see details below
- Last run at – date of last run, calculated field in Tableau, see details below
- Last status – status of last run, calculated field in Tableau, see details below
Last run at
Step 4 - Parameters used in the dashboard
- Average Match Rate – this allows you to control average match rate calculations. Move the slider around to change how many last runs the average match rate should be calculated from. If selected 1, the match rate will be from the last run of each process.
- Show exceptions pending more than (Days) – depending on your internal KPIs, move the slider around to display the number of exceptions outstanding for more than X days. Of selected 0, the dashboard will show all the outstanding exceptions.
- Process version – select which processes should be included on the dashboard. Possible selections: Parent Only, Staging Only, Parent & Staging (or create your own!)
Step 5 - Measures used in the dashboard
- Average Match rate – field calculated in Tableau, see details below
- Outstanding exceptions – field calculated in Tableau, see details below
Average Match Rate
To calculate the Average Match Rate you will also need to compute the following fields:
I NEED HELP!
If you need help with any of the above, please submit a request here. Alternatively, please contact your Customer Success Manager.