Data Management & Warehousing

Author: macleanwalker

  • Black Swans and White Elephants

    —

    by

    macleanwalker
    in

    Another ETIS presentation from Istanbul in Octovber 2009 This presentation looks at the Return on Investment in Business Intelligence projects Return on Investment is a performance measure used to evaluate the efficiency of an investment or to compare the efficiency of a number of different investments. To calculate ROI, the benefit (return) of an investment is…

  • Data Warehousing – Change Management In A Challenging Environment

    —

    by

    macleanwalker
    in

    The way in which data warehouse developments and solutions are viewed is changing. The emphasis is less on the technological problems, many of which have been solved, and more on the day-to-day issues of living and working with a data warehouse. These issues include: • Configuration/Change Management • Managing and Improving Data Quality • Engagement…

  • Data Quality: Common Problems & Checks

    —

    by

    macleanwalker
    in

    An ETIS presentation from Zagreb in April 2009 Data Quality problems are a SOURCE SYSTEM issue and an ETL issue They just manifest themselves in the data warehouse Prevention is better than cure Fixing the source system or the ETL is ALWAYS cheaper and more effective than cleaning the data in the ETL or in the…

  • 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…

  • Data Warehouse Project Management

    —

    by

    macleanwalker
    in

    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…

  • Connections – A Life In The Day

    —

    by

    macleanwalker
    in

    An interview for recruitment company Connections who ran an occasional series entitled “Connections – A Life In The Day” – and yes it was deliberately backwards Download Connections – A Life in the Day of David-Walker now

  • Ready for Change?

    —

    by

    macleanwalker
    in

    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

    —

    by

    macleanwalker
    in

    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…