There are many benefits to implementing surrogate keys in a dimensional model design for a data warehouse data model Introduction There are many reasons for implementing surrogate keys in Dimensional Models (enterprise data modeling) such as insulating dimensions from changes
Using a data governance maturity model to assess and continually measure the performance of the data governance program can give any organization tactical and strategic benefits. Introduction Generally, data governance is a long-term strategic initiative, but data governance can also
Using a framework such as a Capability Maturity Model (CMM) brings many benefits to any organization, for any project or program. Introduction Would you eat in a restaurant that had not been inspected periodically by the local inspector? Of course,
Data warehouse implementations are vulnerable to internal as well as external security threats. Follow these mitigating steps to reduce the risks. Introduction Security threats exist against your information resources, whether the systems are accessible through the Internet or buried deep
Independent data marts cause many problems in data warehouse architecture; combining to result in numerous issues for business intelligence and analytics solutions. A severe disease has spread to epidemic proportions throughout our society. This disease is particularly dangerous as it
A data strategy can contribute to an organization’s information strategic plan, and arrange for the productive use of the data asset. Introduction A Chief Financial Officer (CFO) was approached by the CEO and asked for an accounting of the company’s
Using a specialized data validity dimension in a data warehouse design can support data quality and analytics capabilities. Introduction While working on an Enterprise Data Warehouse for a state court system the issue of poor data quality in the source systems became
Customer data integration can be improved by using generic dimensional modeling techniques Introduction If you are undertaking a Customer Data Integration (CDI) or Customer Master Data Management (MDM) project as part of a dimensional modeling endeavor, how will you tackle
Effective metadata management rs software require with robust functionality, enabling full capability for business and technical users Introduction Many government agencies and corporations are currently examining the metadata tools on the marketplace to decide which of these tools, if any,
Every successful enterprise architecture relies on enterprise metadata management as part of its foundation. Introduction Almost every large government agency or Global 2000 company is struggling to properly manage an enterprise information technology (IT) architecture. This difficulty is the direct
