The Cloud Data Quality Reporting Dashboard Template is designed to provide a framework to capture reporting metrics for data quality issues by extracting the Profile Details from the CDQ Profile Warehouse. Furthermore, it demonstrates how to visualize the profiling data in a business intelligence tool.

Template includes a Python Script, and a sample Power BI Report and Dashboards illustrating DQ metrics. In addition, it includes sample data files on which provided Power BI Report is build, to allow you to view the reports without having the system up and running and generating metrics.

Sample report is build using Power BI but any reporting tool can be utilized to design similar DQ Dashboard.

Contents -

Python Script - IICS_CDQ_Dashboard_Dataset.py

Sample Power BI Report - CDQ_Report.pbix

Sample CSV files (used to build the sample Power BI Report) - Sample CSV Files

Informatica IICS prerequisites -

User must have access to all the profiles in the IICS org

Profiles must have executed at least once

Note - This Python script is tested with Python 3.11.1