Ability to display dashboard as well as ability to download DQ reports execution along with dataset information.

Client TECK Resources is using the SKP DQ Quality module to build and register multiple data quality reports and would like to use dashboards to regularly track data cleansing progress.

They currently have four subject areas comprising over 70 datasets in total:

• ATR (Acquire-to-Retire)

• PTC (Product-to-Cash)

• RTR (Record-to-Report)

• STP (Source-to-Pay)

The client would like to view weekly, monthly, and yearly trends for each subject area as well as for individual datasets.

Out of the box, the standard dashboard only supports DQ trend reporting at the overall program level. Since subject-area and dataset-level trending is not supported natively, we attempted to build a custom dashboard that would display execution details by subject area along with dataset names. The intent was for the client to download this data and use it in their own Power BI dashboards.

However, we were unable to include the dataset name in the custom dashboard because none of the standard data sources available in the custom dashboard builder expose this information.

We consulted with Maz, who indicated that extracting this level of detail would require making an API call.

. At this point, we have not identified a solution to download execution data that includes:

• Subject area

• Dataset name

• Rules

• Enforcement and implementation details

• Last execution date

• DQ score metrics

Could you please advise on the recommended approach to achieve this level of reporting?

Support ticket :

https://support.syniti.com/hc/en-us/requests/131976