Data Management & Warehousing

Author: macleanwalker

  • The top three mistakes I have seen in data warehousing projects

    —

    by

    macleanwalker
    in

    A guest blog by Don DeLoach, CEO of Infobright Having been a supplier of technology for many years, I have talked to a lot of prospects and customers and seen a lot of projects. Most projects are reasonably good, some are great, and then some others are disasters. The disasters are probably more prominent than…

  • Guest Bloggers

    —

    by

    macleanwalker
    in

    We’re not the only ones with opinions – so maybe you would like to share yours with us as a guest blogger. We would really appreciate a one-off blog post from you as our guest blogger If you want to submit something here are our guest blogging guide lines: We want content relevant to the site,…

  • Installing R and RStudio on Redhat/CentOS Linux

    —

    by

    macleanwalker
    in

    As part of our forthcoming magazine article “Building an Analytical Platform” for SAP we described the need to install both R and RStudio. Our test system is an older CentOs 5.8 Linux box and so needs to use the Extra Packages for Enterprise Linux (EPEL) packages As ‘root’ on your system perform the following four…

  • Business Intelligence – BPR by the back door?

    —

    by

    macleanwalker
    in

    In a recent discussion with a client I was asked how come we knew, as a Business Intelligence company, so much about business process and operational systems. My reply is a sincere view that I have held for some time – developing good Business Intelligence means implementing Business Process Re-engineering (BPR) to enable the organisation…

  • Our Software

    —

    by

    macleanwalker
    in

    Over the years we have produced several utilities and open source projects. List list provides some information about their status GROUT – ETL tool including DAP & SQLUnload written in Korn Shell, C & PL/SQL – superseded by JST – code available on request JST – ETL tool written in Bash Shell – superseded by…

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

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

    —

    by

    macleanwalker
    in

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

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