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 – Causes of Data Quality Issues – Part-01
Data Quality issues can emerge at any point in the data lifecycle, from creation to disposal. When investigating root causes, analysts should look for potential culprits, like problems with data …
Data Quality Programs – Guidance and Principles
Criticality: A Data Quality program should focus on the data most critical to the enterprise and its customers. Priorities for improvement should be based on the criticality of the data …
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 …
Data Warehouse, Data Lake & Data Vault
Data Lakes & Data Warehouses Data Lakes and Data Warehouses both act as repositories, but they are designed for very different purposes. Data Warehouses work best for specific projects with …
Data Management – DII (A Momentary Look)
Plan and Analyze Define Data Integration and Lifecycle Requirements Perform Data Discovery Document Data Lineage Profile Data Collect Business Rules Design Data Integration Solutions Design Data Integration Architecture Select Interaction …
DII – Data Interaction Models – P2P, Canonical and Publish/Subscribe
Canonical Model (Hub-and-Spoke) A Canonical Data Model is a common model used by an organization or data exchange group that standardizes the format in which data will be shared. In …
DII – Need and Dependency
Data Integration and Interoperability is critical to Data Warehousing and Business Intelligence, as well as Reference Data and Master Data Management, because all of these focus on transforming and integrating …