In order to improve the Data Quality, DQ Analysts must have the clear picture about Current State of Data Quality as well as Organizational Readiness for Data Quality. Getting a …
RDM – Reference Data Management
Reference Data is any data used to characterize or classify other data, or to relate data to information.Reference Data Management entails control and maintenance of defined domain values, definitions, and …
Data Management – What is Master Data?
Different types of Data play different roles within an organization. They also have different management requirements. Malcolm Chisholm has proposed a six-layer Taxonomy of Data that includes Metadata, Reference Data, …
Reference and Master Data Management – Guiding Principles
Shared Data: Reference and Master Data must be managed so that they are shareable across the organization. Ownership: Reference and Master Data belong to the organization, not to a particular …
Data Quality – Cleansing and Enrichment
Data Cleansing / Scrubbing Data Cleansing or Scrubbing transforms data to make it conform to data standards and domain rules. Cleansing includes detecting and correcting data errors to bring the …
Data Quality – Causes of Data Quality Issues – Part-03
Issues Caused by System Design Failure to Enforce Referential Integrity: Referential integrity is necessary to ensure high quality data at an application or system level. If referential integrity is not …
Data Quality – Causes of 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 entry interface does not have edits …
Data Quality – Business Rules
Business Rules are commonly implemented in software, or by using Document Templates for Data Entry. Some common simple Business Rule types are: Definitional Conformance: Confirm that the same understanding of …
Data Warehouse / Business Intelligence Projects – Critical Success Factors
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. Business Goals and Scope: Is there a …
OLAP – ROLAP, MOLAP and HOLAP
OLAP – Online Analytical Processing It is a technology, used to organize large business databases and supports to perform complex and multidimensional analysis, at high speeds on large volumes of …