Chapter 14. Pervasive Insight

Andrew Brust

Despite this book’s detailed focus on the relational database engine, and transactional use, of Microsoft SQL Server, it’s imperative to realize and discuss the product’s wide range of business intelligence (BI) capabilities, some of which are arguably the best in the industry. Depending on the edition of SQL Server you purchase, you will have access to some or all of the following services:

  • Data Warehousing

  • Reporting and data visualization

  • Online analytical processing (OLAP)

  • Column store, in-memory analytics

  • Data Mining

  • Extract, Transform and Load (ETL)

  • Complex event processing (CEP)

  • Master Data Management (MDM)

  • Data Quality.

Note

We’ll cover SQL Server editions, and their included BI feature sets, at the end of ...

Get Programming Microsoft® SQL Server® 2012 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.

Start your free trial