Data Management & Warehousing

Tag: Process Neutral Data Model

  • Analysis by ETL …

    —

    by

    macleanwalker
    in

    Performing source-system analysis by writing ETL is just about the most expensive way you can do it; but many organisations do exactly that. Why? Because they “can’t afford” to do their analysis the cheaper way. No, this does not make sense. This is how it works… In most data warehousing projects, business analysts are separated…

  • BI Convention over Configuration

    —

    by

    macleanwalker
    in

    The convention over configuration discussion when designing a data warehouse often leads to fanatical discussions by technical people over the ‘best’ approach to do things. Convention can be used to define the standard way to design a data model (see Process Neutral Data Modelling) or to implement an ETL transformation (for example a reducing sets approach)…

  • Process Neutral Data Modelling

    —

    by

    macleanwalker
    in

    This paper describes in detail the process for creating an enterprise data warehouse physical data model that is less susceptible to change. Change is one of the largest on-going costs in a data warehouse and therefore reducing change reduces the total cost of ownership of the system. This is achieved by removing business process specific…

  • ETIS – The global IT association for telecommunications

    —

    by

    macleanwalker
    in

    ETIS (http://etis.org) is a membership based organisation which brings together the major telecommunications providers in Europe on key information and communication technology issues. The mission of ETIS is to enable its members to improve their business performance by personal exchange of information on using ICT effectively. ETIS achieves this by engaging its members in various working…

  • Process Neutral Data Modelling Concepts

    —

    by

    macleanwalker
    in

    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…

  • An Introduction To Process Neutral Data Modelling

    —

    by

    macleanwalker
    in

    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…

  • Template Solutions for Data Warehouses and Data Marts

    —

    by

    macleanwalker
    in

    A presentation given in 1998 to the Data Warehousing & Business Intelligence Conference on the value of using template solutions for data warehouses and data marts. It describes the types of reporting system and discusses the templates then available for them Download Template Solutions for Data Warehouses and Data Marts Now