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 …
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 Warehousing and Business Intelligence (Momentary Look)
Requirements’ Understanding Define and Maintain the DW/BI Architecture Define DW/BI Technical Architecture Define DW/BI Management Processes Develop the Data Warehouse and Data Marts Map Sources to Targets Remediate and Transform …
Document and Content Management (A Glance)
Plan for Lifecycle Management Plan for Records Management Develop a Content Strategy Create Content Handling Policies Social Media Policies Device Access Policies Handling Sensitive Data Responding to Litigation Define Content …
Difference between ETL and ELT
ETL – Extract, Transform, and Load Central to all areas in Data Integration and Interoperability is the basic process of Extract, Transform, and Load (ETL). Whether executed physically or virtually, …