Business Problem: The client needed a Dashboard to track and monitor the progress of the Data Governance projects with respect to building a Glossary, linking it to Information Assets and measuring Data Quality.
Our Solution: : To monitor the progress of the rollout and continually track the effectiveness of their Data Governance Program, a non-profit organization managing music rights, wanted a custom Dashboard that would help track usage of the various components of IBM InfoSphere Information Server that they had implemented – Business Glossary & Information Analyzer to measure Data Quality. Metrics were defined to measure the rate of Glossary Definition and Linkage and for measuring Data Quality across Indicator like Completeness, Validity, etc. This required the creation of custom queries to extract data from XMETA, the metadata repository of Information Server, development of DataStage jobs to load a custom Datamart and development of Dashboard & Reports in Cognos.
Technology: IBM InfoSphere Information Server 8.7 – XMETA, DataStage, Business Glossary, Information Analyzer, IBM Cognos 10.1, mySQL 5.5