Data Management & Warehousing

Author: macleanwalker

  • Agile Business Intelligence

    —

    by

    macleanwalker
    in

    This ETIS presentation from Cyprus in October 2011 This presentation describes what Agile really means for Business Intelligence and then describes some ways in which large organisations can make themselves more agile including: Team Structures Wiki-fy Everything Use A Dedicated Platform Build Literal Staging Areas Throw out your ETL Tool? More Dynamic Reporting Tools Develop reports with…

  • Enterprise Metadata Management Strategies

    —

    by

    macleanwalker
    in

    An ETIS presentation from Istanbul in March 2011 This presentation looks at what metadata is and when it is created, it then identifies some strategies for managing it. Metadatais defined as data providing information about one or more aspects of the data, such as: Means of creation of the data Purpose of the data Time…

  • BI Business Requirements

    —

    by

    macleanwalker
    in

    Another ETIS presentation from Stockholm in October 2010 This presentation looks at what it takes to develop good business requirements for business intelligence projects. It starts with the proposition that  “70% of all documented requirements are worthless” – Why ? Written but never referred to (Shelf-ware) Out of date before they are built Cover the wrong things Can’t be…

  • Struggling with Data Management ?

    —

    by

    macleanwalker
    in

    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…

  • Implementing Netezza Spatial

    —

    by

    macleanwalker
    in

    An internal training presentation on implementing Netezza Spatial functionality What is Spatial Technology? It’s the ability to analyse information in a geographic context: Where is the nearest petrol station? Which road am I on? How many ATMs are in this area? It’s not maps and images These come later with tools that help present the…

  • BI Governance Models & Strategies

    —

    by

    macleanwalker
    in

    An presentation to ETIS from April 2010 in Athens This presentation looks at what makes a successful model for implementing Business Intelligence Governance within an organisation. It builds on the white paper Data Warehouse Governance published in 2007 It starts by asking the following questions Is your BI programme allowed to define organisational structures outside the company programme…

  • The Business Case For Business Intelligence

    —

    by

    macleanwalker
    in

    This white paper looks at the business case that should lie behind the decision to build a data warehouse and provide a business intelligence solution. There are three primary drivers for making the investment in a business intelligence solution Measurement and management of the business process Analysis of why things change in the business in…

  • A Linux/Mac OS X Command Line Interface to AffiliateWindow

    —

    by

    macleanwalker
    in

    This article was written for a client due to the fact that we were unable to test the Affiliate Window API with the documentation available at the time Introduction Affiliate Window offer a tracking and management solutions for maintaining an affiliate program. This works by directing sales to a merchant from an affiliates’ website. In…

  • What can IT really deliver for BI and DW ?

    —

    by

    macleanwalker
    in

    This presentation to the IRM Data Warehousing & Business Intelligence 2009 conference looks at the why IT faces problems in delivering Business Intelligence to the Business and asks the question “Is the business really ready for BI?” Is BI something that the business really wants? Is the business prepared to pay for Business Intelligence? Is…

  • At last someone we understand …

    —

    by

    macleanwalker
    in

    It is rare with all the background reading and research that I have to do that I read a contemporary book and say “Yes, this guy gets it” – notice that I say contemporary. There are plenty of good books about the day-to-day business intelligence problems that I see which were written over 20 years…