Data Management & Warehousing

Author: macleanwalker

  • Addressing Business Intelligence Data Quality

    —

    by

    macleanwalker
    in

    A friend of mine posted a link to Michael W. Dobson’s TeleMapics Blog entitled Google Maps announces a 400 year advantage over Apple Maps about Apple’s problems with the release of their own mapping solution with iOS6. These problems are well documented elsewhere but Michael’s post highlights problems not just associated with mapping data but common across…

  • Building An Analytical Platform

    —

    by

    macleanwalker
    in

    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…

  • Inspirational Data Visualization

    —

    by

    macleanwalker
    in

    Data visualization has come of age – there is now no excuse for not only having good information but also for presenting it in an engaging and informative way. Here we look at a number of sites that can inspire and inform the way you present your information. Nathan Yau has a blog called Flowing Data that gathers…

  • It’s time for Slow Business Intelligence

    —

    by

    macleanwalker
    in

    I have been aware for a few months of the Slow Web Movement, which, like other parts of the slow movement, advocates a cultural shift toward slowing down life’s pace. More specifically it is about getting more value and less volume from the web, getting quality information when it is appropriate and not being overwhelmed…

  • Gathering Business Requirements for Data Warehouses

    —

    by

    macleanwalker
    in

    This presentation is our template that we use for “Gathering Business Requirements” workshop as part of the Data Management & Warehousing Data Warehouse Documentation Roadmap process The agenda of a workshop is normally: Overview of the process Why gather requirements like this? Types of requirement Understanding what we can do Business processes create data Understanding dimensions…

  • OS X Mountain Lion Tips

    —

    by

    macleanwalker
    in

    This brief blog post is a summary of the various things we have found on the upgrades of our Apple Mac infrastructure. It is primarily intended for internal use however it may prove useful to others. Some of this information is widely available and was prior to the release of Mountain Lion. MacBooks from 2007…

  • Our Toolbox – Essential Software

    —

    by

    macleanwalker
    in

    A data warehouse project will usually involve many pieces of software. These can be broken into two categories – architectural software and supporting tools. The architectural software will include the database, ETL tool, reporting tools, etc. but in this post I am going to look at the supporting tools we use. I should say from…

  • BI Vendors & Thought Leaders on Twitter

    —

    by

    macleanwalker
    in

    Our aggregated twitter feed https://datamgmt.com/twitter has all the latest tweets from thought leaders, vendors and some leading BI organisations. You can also subscribe to the list directly on twitter Don’t forget whilst you are here to have a look at our White Papers, Presentations and Blog The current list includes (links to their individual twitter accounts):…

  • Password Security

    —

    by

    macleanwalker
    in

    An article in the Metro newspaper I picked up on the tube recently once again made the point about just how easy it is to hack most peoples web accounts. I know this is true because, even though I know better, a little over a year ago I was sharing a password between multiple sites…

  • Bookshelf

    —

    by

    macleanwalker
    in

    Here is our bookshelf, a list of useful and favorite books in the development of software, management of projects and business intelligence. Click on the image to see the Amazon description. Peopleware: Productive Projects and Teams by Tom DeMarco, Timothy Lister (1988) [amazon asin=0932633056&template=thumbnail&chan=default] The Mythical Man-Month: Essays on Software Engineering by Frederick P. Brooks…