Skip to main content
  • Book
  • © 2011

Foundations of SQL Server 2008 R2 Business Intelligence

Apress
  • Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008.

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (14 chapters)

  1. Front Matter

    Pages i-xv
  2. What Is Business Intelligence?

    • Guy Fouché, Lynn Langit
    Pages 1-24
  3. OLAP Modeling Concepts

    • Guy Fouché, Lynn Langit
    Pages 25-51
  4. Introducing OLAP Modeling with SSAS

    • Guy Fouché, Lynn Langit
    Pages 53-81
  5. Intermediate OLAP Modeling with SSAS

    • Guy Fouché, Lynn Langit
    Pages 83-105
  6. Advanced OLAP Modeling with SSAS

    • Guy Fouché, Lynn Langit
    Pages 107-129
  7. Cube Storage and Aggregation

    • Guy Fouché, Lynn Langit
    Pages 131-160
  8. Introducing SSIS

    • Guy Fouché, Lynn Langit
    Pages 161-186
  9. Intermediate SSIS

    • Guy Fouché, Lynn Langit
    Pages 187-236
  10. Advanced SSIS

    • Guy Fouché, Lynn Langit
    Pages 237-270
  11. Reporting Tools

    • Guy Fouché, Lynn Langit
    Pages 271-299
  12. Data Mining with Excel

    • Guy Fouché, Lynn Langit
    Pages 301-328
  13. Introducing PowerPivot

    • Guy Fouché, Lynn Langit
    Pages 329-346
  14. Introduction to MDX

    • Guy Fouché, Lynn Langit
    Pages 347-367
  15. Introduction to Data Mining

    • Guy Fouché, Lynn Langit
    Pages 369-402
  16. Back Matter

    Pages 403-427

About this book

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

About the authors

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.

Bibliographic Information

Buy it now

Buying options

eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 49.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access