We have mentioned Kimball Bus Matrix a few times on our websites and explained it in more details in Kimball bus matrix.
Let's just remind ourselves the importance Kimball of Bus Matrix. It is used as a planning tool and it effectively communicates how data warehouse is structured to business users... Personally I'm of an opinion that business can design their data warehouse themselves! with little help and key element is to have quick training session and give business user a template and help them with key concepts. I also use Kimball Bus Matrix to represent high level view of the "cube" so business users can actually have something they can understand (not just someone is building a cube for us but we haven't got a clue what that means!)
Kimball Bus Matrix is high level view but personally I believe it should be much more detailed and should be key document which works like a bridge between IT and Business and also can be used to track progress.
So Katie & Emil decided to build a Bus Matrix spreadsheet template and we have used it several times now and it works very well!
Download Bus Matrix Template
You can download the spreadsheet using the following link Katie and Emil Bus Matrix Spreadsheet Template
We don't provide details on how to use the spreadsheet as we have come across a few limitation but this prototype (project) helped us realize how important it is and we have few ideas we want to implement and move it to much more robust foundations! We hope to build very useful solution and share it with everyone if things go ok we hope to do a session at next SQL Bits! which might be in Spring 2013!
We hope you will find our current template useful
Katie & Emil