Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

BI Administration: The Business Intelligence Management Data Mart

  • 1 October 2013
  • Author: Chris Schmidt
  • Number of views: 9466
  • 0 Comments

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.

Print
Categories: Analysis Services
Tags:
Rate this article:
No rating

Please login or register to post comments.