Summary

BI provides a consistent view of the data across the entire organization. In addition, it relieves the contention possibilities and provides a means for historical reporting of your operations data. In the end, your organization has the capability to provide secure and accurate data without the complexities and dependencies on your OLTP system.

The concepts introduced in this chapter should provide a foundation that prepares you to leverage the Integration and Analysis Services chapters in this book.

Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.