Data Management & Warehousing

Category: Presentations

  • Agile Development of a BI application

    —

    by

    macleanwalker
    in

    Wandering around the web I found a presentation by Soren Burkhart of Hawaii Business Consulting, LLC given at the Rails Conference in Portland, Oregon (May 2007) that describes a classic agile approach to developing a Business Intelligence application for the Office of Foreign Assets Control (“OFAC”) of the US Department of the Treasury. It demonstrates the collecting of…

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

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

  • From Volume to Value

    —

    by

    macleanwalker
    in

    A presentation given to the Oracle Business Intelligence forum for Telcos that discussed how businesses should move from collecting volume of data to using the value of the data. It sets the context about what issues businesses are facing and then suggests five actions that can be used to help address the issues. These are:…

  • The Continuous Data Quality Process Wallchart

    —

    by

    macleanwalker
    in

    The large format edition of the Continuous Data Quality Process wallchart is now available for download   Download the Continuous Data Quality Process Wallchart now

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

  • Information Delivery: The Change In Data Management at Network Rail

    —

    by

    macleanwalker
    in

    In September 2004 we presented at the Oracle OpenWorld conference on the successful initial stages on rolling out an enterprise wide information and reporting portal built on the Oracle tool set. Rail privatisation and RailTrack was failing and Network Rail was created to take over the management of the different aspects of the railways. This…

  • 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