http://www.datamgmt.com/ The Data Management & Warehousing Knowledge Base provides information and techniques about the design, build and implementation of data warehousing solutions that we as a company use and hope that you will also find useful. 2010-09-09T03:59:53+01:00 http://www.datamgmt.com/ http://www.datamgmt.com/index.php?module=article&view=81 This white paper looks at the business case that should lie behind the decision to build a data warehouse and provide a business intelligence solution.<br />Updated: http://www.datamgmt.com/index.php?module=article&view=66 Description of a method to identify changes from one version of an extract file to the next.<br />Updated: http://www.datamgmt.com/index.php?module=article&view=72 We all know that we should be writing file extracts as XML but if we really need to get a CSV file then here is how to do it<br />Updated: http://www.datamgmt.com/index.php?module=article&view=80 How business store and manage their data can have critical effect on data quality and consistency as well as performance and development times. This paper examines how data works and explores techniques exploited from understanding how data works<br />Updated: http://www.datamgmt.com/index.php?module=article&view=79 A wallchart outlining the process required to develop continuous data quality within an organisation is available for download<br />Updated: http://www.datamgmt.com/index.php?module=article&view=77 All projects need documentation and many companies provide templates as part of a methodology. This document describes the templates, tools and source documents used by Data Management & Warehousing. It serves two purposes:<br /> <br /> * For projects using other methodologies or creating their own set of documents to use as a checklist. This allows the project to ensure that the documentation covers the essential areas for describing the data warehouse.<br /> * To demonstrate our approach to our clients by describing the templates and deliverables that are produced.<br />Updated: http://www.datamgmt.com/index.php?module=article&view=78 An organisation that is embarking on a data warehousing project is undertaking a long-term development and maintenance programme of a computer system. This system will be critical to the organisation and cost a significant amount of money, therefore control of the system is vital. Governance defines the model the organisation will use to ensure optimal use and re-use of the data warehouse and enforcement of corporate policies (e.g. business design, technical design, and application security) and ultimately derive value for money.<br />Updated: