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 Warehouse Implementation – Guidelines and Principles
Focus on Business Goals: Make sure DW serves organizational priorities and solves business problems. Start with the End in Mind: Let the business priority and scope of end-data-delivery in the …
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 …
Data Management – Manage Versioning and Control
ANSI Standard 859 has three levels of control of data, based on the criticality of the data and the perceived harm that would occur if data were corrupted or otherwise …
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 …
Data Management – Security Metrics
It is essential to measure information protection processes to ensure that they are functioning as required. Metrics also enable improvement of these processes. Some metrics measure progress on processes: the …
Data Security – Tools
Information Security Management depends on the size of the organization, the network architecture, the policies and standards used by a security organization. The following is highly recommended to be part …