An essential step in a mature data warehousing development and code promotion process, peer review can be included in many data warehouse development phases, including data model development and ETL process creation. Incorporating a peer review into your data warehouse development process not only ensures the end deliverable is up to snuff, it also helps to train the developer and set of peers on best practices. The questions that you may have are ‘what is a peer review?’ and ‘how do I perform one?’ Let’s answer both of these questions.

What is a peer review?

A peer review is when one of your ‘peers’ reviews a deliverable that you are working on prior to moving the deliverable into the next environment. Let’s break that definition down into its separate pieces: