Common Data Quality Issues – Part 1: Causes and Consequences Common Data Quality issues can emerge at any point in the data lifecycle, from creation to disposal. When investigating root …
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 …
Business Intelligence – Reporting and Analysis
Business Intelligence – Reporting and Analysis Operational Reporting Operational Reporting is the application of Business Intelligence tools to analyze business trends, both short-term (month-over-month) and longer-term (year-over-year). Operational reporting can …
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 …
Data Warehouse Implementation – Guidelines and Principles
Aligning Data Warehouse Projects with Business Goals Importance of Defining End Goals for Data Warehousing Global Data Warehouse Implementation Design with Localized Execution Optimizing Data Summarization Strategies in Data Warehousing …
Data Warehousing and Business Intelligence (Momentary Look)
Key Steps in DW/BI Implementation in Data Warehousing and Business Intelligence Data Warehousing and Business Intelligence Requirements: Development of Data Warehouse and Data Marts Business Intelligence Implementation and User Management …