Data Management & Warehousing

Category: Presentations

  • An Introduction To Social Network Data

    —

    by

    macleanwalker
    in

    An internal training presentation from May 2012 Social Networks such as Facebook are everywhere. They gather a wide range of data about each and everyone of us who joins their ranks. This presentation looks at what data they collect and how it is used by application developers and marketeers. It also looks at how to…

  • Implementing Business Intelligence and Data Warehouse Governance

    —

    by

    macleanwalker
    in

    This presentation outlines six governance processes that we believe cover the entire Business Intelligence & Data Warehousing Lifecycle Data Lifecycle Data Models Data Quality Data Security Data Warehousing Metadata And describes our people and process template approach to delivery Download Implementing Business Intelligence and Data Warehouse Governance Now

  • Using the right data model in a data mart

    —

    by

    macleanwalker
    in

    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…

  • Storage Characteristics of Call Data Records in Column Store Databases

    —

    by

    macleanwalker
    in

    A presentation from an internal training session about the storage characteristics of call data records in Column Store Databases such as InfoBright, Sybase IQ and Actian Vectorwise It describes: What a Call Data Record is What a Column Store Database is The test environment we built to test the storage The results of our testing…

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

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

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