Data Quality Incident Tracking System Overview The incident tracking system will collect performance data relating to issue resolution, work assignments, volume of issues, frequency of occurrence, as well as the …
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 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 …
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 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 …
Data Modeling – Conceptual, Logical and Physical Model – CDM, LDM and PDM
What is Data Modeling? Data Modeling is the process of creating an illustrative and visual representation of either a whole information/database system or parts of it to show the relationships …
Smart KPI Strategy – Key Performance Indicator
What is a KPI? The KPI term is more popularized, and as the name suggests, KPI is a Progress and Performance Measurement tool. KPIs are used to assess and evaluate …
NoSQL Column-Oriented Database – Columnar Database – Column Store Database – C-Store
Introduction to NoSQL Column-Oriented Database NoSQL Column-Oriented Database is also known/called Columnar Database, Column Store Database, and C-Store. OLTP and OLAP in Column-Oriented Systems Column-oriented systems have been developed as …