A presentation of ethods developed for assessing data quality, conducting data validation and cleaning, and implementing business practice changes to provide long-term data quality improvements. Integral to this process is the use of Oracle Discoverer as the data quality probe. The case study is the implementation of 22 branch datamarts to collect standard data for reporting and analysis purposes and integrate into the corporate data warehouse.
Many organizations are data rich and information poor.
In a case study, Oracle business intelligence tools were used to help British Columbia Parks staff set management priorities, by transforming data into information tailored to particular decisions. Through this work and parallel research, a list of success factors for business intelligence projects has been compiled. Because business intelligence tools encourage integrative thinking and shared decision making, their use raises issues about organizational silos, over-arching organizational goals or needs, collaboration, information sharing, and empowerment of front line staff. The repository in Oracle Designer can be populated during the application development life cycle or through the reverse engineering of existing schemas such as those found in the data warehouse. A consistent problem is the lack of update applied to the metacontent elements of an application that in the repository of the maintenance phase.