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 …
Document and Content Management – Information Architecture
Rule of Content Management in Information Architecture Once we talk about Document or Content Management System, the Information Architecture identifies the links and relationships between documents and content, specifies document …
Data Warehouse, Data Lake & Data Vault
Understanding Data Lake vs Data Warehouse Data Lake and Data Warehouse both act as repositories, but they are designed for very different purposes. Data Warehouses work best for specific projects …