Tools
Data Warehouse Bus Matrix Excel Template
“I’ve used this Bus Matrix spreadsheet on all my projects to help design, plan and estimate data warehouses and communicate the scope and progress to stakeholders.”
Use the data warehouse matrix to:
Document Design – Document the high-level design of your data warehouse
Estimate – Rate facts and dimensions by complexity. The spreadsheet automatically generates estimates.
Plan – Make sprints that adhere to a master design.
Collaborate – Share the Matrix and design with other developers.
Communicate – Easily communicate the scope, coverage, progress and high-level design to stakeholders.
Get the Data Warehouse Bus Matrix Template ->
Legacy Tools:
SSAS Documentation Generator
The SSAS document generator is a simple command line script that generates a Data Dictionary for an SSAS Cube. The Data Dictionary is output in HTML, with links between entities. You can modify the style of the HTML to suit your requirements.
Automate build and deployment of SSAS Cubes using MSBUILD
Downloadable script that shows you how to use MSBUILD to automate the build and deployment of an SSAS Analysis Services Cube.