Data Management & Warehousing

Tag: Analysis

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

  • Analysis by ETL …

    —

    by

    macleanwalker
    in

    Performing source-system analysis by writing ETL is just about the most expensive way you can do it; but many organisations do exactly that. Why? Because they “can’t afford” to do their analysis the cheaper way. No, this does not make sense. This is how it works… In most data warehousing projects, business analysts are separated…

  • We’ve got a new puppy – we’ve called him ETL!

    —

    by

    macleanwalker
    in

    Monday … Our house is full of optimism today – we’ve been out and spent an absolute fortune on a pedigree pup. We were really impressed by the salesman at the shop. He offered something to each family member. Mum (our family manager and my wife) was sold on the the cost efficiency. We won’t…