Data Strategy and Data Platform Strategy are related but distinct concepts, each focusing on different aspects of an organization’s data management and utilization. The two strategies work together, with the …
Oracle Autonomous Database
Oracle says, Autonomous Database is a mission-critical, converged database that runs transactional and analytic workloads. It automatically scales, tunes, patches, and secures all the workloads using machine learning to provide …
Applying the DSTv update for the Oracle Database – Timezone Upgrade
Applying the RDBMS DSTv36 patch 32327201 on the server side in Oracle RDBMS 12c and above After a DST patch is installed on 12c $ORACLE_HOME there are steps who need to be …
Data Quality – Incident Tracking System
The incident tracking system will collect performance data relating to issue resolution, work assignments, volume of issues, frequency of occurrence, as well as the time to respond, diagnose, plan a …
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 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 …
Data Warehouse, Data Lake & Data Vault
Data Lakes & Data Warehouses Data Lakes and Data Warehouses both act as repositories, but they are designed for very different purposes. Data Warehouses work best for specific projects with …
Data Warehousing and Business Intelligence (Momentary Look)
Requirements’ Understanding Define and Maintain the DW/BI Architecture Define DW/BI Technical Architecture Define DW/BI Management Processes Develop the Data Warehouse and Data Marts Map Sources to Targets Remediate and Transform …