Foundations of SQL Server 2008 R2 Business Intelligence

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire 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 its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages.

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 business intelligence toolkit. You’ll learn about all-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.

If you’re an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can’t afford to be without this book; you can’t afford to ignore the powerful business intelligence suite that Microsoft has placed at your disposal.

  • Provides the "big picture" of Microsoft’s BI tool suite
  • Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2
  • Gives a practical analysis of features based on real-world practices
1100384889
Foundations of SQL Server 2008 R2 Business Intelligence

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire 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 its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages.

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 business intelligence toolkit. You’ll learn about all-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.

If you’re an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can’t afford to be without this book; you can’t afford to ignore the powerful business intelligence suite that Microsoft has placed at your disposal.

  • Provides the "big picture" of Microsoft’s BI tool suite
  • Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2
  • Gives a practical analysis of features based on real-world practices
49.99 In Stock
Foundations of SQL Server 2008 R2 Business Intelligence

Foundations of SQL Server 2008 R2 Business Intelligence

Foundations of SQL Server 2008 R2 Business Intelligence

Foundations of SQL Server 2008 R2 Business Intelligence

eBook2nd ed. (2nd ed.)

$49.99 

Available on Compatible NOOK devices, the free NOOK App and in My Digital Library.
WANT A NOOK?  Explore Now

Related collections and offers


Overview

Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire 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 its core, and surrounding the core are tools for data mining, modeling, reporting, analyzing, charting, and integration with other enterprise-level software packages.

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 business intelligence toolkit. You’ll learn about all-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.

If you’re an analyst or developer working with SQL Server 2008 who is charged with delivering results that drive business success, you can’t afford to be without this book; you can’t afford to ignore the powerful business intelligence suite that Microsoft has placed at your disposal.

  • Provides the "big picture" of Microsoft’s BI tool suite
  • Covers PowerPivot and other game-changing technologies introduced alongside SQL Server 2008 Release 2
  • Gives a practical analysis of features based on real-world practices

Product Details

ISBN-13: 9781430233251
Publisher: Apress
Publication date: 08/12/2011
Sold by: Barnes & Noble
Format: eBook
Pages: 448
File size: 19 MB
Note: This product may take a few minutes to download.

About the Author

Guy Fouch is a business intelligence and decision support system consultant in the Dallas, Texas area. Guy spends his evenings playing one of his eight trumpets and expanding his composition skills using the current generation of music technologies. On the weekend, he puts as many miles as he can on his bright yellow Honda F4i sport motorcycle. Guy and Jodi enjoy taking nine-day trips in their Jeep 4x4, taking photographs and writing travelogs along the way. You can view their photography at http://photography.fouche.ws.

Table of Contents

  1. What Is Business Intelligence?
  2. OLAP Modeling Concepts
  3. Introducing OLAP Modeling with SSAS
  4. Intermediate OLAP Modeling with SSAS
  5. Advanced OLAP Modeling with SSAS
  6. Cube Storage and Aggregation
  7. Introducing SSIS
  8. Intermediate SSIS
  9. Advanced SSIS
  10. Reporting Tools
  11. Data Mining with Excel
  12. Introducing PowerPivot
  13. Introduction to MDX
  14. Introduction to Data Mining
From the B&N Reads Blog

Customer Reviews