Tag: Technical Architecture

  • Building An Analytical Platform

    Reprint of an article published by SAP about a recent piece of work I have recently been asked to build an analytical platform for a project – but what is an analytical platform? The client (a retailer) described it as a database where they could store data, a front end where they could do statistical work…

  • Building a Data Warehouse of Call Data Records (CDR): Solution Considerations

    Source: Database Trends and Applications (http://www.dbta.com/) Reprint of a magazine article from May 2012 With many organisations having established data warehouse solutions there comes a point where the solution needs to be extended in an unusual direction. This challenge was given to us by one of our clients a European Mobile Virtual Network Operator (MVNO)…

  • Using the right data model in a data mart

    An internal training presentation from March 2012 that looks at how the choice of technology affects the choice of data modelling strategy It start with a review of the current state of the art: The concept of a Data Mart as the data access interface layer  for Business Intelligence has been around for over 25…

  • Struggling with Data Management ?

    Re-print of a magazine article from August 2010 Those responsible for data management in your organisation are probably struggling. If you can find an individual or group responsible for everything then they have a lot on their plate.  Even if they have managed to write policies and procedures they probably don’t have the time or…

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

  • From Volume to Value

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

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

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

    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

    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