Bob Lambert

Chromatic and Diatonic Harmonicas

Category: IT

  • BI Business Case Basics: Three Things to Remember

    Here are three things to remember when putting together a BI business case: Intangible benefits don’t count. BI has no inherent value. Senior managers often make decisions about future outcomes with insufficient data.

    continue reading

  • Don’t forget to get it done

    In a recent article at Information Management, Maria Villar and Theresa Kushner offer 4 Steps to Create an Effective IT and Business Partnership, a very useful list of ways to ensure “strong partnership between IT and business”.  To the authors this partnership “is the most important, and often overlooked, component to successfully managing critical business…

    continue reading

  • Coming soon: data like money

    It is a commonplace to say we should manage data like a resource. But when you think about it, data is an asset but not a resource.  Data isn’t a thing like real estate, employees, or customers, but rather it represents all of those things.  In data-geek-speak, data is a meta-resource that holds information about…

    continue reading

  • Study data early to improve application alignment

    A recurring theme in the literature on IT over the years has been frequent failure of IT projects.  Most studies lay the bulk of the blame on requirements (examples here and here).  One way to improve accuracy and fit-to-purpose of requirements, and thereby promote project success, is to include data analysis as well as process…

    continue reading

  • DQ, he isn’t so dumb he just needs glasses

    In a recent very thoughtful post on data quality, Paul Erb plays out an analogy comparing data users with Don Quixote and data quality professionals with Sancho Panza, then reverses the analogy to cleverly coin the “Sancho Panza” test of data quality professionals.  He encourages data quality professionals promoting the critical role of data quality…

    continue reading

  • SQL Server Row Level Security @ Richmond Code Camp 2009.1

    —– Update 10 January 2010: Thanks to Gints Plivna for observing that we had not posted the slides to this presentation, here they are: Pretty Good Row Level Security Slides.  – Bob —– Thanks to those who attended Saturday’s Microsoft Code Camp (see http://richmondcodecamp.org/).  Here are materials for the presentation “Pretty Good Row Level Security”…

    continue reading

  • IT should own the misalignment problem

    In a new post at Insurance Networking News Ara Trembly provides a balanced perspective on IT/business misalignment (Business/IT Misalignment: Whose Responsibility?).  He describes the problem as cultural, more amenable to relational than management solutions.    His conclusion sums it up: “Take a geek/suit to lunch today!” To me (speaking as an IT professional) IT should take…

    continue reading

  • No business value in nulls

    It seems I’m frequently in conversations about using null to represent a business value.  To paraphrase, say there are credit and cash customers, and there’s a suggestion to set “Customer_Type” to “C” for credit and null for cash.  To data and database professionals this is obviously a bad idea, but it’s not obvious from a…

    continue reading

  • A proposal for Enterprise Information Architecture

    While many organizations understand the value of managing the information resource, for many others information management remains abstract and difficult to define.  In an effort to make it concrete here’s a hypothetical proposal to provide an Enterprise Information Architect for a hypothetical organization that really needs one.

    continue reading

  • Do your homework before presenting a BI business case

    Before starting the Business Intelligence business case, the BI advocate should do the homework required to ensure its success, including these essential steps: 1. Know the organization’s goals and objectives. 2. Identify a BI champion. 3. Identify and work with BI stakeholders. 4. Identify an application with tangible business value. 5. Define and quantify a…

    continue reading