BI Administration: The Business Intelligence Management Data Mart

Firstly, I’d like to thank everyone who attended my session this morning for Pragmatic Works Training on the T’s. I always enjoy presenting, Today’s topic was about management and administration of business intelligence solutions. The theme of the overall presentation was that although there are many ways to collect the meta data around our business intelligence solution, the data itself still lends itself to a dimensional structure, that we can use to model into various facts and dimensions. Below is a data model that represents performance between ssis, ssas, and ssrs. These are key performance metrics surrounding these 3 development tools. As developers/administrators, it is our responsibility to ensure that we maintain and monitor this information to adhere to SLA’s and ensure timely performance. A overall diagram of the architecture would look like the below:




A complete recording of the webcast is available here, and the complete solution and database backup is available here.