Book 2012

Pro SQL Server 2012 BI Solutions

Authors:

ISBN: 978-1-4302-3488-3 (Print) 978-1-4302-3489-0 (Online)

Table of contents (19 chapters)

  1. Front Matter

    Pages i-xxvii

  2. Chapter

    Pages 1-12

    Business Intelligence Solutions

  3. Chapter

    Pages 13-84

    A Big-Picture Overview

  4. Chapter

    Pages 85-129

    Planning Solutions

  5. Chapter

    Pages 131-159

    Designing a Data Warehouse

  6. Chapter

    Pages 161-211

    Creating a Data Warehouse

  7. Chapter

    Pages 213-251

    ETL Processing with SQL

  8. Chapter

    Pages 253-300

    Beginning the ETL Process with SSIS

  9. Chapter

    Pages 301-334

    Concluding the ETL Process with SSIS

  10. Chapter

    Pages 335-388

    Beginning the SSAS Project

  11. Chapter

    Pages 389-434

    Configuring Dimensions with SSAS

  12. Chapter

    Pages 435-481

    Creating and Configuring SSAS Cubes

  13. Chapter

    Pages 483-528

    Additional Cube and Dimension Configurations

  14. Chapter

    Pages 529-564

    Creating Reports with SQL Queries

  15. Chapter

    Pages 565-614

    Reporting with MDX Queries

  16. Chapter

    Pages 615-652

    Reporting with Microsoft Excel

  17. Chapter

    Pages 653-691

    Creating Reports with SSRS

  18. Chapter

    Pages 693-729

    Configuring Reports with SSRS

  19. Chapter

    Pages 731-766

    Testing and Tuning BI Solutions

  20. Chapter

    Pages 767-795

    Approve, Release, and Prepare

  21. Back Matter

    Pages 797-806