Foundation of SQL Server 2008 R2 Business Intelligence

'Foundations of SQL Server 2008 R2 Business Intelligence' introduces the exciting gamut of business intelligence tools included with SQL Server 2008. Microsoft has designed SQL Server 2008 to be more than just a database. It's a complete business intelligence (BI) platform. The database is at the core, and surrounding the database are tools for data mining, modeling, reporting, analyzing, charting, and integration with other, enterprise-level software packages.

Here is just some of what you can do:
- Create dimensional- and fact-based OLAP schemas
- Extract, transform, and load with Integration Services
- Mine for business intelligence using Analysis Services
- Create and deliver reports via Reporting Services
- Implement PowerPivot for self-service BI

SQL Server 2008 puts an incredible amount of BI functionality at your disposal. But how do you take advantage of it? That's what this book is all about. Authors Guy Fouché and Lynn Langit show how to implement end-to-end BI solutions using SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and other tools in the Microsoft BI toolkit. You'll learn about all-new features such as PowerPivot and Report Builder 3.0. Also provided are clear examples of predictive analysis made possible through powerful data mining features in SQL Server.