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 – 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 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 …
Data Quality – Core Dimensions
A Data Quality dimension is a measurable feature or characteristic of data. The term dimension is used to make the connection to dimensions in the measurement of physical objects (e.g., …
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 …
Business Intelligence – Reporting and Analysis
Operational Reporting is the application of BI tools to analyze business trends, both short-term (month-over-month) and longer-term (year-over-year). Operational reporting can also help discover trends and patterns. Tactical BI Tool …