Brock Beatty

Mar 22 2011

Delivering Data Warehousing and BI Projects using Agile - Follow up

A follow up to Delivering Data Warehousing and BI Projects using Agile:

Working as a data architect on an Agile data warehouse project for a financial services client, I had the opportunity to support multiple warehouse delivery “bays”.  Of all the lessons learned, one thing that I would highly suggest to any organization looking to embark on an Agile data warehouse delivery project, would be a solution architected to leverage a tiered data architecture that clearly separates a persistent staging environment from the integrated subject areas of an analytical data warehouse. Decoupling the “base layer” from the integrated subject areas can provide significant advantages to project teams supporting the warehouse build.

Read More

Dec 07 2010

Metaprogramming and a Generative Approach

When it comes to metaprogramming, even the most technical folks can find their eyes rolling back into their heads.  I’ll admit, with all of the fun and new technologies out there, a discussion about metaprogramming is, in the name of brutal honesty, just outright boring…  but, so is being addicted to brute force.

During a recent ETL implementation using T-SQL, changes in architecture and scope began to threaten the project’s delivery dates. I desperately wanted to begin development but feared throw away work resulting from requirement changes coming out of ongoing design and analysis discussions. How do you develop code without a finalized set of requirements and prevent re-writing each piece of code when requirements change?

Read More

 

Disclaimer

The words and opinions expressed here are those of each article's respective author, and do not necessarily represent the views of CapTech Ventures.