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
Challenges to implementing data architecture with packaged applications can be overcome by addressing issues and challenges during design Introduction In a previous article I discussed some issues that a client encountered when trying to implement a packaged application. They were
Every organization should follow a set of guidelines for implementing packaged applications to ensure architectural harmony and avoid numerous problems. Previously I discussed some issues that a client encountered when trying to implement a packaged application. They were convinced that
Business-focused data analysis activities allow for understanding data and correcting any discrepancies, regardless of systems design or implementation Introduction initiative is the first attempt at bringing business data together from multiple sources in order to make it available across different
Data mining is a powerful analytical activity that can be used with data warehouses and with operational systems, yielding valuable insights. Introduction Data mining is often confused with “writing lots of reports and queries,” when in fact data mining activities
Metadata supports the conditions that uses of abstraction in data modeling, ensuring lasting and scalable data models When I write on abstraction, I like to remind the reader of a very abstract painting I observed in a museum, which consisted
