How Data Quality Reporting Works? The work of assessing the quality of data and managing data issues will not benefit the organization unless the information is shared through reporting so …
Data Quality Assessment
Data Quality Assessment – A Practical Approach to Improvement DQ Analysts will need to sort out and prioritize findings. The goal of an initial Data Quality Assessment is to learn …
Reference and Master Data Management – Guiding Principles
Shared and Owned Enterprise Data in Master Data Mangement Principles Stewardship and Data Quality Governance Change Control and System of Record in Master Data Mangement Principles
Data Quality – Data Profiling
What Is Data Profiling in Data Quality? Data Profiling is a form of data analysis used to inspect data and assess quality. Data profiling uses statistical techniques to discover the …
Data Quality – Causes of Data Quality Issues – Part-03
Data Quality Issues Part-03 Issues Caused by System Design Failure to Enforce Uniqueness Constraints Multiple copies of data instances within a table or file expected to contain unique instances. If …
Data Quality – Causes of Data Quality Issues – Part-02
Resolving Data Quality Issues Part 02 Issues Caused by Data Entry Processes Data Entry Interface Issues Poorly designed data entry interfaces can contribute to data quality issues. If a data …
Data Quality – Business Rules
Business Rules in Data Quality Business Rules are commonly implemented in software or by using Document Templates for Data Entry. Some common simple Business Rule types are: Type of Business …
Data Warehouse / Business Intelligence Projects – Critical Success Factors
Securing Executive Support Through Business Sponsorship Business Sponsorship: Is there appropriate executive sponsorship, i.e., an identified and engaged steering committee and commensurate funding? DW/BI projects require strong executive sponsorship. Defining …
OLAP – ROLAP, MOLAP and HOLAP
How OLAP, ROLAP, MOLAP, and HOLAP Work OLAP – Online Analytical Processing It is a technology used to organize large business databases and supports performing complex and multidimensional analysis, at …