Apress Cyber Monday SALE

Foundations of SQL Server 2008 R2 Business Intelligence

2nd Edition

By Guy Fouche , Lynn Langit

  • eBook Price: $34.99 $10.00
  • Print Book Price: $49.99
Buy eBook Buy Print Book
Foundations of SQL Server 2008 R2 Business Intelligence introduces the entire exciting gamut of business intelligence tools included with SQL Server 2008.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-3324-4
  • 448 Pages
  • User Level: Beginner to Advanced
  • Publication Date: March 31, 2011
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • SQL Server T-SQL Recipes
  • Next Generation Databases
  • Pro Salesforce Analytics Cloud
  • Dashboards for Excel
  • User Group Leadership
  • Expert Performance Indexing in SQL Server
  • Expert SQL Server in-Memory OLTP
  • Develop on Yammer
Full Description

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

What you’ll learn

  • Apply dimensional- and fact-based modeling to create OLAP schemas
  • Optimize data extraction and transformation with SQL Server Integration Services
  • Develop OLAP and data-mining solutions using SQL Server Analysis Services
  • Create compelling reports using the new Report Builder 3.0 in SQL Server Reporting Services
  • Deliver self-service business-intelligence via Microsoft PowerPivot
  • Manage and maintain control over your business intelligence environment

Who this book is for

Foundations of SQL Server 2008 R2 Business Intelligence is for business intelligence analysts and developers wanting to employ the full stack of business intelligence tools that are part of SQL Server. The book also appeals to database administrators managing databases in support of business intelligence efforts.

Table of Contents

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

If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.

On page 78:
I did what is explained on page 78 (Creating Attribute Relationships) on Dimension Date, I got an error message when I process the cube :
"Erreurs dans le moteur de stockage OLAP :
Un doublon de clé d'attribut a été trouvé lors du traitement de : Table : 'dbo_DimDate', Colonne : 'MonthNumberOfYear', Valeur : '7'. L'attribut est 'Month Number Of Year'."
Is anyone had the same thing ?

On page 367:

In the Summary - The last area we covered was the new and powerful capability to associate assemblies with SSAS.

I didn't see anything about associating assemblies with SSAS.


    1. The Definitive Guide to MongoDB: Third Edition

      $34.99 $10.00

      View Book

    2. SQL Server T-SQL Recipes

      $41.99 $10.00

      View Book

    3. Big Data Made Easy

      $31.99 $10.00

      View Book

    4. Expert T-SQL Window Functions in SQL Server

      $17.99 $10.00

      View Book