Different types of Data play different roles within an organization. They also have different management requirements. Malcolm Chisholm has proposed a six-layer Taxonomy of Data that includes Metadata, Reference Data, …
Reference and Master Data Management – Guiding Principles
Shared Data: Reference and Master Data must be managed so that they are shareable across the organization. Ownership: Reference and Master Data belong to the organization, not to a particular …
Data Quality – Cleansing and Enrichment
Data Cleansing / Scrubbing Data Cleansing or Scrubbing transforms data to make it conform to data standards and domain rules. Cleansing includes detecting and correcting data errors to bring the …
Data Quality – Causes of Data Quality Issues – Part-03
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 …
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 …