Tag: Data Warehousing

  • Process Neutral Data Modelling Concepts

    This is the first presentation to ETIS held in Brussels in November 2008 It takes a deep dive look at the problems with conventional data modelling for the data warehousing and looks at an alternative approach known as Process Neutral Data Modelling. It is a natural follow on from the previous UK Oracle User Group presentation…

  • Data Warehouse Project Management

    Data warehouse projects pose a specific set of challenges for the project manager. Whilst most IT projects are a development to support a well defined pattern of work a data warehouse is, by design, there to support users asking ad hoc questions of the data available to the business. It is also a project that…

  • Ready for Change?

    A presentation given to the 3rd Citia BTC Conference in Kiev. This presentation looks at the problems of creating a long-term sustainable data warehousing environment in the context of the change that will affect them: Data warehouses are constantly in a state of flux The cost of build is small by comparison with the operational…

  • Conspectus: Data Warehousing Appliances: Fad or Future

    The original article for Conspectus magazine. Conspectus is the UK’s leading independent report which authoritatively addresses the key IT application areas. It is acknowledged as one of the most trusted journals in the IT industry and is used by many organisations to help them in their selection of IT software and technology. An updated version…

  • How Data Works

    Every business believes that their data is unique. However the storage and management of that data uses similar methods and technologies across all organisations. As a result the same issues of consistency, performance and quality occur across all organisations. The commercial difference between organisations is not whether they have data issues but how they react…

  • Data Warehouse Governance

    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…

  • Data Warehouse Documentation Roadmap

    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: For projects using other methodologies or creating their own set of documents to use as a checklist. This allows the project to…

  • Project Services

    Welcome to Project Services In the Data Management & Warehousing White Paper Data Warehouse Governance the importance of change control and issue tracking to a successful data warehousing project are highlighted. This paper also highlights the importance of a lightweight or agile development methodology and how using a wiki can help improve the develpment process. Project Services offers the following: A demonstration…

  • Overview Architecture for Enterprise Data Warehouses

    This is the first of a series of papers published by Data Management & Warehousing to look at the implementation of Enterprise Data Warehouse solutions in large organisations using a design pattern approach. A design pattern provides a generic approach, rather than a specific solution. It describes the steps that architecture, design and build teams…

  • An Introduction To Process Neutral Data Modelling

    A presentation given to the UK Oracle User Group about the technique of process neutral data modelling Process Neutral Data Modelling is A method of designing a data model for a data warehouse that is less affected by changes in source system and/or business process A technique that incorporates the metadata within the data model…