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:

 

image

 

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

Advertisements

2 thoughts on “BI Administration: The Business Intelligence Management Data Mart”

  1. Chris – this is great stuff. I’ve been working on a similar project but I really like how you moved everything into a dimensional model – especially since it’s very possible that a DBA (who might not be super-familiar with SSAS/SSIS/SSRS) will be charged with monitoring these services… and dimensional models are awesome from an intuition standpoint.

    Solid contribution 😉

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s