Vendor Provided Analytical LDM

I found the following article interesting as this was something we had been discussing during a debate of Netezza vs Teradata.  One of the comments was to go with Teradata and use the vendor provided analytical LDM relevant to the clients industry.  This is a great list of Pros and Cons if an organization is thinking of implementing that way.  Here is an excerpt from the article:

"The following question comes from many of our clients: what are some of the advantages and risks of implementing a vendor provided analytical logical data model at the start of any Business Intelligence, Data Warehousing or other Information Management initiatives? Some quick thoughts on pros and cons:


  • Leverage vendor knowledge from prior experience and other customers
  • May fill in the gaps in enterprise domain knowledge
  • Best if your IT dept does not have experienced data modeler's 
  • May sometimes serve as a project, initiative, solution accelerator
  • May sometimes break through a stalemate between stakeholders failing to agree on metrics, definitions


  • May sometimes require more customization effort, than building a model from scratch
  • May create difference of opinion arguments and potential road blocks from your own experienced data modeller's
  • May reduce competitive advantage of business intelligence and analytics (since competitors may be using the same model)
  • Goes against “agile” BI principles that call for small, quick, tangible deliverables
  • Goes against top down performance management design and modeling best practice's, where one does not start with a logical data model but rather
    • Defines departmental, line of business strategies   
    • Links goals and objectives needed to fulfil these strategies   
    • Defines metrics needed to measure the progress against goals and objectives   
    • Defines strategic, tactical and operational decisions that need to be made based on metrics
    • Then, and only then defines logical model needed to support the metrics and decisions  "

Leave a Reply

captcha *